SAP installation failed on step Database instance Installation

[Former Member]

Hello All,

This is the first time that I have to install SAP Netweaver 04 ( on Windows 2003 with Oracle 10.2 ) and my installation failed

on the step Central database installation. At first I have a problem with my listener,

it still in unknown status. Please find here my tnsnames.ora, my listener.ora and my sqlnet.ora files

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

LISTENER.ORA

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

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = G.\oracle\ESP\102)

(PROGRAM = extproc)

)

(SID_DESC =

(SID_NAME = ESP)

(ORACLE_HOME = G.\oracle\ESP\102)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.103)(PORT = 1527))

)

)

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

SQLNET.ORA

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

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

1. Filename......: sqlnet.ora

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

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

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

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = ON

SQLNET.EXPIRE_TIME = 0

#SQLNET.AUTHENTICATION_SERVICES = (NTS)

TCP.NODELAY=YES

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

TNSNAMES.ORA

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

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

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

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

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

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

5. @(#) $Id: //bc/640-2/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

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

ESP =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.103)(PORT = 1527))

(CONNECT_DATA =

(SERVICE_NAME = ESP)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

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

Please .. help ..

[Former Member]

After many Re-Installation, The install is success, I´ve install SAPGUI and I´m able to connect on my SAP instance, however I still have problem , I use the user SAP* and it seems that the user is restricted so I´m not able to create any user ( the same with DDIC ). I´m not able to install J2EE engine administrator as well. How can I administrate users, etc ...

Thanks in advance

[Former Member]

hi everyone,

do you know how to apply the patchset 10.2.0.2 to base version 10.2.0.1? Is the patchset not required if base version is 10.2.0.1 before proceeding with the installation of the Netweaver DVD? I don't see a patch for 10.2.0.1 on service marketplace.

thanks in advance

jb

[Former Member]

Hello,

You can download the patch Oracle 10.2.0.2 from marketplace. pl refer https://websmp206.sap-ag.de/instguides --> Other Documentation --> database upgrade --> oracle --> and select the appropriate document. Also refer Note 871735.

you can refer service.sap.com/pam for SAP matrix.

Cheers,

-Sunil

[Former Member]

Try to change the listener service to automatic start and resume the installation again.

For the Oracle 10 set the listener service to manual start by default.

[Former Member]

Hello,

Nice try but without success ... sorry ... The download of Oracle 9 is in progress

Thanks Again

Regards

[former_member194737]

Hi David,

As of my knowledge, NW2004-SAPINST is supported only with Oracle 9i, So you have to complete the installation with oracle 9i.

If you want to use 10G, Check the DB Upgrade Guide and proceed with it.

http://service.sap.com/~form/sapnet?_SHORTKEY=00200797470000065880&_SCENARIO=01100035870000000202&;

Good Luck.

[Former Member]

make sure, you started all the SAP and oracle services and no service is in error.

Also, try to restart your system and try again.

Always use SAP resommended userid for installation.

[Former Member]

Hello,

Thanks for your answers, so now a question, should it solve my problem, if I download the packages for Oracle 9 ? As my Installation failed with error on the log "Cannot connect to database, TNS:Protocole Adpater Error" the variables are set, I haven´t got other database, so I'm pretty sure this is related to the listener configuration. I will download the packages tonigh and try to install SAP tomorrow. I'll let you know what will happen ...

Thanks again

[Former Member]

Hi David,

In oracle10.2 we need to configure listner explicitly it is not configured automatically as in the case of oracle9

regards

D.Samrat

[Former Member]

and here is the status :

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

-

---

Alias LISTENER

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

ction

Start Date 08-DEC-2006 17:25:24

Uptime 0 days 0 hr. 3 min. 15 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File G:\oracle\ESP\102\network\admin\listener.ora

Listener Log File G:\oracle\ESP\102\network\log\listener.log

Listening Endpoints Summary...

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

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

Services Summary...

Service "ESP" has 1 instance(s).

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

Service "PLSExtProc" has 1 instance(s).

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

The command completed successfully

LSNRCTL> stop

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

And the log :

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-DEC-2006 17:25:21

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

System parameter file is G:\oracle\ESP\102\network\admin\listener.ora

Log messages written to G:\oracle\ESP\102\network\log\listener.log

Trace information written to G:\oracle\ESP\102\network\trace\listener.trc

Trace level is currently 0

Started with pid=2156

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

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

Listener completed notification to CRS on start

[former_member194737]

Hi,

Status unknown is not a problem,

Even i get the same message from my DB, send me the error or problem you have.

I think your Listener is fine. go ahead and do the next steps.

Thanks