| direct connexion [message #98189] |
Fri, 30 April 2004 04:42  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
