Oracle Database Discussions

Hi all. I have the following scenario.

- Two Oracle versions and instances on the same box (10g Rel2 and 11g Rel2).

- Due to lack of disk space i installed 11g on another ORACLE_BASE / ORACLE_HOME:

- Initial enviroment (10g):

[oracle@VM1 ~]$ echo $ORACLE_BASE
/home/oracle/app
[oracle@VM1 ~]$ echo $ORACLE_HOME
/home/oracle/app/OraDb10g
[oracle@VM1 ~]$ echo $ORACLE_SID
BETA
[oracle@VM1 ~]$ echo $PATH
/home/oracle/app/OraDb10g/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin

- 11g related values:

[oracle@VM1 oracle]$ echo $ORACLE_BASE
/u01/oracle
[oracle@VM1 oracle]$ echo $ORACLE_HOME
/u01/oracle/Oradb11g
[oracle@VM1 oracle]$ echo $ORACLE_SID
ALFA
[oracle@VM1 oracle]$ echo $PATH
/u01/oracle/Oradb11g/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin
[oracle@VM1 oracle]$


Both databases are running including :

- listener 1521 for 10g and 1525 for 11g-

*10g:*

[oracle@VM1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 04-JAN-2013 06:42:27

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VM1.rioturbio.com.ve)(*PORT=1521*)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 04-JAN-2013 05:25:12
Uptime 0 days 1 hr. 17 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/OraDb10g/network/admin/listener.ora
Listener Log File /home/oracle/app/OraDb10g/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM1.rioturbio.com.ve)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "*BETA.azucarera_rioturbio.com.ve*" has 1 instance(s).
Instance "BETA", status READY, has 1 handler(s) for this service...
Service "BETAXDB.azucarera_rioturbio.com.ve" has 1 instance(s).
Instance "BETA", status READY, has 1 handler(s) for this service...
Service "BETA_XPT.azucarera_rioturbio.com.ve" has 1 instance(s).
Instance "BETA", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@VM1 ~]$

*11g:*

[oracle@VM1 oracle]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JAN-2013 06:43:25

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VM1.rioturbio.com.ve)(*PORT=1525*)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-JAN-2013 05:23:02
Uptime 0 days 1 hr. 20 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/Oradb11g/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/VM1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VM1.rioturbio.com.ve)(PORT=1525)))
Services Summary...
Service "*ALFA.rioturbio.com.ve*" has 1 instance(s).
Instance "ALFA", status READY, has 1 handler(s) for this service...
Service "ALFAXDB.rioturbio.com.ve" has 1 instance(s).
Instance "ALFA", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@VM1 oracle]$


- Instances and Enterprise Manager Database Control:

*10g:*

[oracle@VM1 ~]$ emctl status dbconsole
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://VM1.rioturbio.com.ve:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /home/oracle/app/OraDb10g/VM1.rioturbio.com.ve_BETA/sysman/log
[oracle@VM1 ~]$

*11g:*

[oracle@VM1 oracle]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://VM1.rioturbio.com.ve:5500/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/oracle/Oradb11g/VM1.rioturbio.com.ve_ALFA/sysman/log
[oracle@VM1 oracle]$

The problem happen when i try to access the 11g instance using sqlplus:

[oracle@VM1 oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 4 06:46:55 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> show sga
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>

or

[oracle@VM1 oracle]$ sqlplus system/Oradba11g

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 4 06:47:43 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:


However when access is performed using a TNS service connection it works....!

See:

[oracle@VM1 oracle]$ sqlplus system/Oradba11g@alfa

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 4 06:48:48 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> show sga

Total System Global Area 1043886080 bytes
Fixed Size 2219952 bytes
Variable Size 620757072 bytes
Database Buffers 415236096 bytes
Redo Buffers 5672960 bytes
SQL>


Which seems to be the problem here? Why can't i connect to the 11g instance using sqlplus?. I don't think it is related to enviroment since access can be done using local naming service.

Please help ...!

PD: i did not replace scripts on /usr/local/bin when installing 11g.