Link to home
Start Free TrialLog in
Avatar of jcob_l
jcob_l

asked on

rman error

[oracle@newmac bin]$ export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db
[oracle@newmac bin]$ export ORACLE_SID=post
[oracle@newmac bin]$ cd /oracle/app/oracle/product/11.2.0/db
[oracle@newmac db]$ TNS_ADMIN=/oracle/app/oracle/product/11.2.0/db/network/admin
[oracle@newmac db]$ tnsping post

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 23-SEP-2013 12:41:47

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = newmac)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = post)))
OK (60 msec)
[oracle@newmac db]$ ./rman catalog rman/rman@post target /
bash: ./rman: No such file or directory
[oracle@newmac db]$ rman catalog rman/rman@post target /

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 23 12:42:51 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: POST (DBID=4292858366)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[oracle@newmac db]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-SEP-2013 12:43:06

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
[oracle@newmac db]$
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jcob_l
jcob_l

ASKER

post is different database..

rman catalog is in test

we want to register post datbase in rman catalog in test db


which step I make error
>>rman catalog is in test


Then you should set your ORACLE_SID to test not post.

re: [oracle@newmac bin]$ export ORACLE_SID=post
Avatar of jcob_l

ASKER

I did so far this much

what is next

[oracle@newmac dbs]$ export ORACLE_SID=test
[oracle@newmac dbs]$ export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db[oracle@newmac dbs]$ TNS_ADMIN=/oracle/app/oracle/product/11.2.0/db/network/admin
[oracle@newmac dbs]$ TNS_ADMIN=/oracle/app/oracle/product/11.2.0/db/network/admin
>>what is next

Depends on what you are trying to do.

If you want to connect with rman and the catalog, then the command you have is fine.

The issue was 'TARGET /' connects to whatever your ORACLE_SID is set to.  In your initial post, that was POST.
Avatar of jcob_l

ASKER

ok