Re: ORA-01034 ORACLE not available under Sun Solaris


[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Rüdeger Cuwie' on August 08, 2001 at 02:49:41 EST:

In Reply to: ORA-01034 ORACLE not available under Sun Solaris posted by 'Rüdeger Cuwie' on July 23, 2001 at 09:27:54 EST:

Some answer reminded me I should post the solution here:

The reason was very stupid and showed me I should deal with SQL*Net / Net8...

I had treated the target host's tnsnames.ora by copying a section and just changing the instnce names. My wrong CONNECT_DATA clause was:
(CONNECT_DATA =
(SERVICE_NAME = des21)
)

It works fine after I compared my working local tnsnames.ora and the one on my target server in detail and changing this section to:
(CONNECT_DATA =
(SID = des21)
)


Life can be so easy...


Follow Ups:



Post a Followup


Name:
E-Mail:
Subject:

Message:


[ Follow Ups ] [ Post Followup ] [ Message Board ]