Solution manager Installation Error

[former_member432715]

Hi Support,

I am installing Solution Manager 7.0 on RHEL 5.0 plateform and database is Oracle 10G. I am getting stuck at "Import ABAP Phase". The error log is given below:

R3load.exe.log

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

DbSl Trace: CONNECT failed with sql error '12505'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/SLO/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/SLO/SYS/exe/run/R3load: END OF LOG: 20090114111511

[root@isrxi AS]# tailf 100 R3load.exe.log

Usage: tailf logfile

[root@isrxi AS]# tail 100 R3load.exe.log

tail: cannot open `100' for reading: No such file or directory

==> R3load.exe.log <==

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12505

DbSl Trace: CONNECT failed with sql error '12505'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/SLO/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/SLO/SYS/exe/run/R3load: END OF LOG: 20090114111511

Kindly suggest us for same.

Regards,

Shobhit Kumar

[JPReyes]

DbSl Trace: CONNECT failed with sql error '12505'

Check that the Oracle listener is started and the configiration of LISTENER.ORA is correct.

regards

Juan

[Former Member]

HI Juan,

this is my lsnrctl status ;

lsnrctl status

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 14-JAN-2009 14:46:19

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SLO.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SLO))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=isrxi)(PORT=1527))

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.2.0 - Production

Start Date 13-JAN-2009 11:15:33

Uptime 1 days 3 hr. 30 min. 46 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/RTD/102_64/network/admin/listener.ora

Listener Log File /oracle/RTD/102_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=RTD.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=RTD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=isrxi.indiabulls.com)(PORT=1527)))

Services Summary...

Service "RTD" has 1 instance(s).

Instance "RTD", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

lsitner.ora file contains :

-rwxrwxr-x 1 oraslo dba 811 Jan 14 10:46 listener.ora

drwxr-x--- 2 oraslo dba 4096 Jan 14 10:32 samples

-rw-r----- 1 oraslo dba 172 Dec 26 2003 shrept.lst

-rw-rr 1 oraslo dba 518 Jan 14 10:46 sqlnet.ora

-rw-rr 1 oraslo dba 510 Jan 14 10:46 tnsnames.ora

isrxi:oraslo 5> cat listener.ora

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

1. Filename......: listener.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/LISTENER.ORA#4 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = SLO.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = SLO)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = isrxi)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = SLO)

(ORACLE_HOME = /oracle/SLO/102_64)

)

)

Kindly suggest for the same..

Thanx,

amit

[JPReyes]

Read,

SAP Note 609332 - Composite note: ORA-12541/ORA-12224

Regards

Juan

[former_member432715]

Hi Support,

When i am start listener it shows a message that listener is already started but when i stop this it shows an error please find the logs

lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 14-JAN-2009 15:58:54

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SLO.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SLO))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=isrxi)(PORT=1527))

TNS-01190: The user is not authorized to execute the requested listener command

kindly give me a solution for this issue.

Regards,

Shobhit

[JPReyes]

TNS-01190: The user is not authorized to execute the requested listener command

You need to start/stop the listener using ora<sid> user

Regards

Juan

[former_member432715]

hi juan,

the problem has been resolved.

actually some tns processes were running by another user so i just kill all the processes and start listener.

thanks for your valuable support.............

regards,

shobhit