| could not connect to oracle db [message #181499] |
Mon, 10 July 2006 06:07  |
antz1116
Messages: 5
Registered: July 2006
|
Junior Member |
|
|
Hi!
I am using Oracle on Solaris and I could not connect to the db becuase of the following:
bash-2.03$ sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jul 10 18:57:09 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect ts/ts@TS
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Please advise.
Thank you.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: could not connect to oracle db [message #181570 is a reply to message #181558] |
Mon, 10 July 2006 10:49  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
You could also try to start the DB from the SQLPlus prompt if you are the oracle user, to see if there are problems during startup, like :
$> export ORACLE_SID=TS
$> sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Mo Jul 10 17:45:37 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> startup;
ORACLE instance started.
Total System Global Area 253199856 bytes
Fixed Size 742896 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
Database mounted.
Database opened.
SQL>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
