on 05-07-2009 3:03 PM
Hi,
I'm facing this error during export of system copy. I have checked the parameter dbs/ora/tnsname, it exists in default profile. Also R3trans -d and R3load -testconnect works as sidadm.
Any help will be useful.
R3load.exe.log
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20090506161359
/usr/sap/<SID>_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP
/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4
Compiled Aug 24 2008 21:33:18
/usr/sap/<SID>/SYS/exe/run/R3load -testconnect
DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
(DB) ERROR: db_connect rc = 256
DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
(DB) ERROR: DbSlErrorMsg rc = 29
/usr/sap/<SID>/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/<SID>/SYS/exe/run/R3load: END OF LOG: 20090506161359
Check tnsnames.ora file and listener.ora
see below commnad for database connection
tnsping <SID> if it is not pinging check environment variable,UserID which ur using,
permissions
Surendra Jain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just in case anyone finds this and has the
R3load or R3trans
no connect possible
due to "dbs/ora/tnsname is not in profile" error
I found after many hours trying to track this down that this can mean:
"your environment variables are wrong"
On windows after much scratching around I found that I had set the variables like:
set dbs_ora_tnsname = ABC
I should have done:
set dbs_ora_tnsname=ABC
(no spaces)
After switching all my environment variables to have no spaces around the = sign, it all of a sudden worked.
Sigh... I hope I save someone this pain.
Andy.
yes rudi, I have restarted it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have corrected the tnsnames.ora. restarted the system, reinitaized the sapinst, still getting the same error.
Also messages.xml file does not mean anything as it contains common error messages that may come during sapinst procedure. Any other suggestion?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
check default profile and environment variable for SAPSYSTEMNAME
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hmm, strange, looks like i didn't read your first post very carefully, sorry. I assume you are doing the export with sapinst as user root. Can you please verify under /tm/sapinst_instdir/...
... if the keydb.xml contains these lines:
keydb.xml: <strval><![CDATA[/oracle/SID/102_64/network/admin/tnsnames.ora
keydb.xml: /usr/sap/SID/SYS/profile/oracle/tnsnames.ora]]>
... grep the sapinst_dev.log for tnsnames, and check for something suspicious. You should see several lines like this:
sapinst_dev.log:Environment variable dbs_ora_tnsname set to value 'SID'.
Please do also verify the file permissions on the tnsnames.ora AND the directories, try if you can access them as root as well.
You can try to temporarily set dbs_ora_tnsname for root and restart sapinst, but this will not fix the root cause of your problem.
Best regards, Michael
yes I'm doing export with sapinst. In default/instance profile parameter is set as dbs/ora/tnsname = SID
env parameter is set as dbs_ora_tnsname = SID
I have tried sapinst to run with this parameter.
Permission in the network/admin directory is 755 tnsnames.ora as well as listener.ora. Also startsap stopsap don't have any problem. I have also checked OPS$SIDADM user permission/passwd for R3trans/R3load. I have tried two different SAP DVDs, NW04s SR2 and NW04s SR3.
These are the finding from the grep.
root@server:/instSID>cat | grep tnsname sapinst_dev.log
dbs/ora/tnsname = SID
dbs/ora/tnsname = SID
DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
root@server:/instSID>cat | grep tnsname keydb.xml
dbs/ora/tnsname = SID
dbs/ora/tnsname = SID
Here is all tnsname grep in the directory other than control.xml.
root@server:/instSID>cat | grep tnsname *
keydb.xml:dbs/ora/tnsname = SID
keydb.xml:dbs/ora/tnsname = SID
messages.xml: <message name="tnsnamesOraFormatNotSupported" errno="CJS-00090">
messages.xml: Wrong format of the tnsnames.ora file <p nr=0"/>.<br>
R3load.exe.log:DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
R3load.exe.log:DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
sapinst.log:DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
sapinst.log:DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
sapinst_dev.log:dbs/ora/tnsname = SID
sapinst_dev.log:dbs/ora/tnsname = SID
sapinst_dev.log:DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
sapinst_dev.log:DbSl Trace: Cannot connect: dbs/ora/tnsname in profile missing
tnsnames.ora
tnsnames.ora Network Configuration File: /oracle/SID/102_64/network/admin/tnsnames.ora
Generated by Oracle configuration tools.
LISTENER_SID.WORLD =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = server)(PORT = 1527))
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
SID.WORLD =
(DESCRIPTION =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = server)(PORT = 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID.WORLD)
)
)
Ok, your tnsnames.ora seems to be messed up, probably by Generated by Oracle configuration tools
Here is how my tnsnames.ora look like:
orasid> more tnsnames.ora
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
SID.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = host1)
(PORT = 1526)
)
)
(CONNECT_DATA =
(SID = SID)
(GLOBAL_NAME = SID.WORLD)
)
)
Please remember to check the tnsnames.ora in /oracle/SID/102_64/network/admin AND /sapmnt/SID/profile/oracle. If you have both files, it might be a good idea to compare them. I suspect only the one in ORACLE_HOME is messy.
Best regards, Michael
Try setting the environnement variable dbs_ora_tnsname=SID and restart, where SID is your database SID.
Otherwise try to set dbs/ora/tnsname = SID in your instance profile.
Best regards, Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.