ORA-01034

[dngaya]

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 .

[Massimo Bianchi]

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

[Jean-Luc Oudart]

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

[dngaya]

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

[Jean-Luc Oudart]

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

[dngaya]

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.