Oracle 9i OEM fails using RMAN but RMAN Okay from DOS Prompt
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.