Home » Infrastructure » Unix » direct connexion
direct connexion [message #98189] Fri, 30 April 2004 04:42 Go to next message
Martial
Messages: 9
Registered: April 2004
Junior Member
I have a little problem with my oracle 9.2.0.1.0
I can't connect like this :

SQL>conn system/system
ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No Such file or directory
I must add :

SQL>conn system/system@test
SQL>Connected

NB : I've only one instance in my server.

Someone can help me !!

Thanks
Re: direct connexion [message #98194 is a reply to message #98189] Mon, 03 May 2004 07:59 Go to previous message
Al Glick
Messages: 2
Registered: May 2004
Junior Member
You need to set your ORACLE_SID environment variable to the database name before connecting.

export ORACLE_SID=test
sqlplus /nolog
connect system/system@test

or you can add the line ORACLE_SID=test to your .profile file and it will always be set for you when you logon to the server. Be careful of setting this in your .profile file if you're planning on running multiple Oracle databases on the same server. You could accidentally connect to the wrong database.
Previous Topic: Transforming an embedded PL/SQL exception to exit from shell script
Next Topic: Installation of Oracle 8i/91in Sun solaris
Goto Forum:
  


Current Time: Fri Mar 29 04:51:14 CDT 2024