hussainkhan22
asked on
ora-12170
C:\oracle\product\10.2.0\d b_1\BIN>rm an target sys/sys@oracle10
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 30 11:38:44 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12170: TNS:Connect timeout occurred
I really appreciate your help. Thanks in advance
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 30 11:38:44 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12170: TNS:Connect timeout occurred
I really appreciate your help. Thanks in advance
Check if you can login using SQLPLUS using "sys/sys@oracle10 as sysdba". If not fix the SQLNET/TNS issue and then proceed with RMAN backup.
ASKER
I am able to connect using SQLPLUS using sys/sys@oracle10 as sysdba.
C:\oracle\product\10.2.0\d b_1\BIN>sq lplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 30 14:33:40 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> host
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\oracle\product\10.2.0\d b_1\BIN>rm an target sys/sys@oracle10
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 30 14:35:23 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12170: TNS:Connect timeout occurred
So now what shall I do to resolve the issue. I really appreciate your help.
C:\oracle\product\10.2.0\d
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 30 14:33:40 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> host
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\oracle\product\10.2.0\d
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Nov 30 14:35:23 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12170: TNS:Connect timeout occurred
So now what shall I do to resolve the issue. I really appreciate your help.
"/" and using "@oracle10" do two different things. One does a direct connect. The other uses SQLNet.
sqlplus "/ as sysdba" is not the same as: sqlplus "sys/sys@oracle10 as sysdba"
try: rman target /
sqlplus "/ as sysdba" is not the same as: sqlplus "sys/sys@oracle10 as sysdba"
try: rman target /
ASKER
But I have multiple Oracle homes and multiple databases. Still do you want me to use rman target /
what might be the solution for ora: 12170 error
what might be the solution for ora: 12170 error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where do I need to set ip address 127.0.0.1 on windows xp . really appreciate your help. Thanks once again
I told you the files:
tnsnames.ora and listener.ora for the instances that are installed locally.
tnsnames.ora and listener.ora for the instances that are installed locally.
Hi,
As per the message you got, it seems that your database is not open currently. Inorder to connect to a database remotely the instance has to be started.
First start the instance and then connect to the rman. Also if you'r connecting using Oracle Net then you need to mentioned the password that you have given in your password file.
Try this..
> set oracle_home=C:\oracle\prod uct\10.2.0 \db_1
> set oracle_sid=oracle10
> sqlplus / as sysdba
> startup
>exit
> rman target /
(or)
if connecting using remote authentication then mentioned the password whcih been mentioned in
the password file.
>rman target sys/password_mention_in_pa ssword_fil e@oracle
Thanks..
As per the message you got, it seems that your database is not open currently. Inorder to connect to a database remotely the instance has to be started.
First start the instance and then connect to the rman. Also if you'r connecting using Oracle Net then you need to mentioned the password that you have given in your password file.
Try this..
> set oracle_home=C:\oracle\prod
> set oracle_sid=oracle10
> sqlplus / as sysdba
> startup
>exit
> rman target /
(or)
if connecting using remote authentication then mentioned the password whcih been mentioned in
the password file.
>rman target sys/password_mention_in_pa
Thanks..
Check your listener and tnssnames files for proper ip/host info.