Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 9i OEM fails using RMAN but RMAN Okay from DOS Prompt

187384Jun 24 2002
I am using Oracle 9i Enterprise on Windows NT 4 with dual 400 MHZ Pentiums with 1GB of ram. I am able to run RMAN from the DOS prompt and the backup file is created fine. When I run either by a job or by using the Backup wizard from the OEM, the job fails with a TNS:protocol adapter error from the target database.

Error Message that I get is as follow:
Recovery Manager: Release 9.0.1.1.1 - Production

(c) Copyright 2001 Oracle Corporation. All rights reserved.

RMAN> connect target jungle/gonzo@(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEDEV)
(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
2> connect catalog RMAN/rman@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=testhost.crane.navy.mil)(PORT=1521)))(CONNECT_DATA=(SID=TestOEM)(SERVER=DEDICATED)))
3> @E:/oracle/ora90/work/706143955.21
4> run{allocate channel c1 type disk;
5> backup database format 'F:\OracleDumps\%u';
6> release channel c1;
7> }
8> **end-of-file**
9>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 06/21/2002 14:39:57
RMAN-04005: error from target database: ORA-12560: TNS:protocol adapter error

Recovery Manager complete.
child process exited abnormally
nms-915: The Job failed, error code=

My TNSnames.ora contents are as follows:
# TNSNAMES.ORA Network Configuration File: c:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

Test.CRANE.NAVY.MIL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = testhost.crane.navy.mil)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Test)
)
)

TESTOEM.CRANE.NAVY.MIL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Testhost.crane.navy.mil)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TESTOEM)
)
)

My Listener.ora file is as follows:
# LISTENER.ORA Network Configuration File: c:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 164.227.54.52)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Test)
(ORACLE_HOME = E:\oracle\ora90)
(SID_NAME = Dev)
)
(SID_DESC =
(GLOBAL_DBNAME = TestOEM)
(ORACLE_HOME = E:\oracle\ora90)
(SID_NAME = DEVOEM)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora90)
)
(SID_DESC =
(GLOBAL_DBNAME = SQLSRV_testhost.crane.navy.mil)
(PROGRAM = tg4msql)
(SID_NAME = test1)
(ORACLE_HOME = E:\oracle\ora90)
)
)

I believe the problem is with the TNSNames file not having BEQ set up in it. I tried to set up using the Oracle Net Manager and could not find BEQ as an available protocol. Anyone know where to direct me to look in the documentation or can give me some help.
I am a newbie on the Oracle DBA scene and any help would be appreciated. Just been trying to do this since January.



Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2002
Added on Jun 24 2002
5 comments
507 views