RMAN - ORA-12154 TNS:could not resolve service name

[RogersJ]

I have an Oracle 9.2.0.5 database on HPUX-11.0

When the target database is open I can connect to it using RMAN and sqlplus.

Now that I want to perform a recovery of the control file the database is in nomount mode.

I can still connect with sqlplus, but when I connect using RMAN I get:
ORA-12154 TNS:could not resolve service name

Lsnrctl status shows a status of blocked for this database.


Any help would be great.

Jan

 

[Matsul]

I expect the database shold be mounted although not neccessarily open to connect with RMAN.

 

[sem]

Most probably your RMAN is launched from another ORACLE_HOME: this error clearly states that tnsnames.ora file used by rman doesn't contain an appropriate entry. You may either add that entry or make rman to use another (correct) tnsnames.ora file by seting TNS_ADMIN environment variable.

Regards, Dima

http://seminihin.narod.ru