cancel
Showing results for 
Search instead for 
Did you mean: 

R3load test connect error during system copy

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

yes rudi, I have restarted it.

Former Member
0 Kudos

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?

Former Member
0 Kudos

Have you restart your listener bro??

lsnrctl start

.Rudi.

Former Member
0 Kudos
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

check default profile and environment variable for SAPSYSTEMNAME

Former Member
0 Kudos

I have already entered env variable dbs_ora_tnsname=SID and entered dbs/ora/tnsname = SID in default as well as in instance profile.

Also SAPSYSTEMNAME= SID is there in both profiles. Any other suggestions?

Former Member
0 Kudos

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

Former Member
0 Kudos

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"/>.&lt;br&gt;

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

  1. tnsnames.ora Network Configuration File: /oracle/SID/102_64/network/admin/tnsnames.ora

  2. Generated by Oracle configuration tools.

LISTENER_SID.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = server)(PORT = 1527))

################

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $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)

)

)

Former Member
0 Kudos

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

Former Member
0 Kudos

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