SQL*Plus

[knowitnot]

i'm not sure what the problem is, but my attempt to start SQL*Plus returns the following two errors:
ORA-01034: Oracle not available and ORA-27101: shared memory realm does not exist.

My installation passed all tests so I'm pretty sure something is not being pointed in the right direction. I've attached my listner.ora file. Any thoughts?


# listener.ora Network Configuration
File: /home/oracle/product/10.1.0/Db_2/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
#BEQUEATH CONFIG
(GLOBAL_DBNAME=sales.mydb.com)
(SID_NAME=sales)
(ORACLE_HOME = /home/oracle/product/10.1.0/Db_2)
#PRESPAWN CONFIG
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.mydb.com)(PORT = 1521))
)
)
)

 

[SantaMufasa]

KnowItNot,

Your Oracle instance is not running. Do you have DBA privileges on the machine that should be running the Oracle instance? If so,

% sqlplus /nolog
SQL> connect / as sysdba
SQL> startup

Otherwise, if you are not a DBA, then have her/him do the above. Then retry your SQL*Plus connection.

Let us know your results/findings.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[stefanhei]

ps -eaf |grep ora

will tell you if your instance is running (=processes show up) and who started them.
If there are no processes follow Dave's advice.
If there are processes check who started the instance (=who owns the processes). You then may have to stop the instance first and then start it.

Stefan

 

[knowitnot]

thanks for you help guys. i used the commands per Dave's advice and was able to successfully connect.

the database is only a piece of a more complicated test server for a ERP system - Compiere. Thanks for getting me past the first hurdle.