OraFAQ Forum: Networking and Gateways » ORA-010354

Home » RDBMS Server » Networking and Gateways » ORA-010354 - Oracle Not Available

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-010354 - Oracle Not Available [message #67023]

Fri, 06 June 2003 07:11

Yash Vijayvergiy
Messages: 6
Registered: March 2003

Junior Member

Unable to connect to ORACLE 9i from NT Machine on Sun Solaris. Have two Installations of Oracle 8i and 9i. Able to connect 8i w'out any problem but not 9i. Checked with listener.ora, tnsnames.ora and tnsping. All works fine.
Listener Names are:

Listener --> oracle8i.
Listener1 --> oracle9i.

Both under difft. user and partition and configured w.r.t difft ports 1521 and 9999 respectively.

It is very urgent.

thnx in Advance.

Yash

Report message to a moderator

Re: ORA-010354 - Oracle Not Available [message #67026 is a reply to message #67023]

Sun, 08 June 2003 06:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

your server is 9i and 8i in solaris
and client in 9i.
right?
try changeing SERVICE_NAME to SID in your tnsnames.ora file.

Report message to a moderator

Re: ORA-010354 - Oracle Not Available [message #67027 is a reply to message #67026]

Sun, 08 June 2003 22:55

Yash Vijayvergiy
Messages: 6
Registered: March 2003

Junior Member

Thnx for prompt reply Mahesh. My client is Oracle 8i Server itself and w.r.t to Solaris it is 8i client.

I have installed Oracle 8i server on my system and other systems (Windows OS) connect to my system as a client.

Report message to a moderator

Re: ORA-010354 - Oracle Not Available [message #67029 is a reply to message #67027]

Mon, 09 June 2003 06:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please post the complete error message,
your tnsnames.ora ( from the clients)
your listener.ora ( from the server)

Report message to a moderator

Re: ORA-01034 - Oracle Not Available [message #67030 is a reply to message #67029]

Mon, 09 June 2003 07:12

Yash Vijayvergiy
Messages: 6
Registered: March 2003

Junior Member

ORA-01034: ORACLE Not Available

There may be error in the fields entered, or the server may not be ready for the connection.

tnsnames.ora (From Clients)
# TNSNAMES.ORA Network Configuration File: D:OracleOra81NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.

NEWDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = amt31)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = NEWDB)
)
)

SUN28I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = gtlbo1)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SUN29I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = amtrix)
)
)

######################################################

listener.ora (From Server)

# LISTENER.ORA Network Configuration File: /disk2/databases/ora920/network/admin/listener.ora
# Generated by Oracle configuration tools.
(ORACLE 9i)
LISTENER1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = 5555))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.11)(PORT = 9999))
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtPro)
(ORACLE_HOME = /disk2/databases/ora920)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = AMTRIX)
(ORACLE_HOME = /disk2/databases/ora920)
(SID_NAME = amtrix)
)
)

######################################################

(ORACLE 8i)
# LISTENER.ORA Network Configuration File: /disk2/databases/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.11)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.11)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /disk2/databases/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = gtlbo1)
(ORACLE_HOME = /disk2/databases/oracle)
(SID_NAME = gltbo1)
)
)

Report message to a moderator

Re: ORA-01034 - Oracle Not Available [message #67031 is a reply to message #67030]

Mon, 09 June 2003 08:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

ORA-01034 means
the database is not up and running.
login to the server directly
and checkt the availablity of database

Report message to a moderator

Re: ORA-01034 - Oracle Not Available [message #67033 is a reply to message #67031]

Mon, 09 June 2003 23:08

Yash Vijayvergiy
Messages: 6
Registered: March 2003

Junior Member

Checked with everything. Listener is started, Database is up.

Infact, checked with 2-3 time shutting down and starting database and restarting listener same number of time.

For me everything looks fine as far as I know, but still unable to solve the problem.

Report message to a moderator

Re: ORA-01034 - Oracle Not Available [message #67046 is a reply to message #67033]

Thu, 03 July 2003 07:41

Yash Vijayvergiy
Messages: 6
Registered: March 2003

Junior Member

Hi Everyone,
I solved the problem. I configured two different listeners on two different ports apart from the default one's (1521).

1522 and 1524 are the present ports of the two listeners.

Report message to a moderator

Re: ORA-01034 - Oracle Not Available [message #67239 is a reply to message #67046]

Fri, 27 February 2004 04:52

Amit
Messages: 166
Registered: February 1999

Senior Member

Hi Everyone,
I solved the problem. I configured two different listeners on two different ports apart from the default one's (1521).
1522 and 1524 are the present ports of the two listeners.

Report message to a moderator

Re: ORA-01034 - Oracle Not Available [message #67300 is a reply to message #67031]

Tue, 13 April 2004 04:47

Dipesh Mistry
Messages: 1
Registered: April 2004

Junior Member

Solution

Using Oracle Client 92040, under NT(W2000)
after restarting the database, and trying to connect, getting:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
probably you should change
sqlnet.ora (located in $(ORA_HOME)networkadmin)

change the following parameter:

SQLNET.AUTHENTICATION_SERVICES=(NTS)
to
SQLNET.AUTHENTICATION_SERVICES=(NONE)

Restart your database service and you should be good to go.

Report message to a moderator

Previous Topic:	unable to connect to database from d2k rel 2.1
Next Topic:	Problems with JDBC-Connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 22:27:14 CDT 2024