Home » Infrastructure » Linux » Moved Database Directory, Connected to Idle Instance (Oracle 11.2 XE on Red Hat Enterprise Linux 6.6)
icon4.gif  Moved Database Directory, Connected to Idle Instance [message #634583] Wed, 11 March 2015 11:35 Go to next message
SBlancher
Messages: 3
Registered: March 2015
Location: Canada
Junior Member

So I will start off by stating I have moved the regular install location of Oracle 11.2 XE to a logical volume (/oracle) I had created on my RHEL 6.6 server. After shutting down both the database and the Oracle listener, I performed...

$ cp -R /u01/app/* /oracle
$ rm -rf /u01/app/oracl
$ ln -s /oracle/oracle /u01/app/oracle

Then restarted the listener and the database. Now when I attempt to run the following as the user 'oracle' I get a message...

$ sqlplus
Enter user-name: sys / as sysdba
Enter password: ****
Connected to idle instance.

Further, when I attempt a startup I get an error.

> startup
ORA-45301: XE Edition single instance violation error

I have attempted the solutions found here to no avail.

Here is the output for my listener controller:

bash-4.1$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-MAR-2015 10:26:25

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 10-MAR-2015 10:25:57
Uptime 0 days 0 hr. 0 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dev/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dev)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

I'm really quite lost as to what to attempt next. I know I could just reinstall and keep the directory in its proper location but I need it to be in it's own logical volume.

EDIT

Some further information to help clarify my system...

bash-4.1$ env | grep ORA
ORACLE_SID=XE
ORACLE_BASE=/oracle/oracle
ORACLE_HOME=/oracle/oracle/product/11.2.0/xe

bash-4.1$ env | grep TNS
TNS_ADMIN=/oracle/oracle/product/11.2.0/xe/network/admin

bash-4.1$ ps -aux | grep pmon
oracle 2431 0.0 0.2 1265956 16652 ? Ss 11:43 0:00 xe_pmon_XE

FURTHER EDIT

Attempting to sign in to sqlplus using the SYSTEM user returned an error:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

FURTHER EDIT

Output of the ipcs command

bash-4.1$ ipcs

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0xc0a59444 32768 oracle 660 4096 0

------ Semaphore Arrays --------
key semid owner perms nsems
0xd4a9963c 229378 oracle 660 104
0x884d8f34 491523 oracle 660 104

------ Message Queues --------
key msqid owner perms used-bytes messages
Re: Moved Database Directory, Connected to Idle Instance [message #634592 is a reply to message #634583] Wed, 11 March 2015 12:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>bash-4.1$ ps -aux | grep pmon
>oracle 2431 0.0 0.2 1265956 16652 ? Ss 11:43 0:00 xe_pmon_XE
above indicates XE instance already exists

what results after you reboot the OS?

Re: Moved Database Directory, Connected to Idle Instance [message #634598 is a reply to message #634592] Wed, 11 March 2015 13:55 Go to previous messageGo to next message
SBlancher
Messages: 3
Registered: March 2015
Location: Canada
Junior Member

The exact same as before. The oracle-xe service is started on boot. That is kind of the problem, the instance that exists is idle. Then when I attempt to startup it is trying to start a new instance (which isn't allowed in XE). As well, when you try any type of command in sqlplus it says oracle is not available (ORA-01034).
Re: Moved Database Directory, Connected to Idle Instance [message #634599 is a reply to message #634598] Wed, 11 March 2015 14:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//          the problem mentioned in the other messages. 
//          If Oracle has been initialized, then on some operating systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.


post excerpt from alert_XE.log file that shows the startup errors
Re: Moved Database Directory, Connected to Idle Instance [message #634600 is a reply to message #634599] Wed, 11 March 2015 16:45 Go to previous messageGo to next message
SBlancher
Messages: 3
Registered: March 2015
Location: Canada
Junior Member

Just to let anyone know, this issue has been resolved.
Re: Moved Database Directory, Connected to Idle Instance [message #634601 is a reply to message #634600] Wed, 11 March 2015 17:22 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SBlancher wrote on Wed, 11 March 2015 14:45
Just to let anyone know, this issue has been resolved.


to benefit those who come after you, please post what & how this issue was resolved.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/


Previous Topic: How to view my .profile file
Next Topic: Need oracleasm and oraclelib rpm for RHEL 6.1 64 bit
Goto Forum:
  


Current Time: Mon Sep 27 18:11:57 CDT 2021