error during ides installation (ecc 6.0): ABAP import phase sapssexc_5

[Former Member]

hi guys,

i m installing ides on windows 2003 sever

ram 4gb

an error comes during installation of ides : abap import phase

from 72 processes 70 processes has finshed without any problem but at the last stage

sapssexc_5 importing is stopped.

can anyone plz solve this issue.

log file

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20141017201214

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Apr  2 2006 23:26:45

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC_5.cmd -dbcodepage 4103 -l SAPSSEXC_5.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20141017201214

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20141017202323

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Apr  2 2006 23:26:45

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC_5.cmd -dbcodepage 4103 -l SAPSSEXC_5.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

D:\usr\sap\PRD\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20141017202323

[former_member182034]

hi raveendra,

check the note for ORA-01034

SAP  Note 491174

what is the status of oracle services mean all services are running or not specially listener service.

If issue still persist then check the alert_sid.txt log for exact issue.

Regards,

[Former Member]

hello abdul ,

thanx for reply.

plz let me know that location of these two directories?

1. /etc/oratab
2. /var/opt/oracle/oratab

and

how to know that how much space sga reqired for allocation.

The SGA requires more space than was allocated for it.

thanx again .

[Former Member]

Hi Raveendra,

The two directories you mentioned will be under "root" file system only. To go in anyone, just do -

" cd /etc/oratab"

" cd /var/opt/oracle/oratab"

SGA is "System global area" . How to check that, you can find the same from below link -

http://help.sap.com/saphelp_erp2005/helpdata/DE/61/99a9409ecd1314e10000000a1550b0/frameset.htm

Hope this helps in resolution of your issue,

Regards,

Ashutosh Shukla

[gururaj_srinivasa]

Hi Raveendra,

Check SAP  Note 491174 - Composite SAP note for ORA-01034,

Also check the below links, the similar problem was resolved

http://scn.sap.com/message/10872588

Hope this will help you.

Guru

[Former Member]

hello guru,

thanx for reply.

A- when i conn sys as sysdba

it is connected in idle instance.

is there any significance of idle here ?

and then when i run startup

databse is started and opened.

B- i have checked lsnrctl - it is running on 1527 port

C- r3trans -d (is ok)

D- i have already changed the sessions and processes with the help of notepad but the issue is not resolved .

when i run the sql ALTER SYSTEM SET sessions = 180 scope spfile;

error comes -

error at line 1:

ORA-32001 : write to SPfile requested but no SPFILE specified at startup.,

plz reply me how to set sessions ?

thanks again.

[gururaj_srinivasa]

Please try this as ‘sysdba’ in SQL Plus:

create spfile from pfile;

shutdown immediate;

startup;

The above commands should create a spfile and use it for starting up an instance.

[Former Member]

thanks guru.

spfile is created

and now i have changed the sessions and processes .

[Former Member]

hello guru,

again i started sapinst.exe

again same error comes.

error shows in sqlnet.log

Fatal NI connect error 12170.

  VERSION INFORMATION:

          TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

          Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production

  Time: 22-OCT-2014 23:27:52

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12535

    TNS-12535: TNS:operation timed out

    ns secondary err code: 12560

    nt main err code: 505

    TNS-00505: Operation timed out

    nt secondary err code: 60

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.21.21)(PORT=1527))

[gururaj_srinivasa]

Try to do tnsping localhost.localdomain.com and see if connection is possible, make sure listener is up and TNS setting is done.

[Former Member]

my host ip is 192.168.21.21 (production.sap.com)

in cmd i have executed - tnsping production.sap.com

tns ping utility.........

copyright...............

used parameter files : d:/oracle///sqlnet.ora

used HOSTNAME adapter to resolve the alias

attempting to connect <<>>

tns-12541 :TNS ; no listner

but again i run lsnrctl and run start

it shows

tns-01106: Listner using listner name Listner has already been started.

now what to do?

[gururaj_srinivasa]

Stop the listener

Stop SAP

Stop DB

Start listener

Start SAP and DB

If required rebooting server would also help

Guru

[Former Member]

i stopped                db , listenr, sap

and then restarted   db , listener

(one thing i want to add when i run tnsping production.sap.com)

attempting to connect

description =connect_data = service_name = production.sap.com

address=protocol=tcp

host=192.168.21.21

but the port here is = 1521 (i think it should be 1527 ? )

and again error comes

tns-12541 : tns : no listener

[gururaj_srinivasa]

It seems like the listener doesn't run or runs but listening on wrong port or host.

Go to the host and locate the listener.ora file, normally located in $ORACLE_HOME/network/admin

Check the file and verify listener port number are the same in your tnsnames.ora.

Guru

[Former Member]

>>  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.21.21)(PORT=1527))

You have to update the listener file with correct port number under \usr\sap\<SID>\SYS\profile\oracle

also check the listener file under oracle home\network\admin

[Former Member]

guru,

same port no are  there in tnsnames.ora & listner.ora

[Former Member]

hello sunil,

i have checked in profile but there is only  2 file

         sqlnet.ora

and   tnsnames.ora

there is no listener file

now what to do?

[gururaj_srinivasa]

Check if entries are maintained in host file.

Guru

[Former Member]

yes guru

already i have added the entry in host file

in windows/system32/driver/etc/host

127.0.0.1             localhost

192.168.21.21     production.sap.com

[Former Member]

please send the listener.ora & tnsnames.ora from \oracle\<SID>\<DB_VER>\NETWORK\ADMIN

the output from tnsping <SID> command.

and the output from listener status command.

[Former Member]

tnsnames.ora

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

<SID>.WORLD =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SID = <SID>)

      (GLOBAL_NAME = <SID>.WORLD)

    )

  )

LISTENER.ORA

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = <SID>)

      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)

    )

  )

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = production.sap.com)(PORT = 1527))

  )

[Former Member]

>>(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)

did you followed the oracle intallation guide or SAP oracle installation guide to install oracle?

You must follow the SAP's installation instruction to install oracle. the listener should look like below:-

LISTENER =

  (ADDRESS_LIST =

        (ADDRESS =

          (PROTOCOL = IPC)

          (KEY = SMS.WORLD)

        )

        (ADDRESS=

          (PROTOCOL = IPC)

          (KEY = <SID>)

        )

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = HOST_NAME)

          (PORT = 1527)

        )

  )

STARTUP_WAIT_TIME_LISTENER = 0

ADR_BASE_LISTENER = E:\oracle\<SID>\saptrace

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = <SID)

      (ORACLE_HOME = E:\oracle\<SID>\11202)

    )

  )

[Former Member]

Is you oracle database is up and running? the 1034 mean oracle database not available.

BTW - This should be under windows forum.

[Former Member]

hello sunil,

thanx for reply.

databse is started but in idle instance

what is idle means here ?

is oracle is available or not?

thanx again.