Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I try to connect to Oracle 11g using:

sqlplus noah/noah@orcl

I get these errors:

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

The service does start up when I connect as sysdba using:

sqlplus /nolog
conn / as sysdba
startup

Here's my listener.ora:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
  (GLOBAL_DBNAME = orcl)
  (ORACLE_HOME = /opt/oracle/112)
  (SID_NAME = orcl)
)
)

LISTENER =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = mylinux)(PORT = 1521))
)

And the tnsnames.ora:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mylinux)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
)
)

Here is the sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)

Could anyone give me a hand making this work?

share|improve this question

migrated from stackoverflow.com Dec 22 '11 at 14:06

This question came from our site for professional and enthusiast programmers.

2  
Did you start the listener? When you conn / as sysdba, you don't use it, but as soon as you specify a TNS entry like @orcl, you will –  fge Dec 21 '11 at 15:51
    
I've started it! –  Shuo Dec 22 '11 at 3:04
1  
And what does lsnrctl status say? Do you see your orcl service? –  fge Dec 22 '11 at 8:10
    
Yes,the orcl service has started! –  Shuo Dec 26 '11 at 13:49
1  
Are you sure the startup completes successfully? What is the status of your instance (eg: do a SELECT status, instance_name FROM v$instance; as a user with DBA privileges) –  NullUserException Dec 28 '11 at 0:31
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.