Failed to open service <OracleDEV102TNSListener>, error 1060

[Former Member]

Dear Consultants,

I have been trying to install ECC6 , Oracle on Windows 2003, and my Hardware is RAM --2 GB

HDD -- 300GB

I am having intel duo core processor and iam using Gigabyte motherboard,Intel chipset.

My Installations stops at Import_Abap phase, following are the logs ,

<b>ERROR 2007-03-10 04:47:46

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

ERROR 2007-03-10 04:47:47

FCO-00011 The step runMigrationMonitor with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR .

INFO 2007-03-10 05:03:18

An error occured and the user decide to stop.\n Current step "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor</b>".

I have set the all the Environment variables , i run r3trans -d and the result is

<b>C:\Documents and Settings\devadm>r3trans -d

This is r3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

unicode enabled version

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

r3trans finished (0012).</b>

-

---

<b>I also run r3trans -x and the result is.

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 21 1.098448

4 ETW000 [dev trc ,00000] Try to connect with default password 142 1.098590

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4 ETW000 22 1.098612

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 23 1.098635

4 ETW000 [dev trc ,00000] 0 UTF8 1 0244CF08 0245243C 02451CC4

4 ETW000 24 1.098659

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=02463484) 14 1.098673

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02451C10,srvhp=02463484)

4 ETW000 19 1.098692

4 ETW000 [dev trc ,00000] Deallocating server context handle 02463484 16 1.098708

4 ETW000 [dev trc ,00000] Allocating server context handle 15 1.098723

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=02451C10,svrhp=02463484)

4 ETW000 29 1.098752

4 ETW000 [dev trc ,00000] Tue Mar 13 04:38:09 2007 1093335 2.192087

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

4 ETW000 19 2.192106

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 19 2.192125

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 431]

4 ETW000 176 2.192301

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]

4 ETW000 19 2.192320

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"</b>

-

---

Event Viewer result is

<b>----

---

Faulting application isqlplussvc.exe, version 1.0.7.0, faulting module msvcrt.dll, version 7.0.3790.0, fault address 0x0003113b.</b>

finally in SAPINST logs i could see

<b>

Starting tnslsnr: please wait...

Failed to open service <OracleDEV102TNSListener>, error 1060.

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

System parameter file is C:\oracle\DEV\102\network\admin\listener.ora

Log messages written to C:\oracle\DEV\102\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\DEV.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\DEVipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV)(PORT=1527)))

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

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

Start Date 10-MAR-2007 01:29:29

Uptime 0 days 0 hr. 0 min. 3 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\oracle\DEV\102\network\admin\listener.ora

Listener Log File C:\oracle\DEV\102\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\DEV.WORLDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\DEVipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV)(PORT=1527)))

Services Summary...

Service "DEV" has 1 instance(s).

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

The command completed successfully</b>

Please suggest for the possible workaround, as you can see i have tried everything.

Regards,

[Former Member]

Dear Umesh,

sorry for responding you late.

In Initsid.ora

shared_pool_size is 241434624

shared_pool_reserved_size is = 24143462

please let me know what are the values i have to add,

Regards,

[Former Member]

Stop the Installtion, stop the db

in initsid.ora update this value

shared_pool_size is 245434624

shared_pool_reserved_size is = 24543462

start the db with this pfile

sqlplus>startup pfile=\oracle\sid\102\database\initsid.ora

regards

Umesh K

[Former Member]

Hi Sammer,

Can you attach the Oracle spfile?

Please check if during the installation the free space in main memory without count the pagefile syze.

I'm not shure, but I think that the requirements to install ECC are greater than 2 GB of RAM.

Please review the system requirements.

Thanks,

Itamar Marioto

[Former Member]

Dear Umesh,

I have triggered the Installation again, still the problem remains unresolved,

PLEASE CONFIRM THAT I AM USING INTEL CORE DUO PROCESSOR , does it have any dependcies or prerequisites.

pasting the last few lines of logs of SAPAPPL1_15, where i got the error in ABAP IMPORT.

DbSl Trace: ORA-4031 occurred when executing SQL statement (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "VDBEPI_EU~0" ON "VDBEPI_EU" ( "MANDT", "BUKRS", "RBELKPFD", "RPOSNR" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 4031)

error message returned by DbSl:

ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","CREATE UNIQUE INDEX "VDBEPI_...","Typecheck","qcsqlpath: qcsAddSqlPath")

(DB) INFO: disconnected from DB

E:\usr\sap\NAJ\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

E:\usr\sap\NAJ\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20070517090126

===================================================

IMPORT_MONITOR.JAVA logs.

Import Monitor jobs: running 2, waiting 35, completed 34, failed 1, total 72.

Loading of 'SAPAPPL1_15' import package: ERROR

Import Monitor jobs: running 1, waiting 35, completed 34, failed 2, total 72.

Loading of 'SAPAPPL2_5' import package: ERROR

Import Monitor jobs: running 0, waiting 35, completed 34, failed 3, total 72.

Import Monitor jobs: running 1, waiting 34, completed 34, failed 3, total 72.

Import Monitor jobs: running 2, waiting 33, completed 34, failed 3, total 72.

Import Monitor jobs: running 3, waiting 32, completed 34, failed 3, total 72.

Loading of 'D021T' import package: OK

Import Monitor jobs: running 2, waiting 32, completed 35, failed 3, total 72.

Import Monitor jobs: running 3, waiting 31, completed 35, failed 3, total 72.

Loading of 'SAPAPPL1_12' import package: OK

Import Monitor jobs: running 2, waiting 31, completed 36, failed 3, total 72.

Import Monitor jobs: running 3, waiting 30, completed 36, failed 3, total 72.

Loading of 'SAPSSEXC_4' import package: OK

Import Monitor jobs: running 2, waiting 30, completed 37, failed 3, total 72.

Import Monitor jobs: running 3, waiting 29, completed 37, failed 3, total 72.

Loading of 'SAPSSEXC_6' import package: OK

Import Monitor jobs: running 2, waiting 29, completed 38, failed 3, total 72.

Regards,

[Former Member]

HI,

the soln is very simple.stop the installtion. logoff and login via sid<adm> user stop the sap,oracle.then goto \oracle\sid\release\database\initsid.ora then add 40Bytes to shared_pool_size and give 10% of shared_pool_size to shared_pool_reserved_size..then start the db,sapmmc logoff and login viz administrator user and resume ur installation

Regards

Umesh K

[Former Member]

I have again uninstall and Reinstalled the Oracle and triggered the sap intallation.

with New SID as <b>NAJ</b>

At Import Abap phase i got the error when i checked the sapinst logs i found that the actual error started while loading SAPPPL. check the logs below.

<i><b>Loading of 'SAPAPPL2_3' import package: ERROR

Import Monitor jobs: running 0, waiting 23, completed 14, failed 1, total 38.

Import Monitor jobs: running 1, waiting 22, completed 14, failed 1, total 38.

Loading of 'SAPAPPL0_2' import package: ERROR</b></i>

LSNRCTL logs

<i><b>LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-MAR-2007 04:39:25

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

System parameter file is C:\oracle\NAJ\102\network\admin\listener.ora

Log messages written to C:\oracle\NAJ\102\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\NAJ.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\NAJipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV)(PORT=1527)))

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

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

Start Date 16-MAR-2007 04:39:27

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File C:\oracle\NAJ\102\network\admin\listener.ora

Listener Log File C:\oracle\NAJ\102\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\NAJ.WORLDipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\NAJipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV)(PORT=1527)))

Services Summary...

Service "NAJ" has 1 instance(s).

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

The command completed successfully</b></i>

Need your inputs

Regards.

[Former Member]

Hi Sameer,

This is not a Listener error.

First, try to rerun the load, and if it fails again, please read the Sap Note 455195. It explains how to solve the loading import packages issue.

Best Regards,

JC Llanes.

[Former Member]

HI

Post SAPAPPL0_2.log

Regards

Umesh K

[Former Member]

Hi,

Here is the listener.ora file.

I AM USING INTEL CORE DUO PROCESSOR, DOES IT HAVE ANY RESITRICTIONS....?

1. listener.ora Network Configuration File: D:\oracle\DON\102\NETWORK\ADMIN\listener.ora

2. Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle\DON\102)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = XECA_MNAJEEB)(PORT = 1521))

)

Regards,

[Former Member]

Hi,

This is NOT the listener.ora your log was pointing to:

Failed to open service <OracleDEV102TNSListener>, error 1060.

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

<b>System parameter file is C:\oracle\DEV\102\network\admin\listener.ora</b>

What's your real SID? DEV? DON?

Regards,

JC Llanes.

[Former Member]

Hi,

It looks you are trying to install two SAP systems on the same server...

After install second system, you are unable to start first system..

is this your problem or different?

Regards

Ben

[Former Member]

Dear Marioto.

Its looks we have some issues with the lsnrctl,

i tried to sart the service but it says it cannot be started on local machine.

i am using oracle 10.2.0.1.0, but i could not find and patch for this, does it require any oracle patch...?

Regards,

[Former Member]

Hi Sameer,

Please, can you attach your C:\oracle\DEV\102\network\admin\listener.ora?

...and your devadm user environment values?

Best Regards,

JC Llanes.

[Former Member]

Sameer,

I suppose that you have some problem to start the Oracle listener.

In the Windows Services, you can find an entry to Oracle Listener named OracleDEV102TNSListener.

Please try to start the service.

If the listener not start, check the listener log in the path : %ORACLE_HOME%\network\admin.

If you cannot determine the root problem, please attach the last lines in this log to this post.

Regards,

Itamar Marioto

[Former Member]

Thanks for your interest.

I have never Changed any ports.

secondly i have tried to tried to check the listener availablitiy by using the command. lsnrctl start, but it has not connected.

Service OracleSIDTNSlistener it not getting started,

i am using oracle 10.2.0.1.0 but i have not installed any patches for oracle.

please suggest.

Regards,

Sameer.

[Former Member]

Hi Sammer,

Please, check if the listener is answering to the connections using the following statement:

tnsping DEV.WORLD

and

tnsping DEV

If it is ok, try to connect to the database using the sqlplus:

sqlplus SAPSR3/SAP@DEV

If the result in any step is fail, check your oracle listener configuration.

I hope that it can help you.

If you need additional suport, let me know.

Regards,

Itamar Marioto

[Former Member]

Did you change the listener name or the listener port number at the time of installation? If you have changed the name of the listener file, then first start the listener with command lsnrctl -start <Listener Name>. Then start the database and then continue the installation. Check you environment variable and also the version of java you use.