topic Re: ORA-01034 in Operating System - HP-UX

ORA-01034

dngaya — Tue, 09 Dec 2003 06:42:16 GMT

hello,
I have a base of database oracle 7.3.4 on HP 10.20 test1 and another database of database oracle 8.0.5 called test2. on test1, I have create a database link towards front test2, the database link walked well but this weed-kend, we installed the database test2 on a new waiter but since the database link of test1 towards test2 became inactive and it posts the following result:
ORA-02068: following severe error from PTFPRD
ORA-01034: ORACLE not available
and yet the old base is to stop and the two bases test1 and test2 are active.
I do not understand how to resolve this ?.
thank for your assistance .

Re: ORA-01034

Massimo Bianchi — Tue, 09 Dec 2003 07:10:52 GMT

Hi,
sorry but i do not think to understand weel what a "waiter" is...

I can think of teo causes: tnsnames.ora and not existing user on database test2.

tnsnames.ora: maybe you are still pointing to the old test2, check that with a sqlplus and see if you can login

not existing user: a dblink requires a user to work, check if this user exists on the new db.

HTH,
Massimo

Re: ORA-01034

Jean-Luc Oudart — Tue, 09 Dec 2003 07:14:01 GMT

Hi,

no offence but "serveur" is waiter in a restaurant. In the machine room, we just call it "server".

So, you change server. Did you update your tnsnames.ora ?
Can you connect from 1st server to 2nd server with a sqlplus session :
sqlplus user/pass@connection_string

Regards,
Jean-Luc

Re: ORA-01034

dngaya — Tue, 09 Dec 2003 07:16:33 GMT

hi,
yes , i can to connect on server test1 and on server test2.

Re: ORA-01034

Jean-Luc Oudart — Tue, 09 Dec 2003 07:45:03 GMT

Dngaya,

have you tried to delete and re-create the dblink ?
Otherwise, this may look like an old bug.
I suppose you have access to Metalink.
You can check docid 493951.999 "ora-02068 and ora-03114 while using DBlink"

Regards,
Jean-Luc

Re: ORA-01034

dngaya — Tue, 09 Dec 2003 07:54:08 GMT

hello, in connection with my problem, indeed, after checking, the process of the listener of old database TEST2 was incur active after having it delete, the database link is now good.
thank you for your assistance.