title: Moved Oracle 11.2 XE Database Directory, Connected to Idle Instance
body: <p>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...</p>
  
  <pre><code>$ cp -R /u01/app/* /oracle
  $ rm -rf /u01/app/oracl
  $ ln -s /oracle/oracle /u01/app/oracle
  </code></pre>
  
  <p>Then restarted the listener and the database. Now when I attempt to run the following as the user 'oracle' I get a message...</p>
  
  <pre><code>$ sqlplus
  Enter user-name: sys / as sysdba
  Enter password: ****
  Connected to idle instance.
  </code></pre>
  
  <p>Further, when I attempt a startup I get an error.</p>
  
  <pre><code>&gt; startup
  ORA-45301: XE Edition single instance violation error
  </code></pre>
  
  <p>I have attempted the solutions found <a href="http://www.javamonamour.org/2011/08/ora-44410-xe-edition-single-instance.html" rel="nofollow">here</a> to no avail. </p>
  
  <p>Here is the output for my listener controller:</p>
  
  <pre><code>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
  </code></pre>
  
  <p>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.</p>
  
  <p>EDIT</p>
  
  <p>Some further information to help clarify my system...</p>
  
  <pre><code>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
  </code></pre>
  
  <p>FURTHER EDIT</p>
  
  <p>Attempting to sign in to sqlplus using the SYSTEM user returned an error:</p>
  
  <pre><code>ORA-01034: ORACLE not available
  ORA-27101: shared memory realm does not exist
  Linux-x86_64 Error: 2: No such file or directory
  </code></pre>
  
  <p>FURTHER EDIT</p>
  
  <p>Output of the ipcs command</p>
  
  <pre><code>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
  </code></pre>