Reply from bharatram on May 27 at 2:28 AM Hi Syedali,
ORA-12154: TNS:could not resolve the connect identifier specified
Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached
You have set a connection identifier, that could not be resolved through tnsnames.ora file.
This can have two different reasons:
1) No or wrong entry in tnsnames.ora of environment variable TNS_ADMIN or default location ORACLE_HOME/network/admin
2) Wrong connect identifier is specified in environment or SAP profile , the identifier is written to the file R3ldctlExport.log, where you can crosscheck
3)Note 324714 - DB connect error in TMS after Oracle upgrade/change
4)Note 556232 - Environment settings for R/3/Oracle on Windows
5)provide me R3trans.log details for further details
regards
Ram
| | | ---------------Original Message---------------
From: syedali
Sent: Saturday, May 26, 2012 9:52 PM
Subject: Export Database for a Distributed System
Hi Experts
The distributed system is (CI and Central Services on Windows 2003) and database( oracle 10.2 on Red Hat Ent. LINUX. This is a uni-code system.
During the database export on linux (ie: start of Export ABAP Phase) I receive the following error:
Database Instance Export( Last error reported by the step: Process call '/usr/sap/RT6/SYS/exe/run/R3load -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.
R3Load.exe.log is given below:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/RT6/SYS/exe/run/R3load: START OF LOG: 20120526172527
/usr/sap/RT6/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/RT6/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Mar 21 2012 09:11:36
/usr/sap/RT6/SYS/exe/run/R3load -testconnect
DbSl Trace: CONNECT failed with sql error '12154'
(DB) ERROR: db_connect rc = 256
DbSl Trace: CONNECT failed with sql error '12154'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/RT6/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/RT6/SYS/exe/run/R3load: END OF LOG: 20120526172527
The env variables which I have set are PATH, SAPINST_JRE_HOME, JAVA_HOME and initiated the sapinst for the export of the database on linux.
Please guide me through on what else I am missing or what needs to be done before i initiate the sapinst(working shell used is cshell).
The linux server is a physical server( not a virtual host) with multiple oracle databases installed. The respective database and listener service is up and running fine, R3tans is ok.
SAP Notes checked 443867 .
Thanks
syed |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment