Home » RDBMS Server » Networking and Gateways » Re: Getting ORA-01034 Oracle not available error ,even though database is up
Re: Getting ORA-01034 Oracle not available error ,even though database is up [message #66543] Sat, 27 July 2002 03:20
Shivakumar
Messages: 6
Registered: May 2000
Junior Member
Hello all,

I have a simillar problem.
Database is on 7.3.4 on solaris. I am able to connect to Db using user/pssw@connect string from 7.3.4 or 8.1.6 Home.

From client(Another solaries m/c) I am able to connect to Db using 8.1.6 home.
But from 7.3.4 i am getting the following error
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment.
SVR4 Error: 2: No such file or directory

looking to u'r Help

7.3.4 tnsname.ora setting
MIRROR=
(description =
(address = (protocol = TCP)(host =server)(port = 1526))
(connect_data = (SID = MIRROR))
)

8.1.6 tns setting on client m/c
MIRROR=
(description =
(address = (protocol = TCP)(host = server)(port = 1526))
(connect_data = (SID = MIRROR))
)
Previous Topic: 8.1.7 client with 9i database
Next Topic: create database
Goto Forum:
  


Current Time: Thu Nov 21 16:17:19 CST 2024