-
Impossible to connect
Impossible to connect through 2 tiers (sqlplus) to the database, we are getting the following error message :
SQL> conn sys/xxxxx@ora10_linux
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
I have installed & configured 100s of oracle databases and never got this kind of connection problem.
Server :
RedHat 8.0
Client :
Windows 2000 pro
Client : 9.2.0.1.0
Server : 9.2.0.2.0 (fresh installation)
there are no firewall
I couldn't succeed a server-side loopback on the database server neither...
please help, this is very urgent, anyone who had something similar would help me alot, thanks in advance,
Patrick Hamou
Last edited by phamou; 05-15-2003 at 11:15 PM.
Patrick Hamou
Principal Consultant
Renaps Technology Canada inc.
http://www.renaps.com
-
Somebody didn't reboot after setting values in /etc/system?
-
Hi
First check these
a)wheather the database is up and running ?
ps- ef|grep ORA
b)you cann connect locally using a bequeth connection
with specifying the net8 string
c)See metalink note Note:122183.1
regards
Hrishy
-
Check it again the Oracle Server is runing or not also reboot the server.
Hope it will help you
Shailendra
-
still not working
Hi,
The database is running!
I rebooted the server, checked the metalink note (and applied the 9.2.0.2.0 patch) and I still have the same results :(
the error does not look that obvious...
please let me know if you have other ideas,
thanks again,
Patrick Hamou
Principal Consultant
Renaps Technology Canada inc.
http://www.renaps.com
Patrick Hamou
Principal Consultant
Renaps Technology Canada inc.
http://www.renaps.com
-
Hi
Is the instance registered with the listener..Try connecting soemthing like this
export ORACLE_HOME=your_oracle_home
export ORACLE_SID=oracle-sid
sqlplus system/manager --without the net8 string
lemm know what happens
regards
Hrishy
-
I am running Red Hat 8 with Oacle 9.2.0.1 Enterprise with no problems at all
-
Hi
i am not aware of Oracle behaviour with Linux, but I too have faced the same problems on Win Nt 4.0. It happens mainly when the resources available are not enough to allow connections. Try to shutdown any other database and operating system services associated with this database which has been created in this server and then try again.
One more thing, whenever u connect as sys , please connect with the tag (as sysdba).
Thanks
Partha
-
Originally posted by Partha
¡One more thing, whenever u connect as sys , please connect with the tag (as sysdba).
in 9i that´s the only way
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|