Impossible to connect

[phamou]

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

[stecal]

Somebody didn't reboot after setting values in /etc/system?

[hrishy]

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

[shailendra]

Check it again the Oracle Server is runing or not also reboot the server.

Hope it will help you
Shailendra

[phamou]

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

[hrishy]

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

[pando]

I am running Red Hat 8 with Oacle 9.2.0.1 Enterprise with no problems at all

[Partha]

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

[pando]

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