on 09-10-2008 10:46 AM
Hello Experts,
I am getting a problem while installing the SOLUTION MANAGER 4.0.
in step 17/45 IMPORT ABAP :
the problem is :
ERROR 2008-04-29 03:10:28.110
CJS-30023 Process call '/usr/sap/SLM/SYS/exe/run/R3load -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.
when i saw R3load.exe.log file it has the following contain :
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/SLM/SYS/exe/run/R3load: START OF LOG: 20080428095833
/usr/sap/SLM/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/SLM/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jul 14 2007 02:19:03
/usr/sap/SLM/SYS/exe/run/R3load -testconnect
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505
DbSl Trace: CONNECT failed with sql error '12505'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505
DbSl Trace: CONNECT failed with sql error '12505'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505
DbSl Trace: CONNECT failed with sql error '12505'
DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505
DbSl Trace: CONNECT failed with sql error '12505'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/SLM/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/SLM/SYS/exe/run/R3load: END OF LOG: 20080428095834
Please can any body help me to solve this problem.
waiting for fast response, as my installtion is pending due to this problem.
have a nice day.
Regards,
Shivendra.
I know the question has been asked 2 years ago.
But, I'm going to answer for the ones who will need an issue, and will look for a solution.
If you use the wrong port, you have to change 3 files and no only 2 :
oracle/SID/102_64/network/admin/listener.ora
/oracle/SID/102_64/network/admin/tnsnames.ora
/sapmnt/SID/profile/oracle/tnsnames.ora
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you install the database when it's been requested by sapinst or before the installation? If you did install Oracle before then your configuration is incomplete.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.
Check the parameters for connect to the database.
The correct SID and port you can find in:
Under OS user oraSAPSID execute the command - lsnrctl status
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alexey!
Thanks for your valuable Answer, but still i am getting the same problem.
I think that my Listener is started but it is lont listening.
it is refusing connection from SAP to Database.
Please let me know if you have any ans.
in this server i already had one oracle server so i changed the name of LISTENER to LISTENER_SLM in listener.ora and also changed the port no 1527 to 1528.
and changed the same port no in tnsname.ora.
please help me out if you have any idea.
waiting for your response.
Hi,
The following should be verified:
(1) check what DB instances the listener currently is aware of. This can be done with the command 'lsnrctl services'.
(in case you listener does not have the default name LISTENER, then use 'lsnrctl services <listener name>' )
(2) Perhaps there is an issue with the dynamic instance registration, even though the error code is different, you should nevertheless check the points from note #563574.
(3) Verfiy the value of the parameter local_listener (see mentioned note). Since you have changed the listener, the parameter might still be wrong.
In case local_listener is correcly set you should give the command
ALTER SYSTEM REGISTER;
a try.
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.