jcob_l
asked on
rman error
[oracle@newmac bin]$ export ORACLE_HOME=/oracle/app/or acle/produ ct/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/orac le/product /11.2.0/db /network/a dmin
[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]$
[oracle@newmac bin]$ export ORACLE_SID=post
[oracle@newmac bin]$ cd /oracle/app/oracle/product
[oracle@newmac db]$ TNS_ADMIN=/oracle/app/orac
[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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>rman catalog is in test
Then you should set your ORACLE_SID to test not post.
re: [oracle@newmac bin]$ export ORACLE_SID=post
Then you should set your ORACLE_SID to test not post.
re: [oracle@newmac bin]$ export ORACLE_SID=post
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/or acle/produ ct/11.2.0/ db[oracle@ newmac dbs]$ TNS_ADMIN=/oracle/app/orac le/product /11.2.0/db /network/a dmin
[oracle@newmac dbs]$ TNS_ADMIN=/oracle/app/orac le/product /11.2.0/db /network/a dmin
what is next
[oracle@newmac dbs]$ export ORACLE_SID=test
[oracle@newmac dbs]$ export ORACLE_HOME=/oracle/app/or
[oracle@newmac dbs]$ TNS_ADMIN=/oracle/app/orac
>>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.
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.
ASKER
ok
ASKER
rman catalog is in test
we want to register post datbase in rman catalog in test db
which step I make error