work processes die after startup due to ORA-12154 error

[Former Member]

Greetings all,

I have an annoying issue with my newly installed ECC6.0 system. This system is installed on RedHat with kernel 2.6.18-194.32.1.e15 and Oracle 11. When I try to start it everything looks fine from the startup logs (no errors) but as soon as it has started all the workprocesses die and finally the dispatcher shuts down.

In the dev_w0 log I found the error:

C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:

C ORA-12154: TNS:could not resolve the connect identifier specified

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 14350]

C SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12154.

B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh 1241]

B ***LOG BY2=> sql error 12154 performing CON [dblink 540]

B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dblink 540]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1461]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11087]

which would indicate an issue with the tnsnames.ora or sqlnet.ora. However, both of these seem fine since when I do a tnsping I get the following result:

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 05-JUL-2011 16:16:41

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

/usr/sap/DEV/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = r3dev) (PORT = 1527))) (CONNECT_DATA = (SID = DEV) (GLOBAL_NAME = DEV.WORLD)))

OK (0 msec)

and when I perform an R3trans -x:

This is R3trans version 6.19 (release 720 - 06.04.10 - 16:31:00 with UA1430.1 / prepared for CSN 1287305).

unicode enabled version

R3trans finished (0000).

So from these tests all look fine.

The SAPUSER table looks good too in regards to owner:

SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER

-

---

OPS$DEVADM

I have run the appropriate scripts in order to create the OPS$ users with the correct auhtorizations (both oradev and devadm can log on to Oracle as sysdba) and I have even tried resetting the password for user sapdev in Oracle.

This essentially leave me with the user itself, possible errors in the environment settings:

DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

HOSTNAME=r3dev

dbs_ora_tnsname=DEV

dbms_type=ORA

SHELL=/bin/bash

TERM=vt100

HISTSIZE=1000

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPEXE=/usr/sap/DEV/SYS/exe/run

THREAD=NOPS

USER=devadm

LD_LIBRARY_PATH=/oracle/client/10x_64/instantclient:/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64

ORACLE_SID=DEV

ORACLE_BASE=/oracle

dbs_ora_schema=SAPDEV

TNS_ADMIN=/usr/sap/DEV/SYS/profile/oracle

MAIL=/var/spool/mail/bldadm

PATH=/oracle/DEV/112_64/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/devadm/bin:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/usr/sap/DEV/SYS/exe/run:/home/devadm:.

INPUTRC=/etc/inputrc

PWD=/usr/sap/DEV/SYS/profile

SAPDATA_HOME=/oracle/DEV

DB_SID=DEV

LANG=en_US.UTF-8

SAPSYSTEMNAME=DEV

PS1=r3dev:devadm>

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SHLVL=1

HOME=/home/devadm

LOGNAME=devadm

CVS_RSH=ssh

LESSOPEN=|/usr/bin/lesspipe.sh %s

DISPLAY=localhost:10.0

ORACLE_HOME=/oracle/DEV/112_64

G_BROKEN_FILENAMES=1

_=/bin/env

What is it I have overlooked that is causing this rather frustrating problem?

If anyone here knows please let me know.

Edited by: Niclas Isgren on Jul 6, 2011 8:30 AM --- Some minor typoes

[Former Member · Accepted solution]

Hi,

1. Please check IP & host name properly mentioned in host file or not.

2. Also check any error in oracle alert_<sid>.log file

[Former Member · Accepted solution]

Hi,

I can find no posts in the alert log that corresponds to the times that I have tried to start this system. I guess this means that the processes are not terminated by the database as such.

As for the host file there is a position with the full hostname as well as the IP, so it looks ok as far as I can tell.

One issue we do have is that whenever I make a su - devadm or oradev I need to load the environments manually through the source command (source .dbenv_r3bld.sh and .sapenv_r3dev.sh).

This is something I hava asked out OS-guys look into.

[Former Member · Accepted solution]

One issue we do have is that whenever I make a su - devadm or oradev I need to load the environments manually through the source command (source .dbenv_r3bld.sh and .sapenv_r3dev.sh).
This is something I hava asked out OS-guys look into.

I think that's the way to go.

Make sure that the environment will be loaded during login, and it will also be loaded during startsap.

regards

[Former Member · Accepted solution]

Thank you all for all the helpful advice, unfortunately the answer still eludes me and my situation is unchanged. The UNIX team have adjusted the users login-profiles so the environment is loaded automatically as of now. I tried doing a new restart but the issue remains the same.

Below is the full log from dev_w0:

-

---

trc file: "dev_w0", trc level: 1, release: "720"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 20

M sid DEV

M systemid 390 (AMD/Intel x86_64 with Linux)

M relno 7200

M patchlevel 0

M patchno 46

M intno 20020600

M make single threaded, Unicode, 64 bit, optimized

M profile /usr/sap/DEV/SYS/profile/DEV_DVEBMGS20_r3dev

M pid 12182

M

M

M Wed Jul 6 13:06:53 2011

M kernel runs with dp version 125000(ext=118000) (@(#) DPLIB-INT-VERSION-125000-UC)

M length of sys_adm_ext is 588 bytes

M ThStart: taskhandler started

M ThInit: initializing DIA work process W0

M ***LOG Q01=> ThInit, WPStart (Workp. 0 1 12182) [thxxhead.c 1292]

M

M Wed Jul 6 13:06:54 2011

M ThInit: running on host r3dev

M calling db_connect ...

B create_con (con_name=R/3)

B Loading DB library '/usr/sap/DEV/DVEBMGS20/exe/dboraslib.so' ...

B Library '/usr/sap/DEV/DVEBMGS20/exe/dboraslib.so' loaded

B Version of '/usr/sap/DEV/DVEBMGS20/exe/dboraslib.so' is "720.00", patchlevel (0.34)

B New connection 0 created

C Oracle Client Version: 10.2.0.4.0, V5

C Installed Oracle patches:

C # Unique Patch ID: 12114073Created on 15 Jan 2010, 09:30:31 hrs PST8PDT

C # Patch 8732366 : Created on 27 Jul 2009, 15:49:18 hrs CEST

C # Patch 6944036 : Created on 3 Jun 2008, 23:35:37 hrs PST8PDT

C # Patch 6826661 : Created on 20 May 2008, 00:23:58 hrs PST8PDT

C # Patch 6775231 : Created on 2 Dec 2008, 21:45:40 hrs PST8PDT

C # Unique Patch ID: 12924916Created on 13 Sep 2010, 23:47:52 hrs PST8PDT

C application info callback registered

C Client NLS setting (OCINlsGetInfo): connection handle 0, 'AMERICAN_AMERICA.UTF8'

C Logon as OPS$-user to get SAPR3's password

C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 720 280110)

C Nls CharacterSet NationalCharSet Env Err ErrBt

C 0 UTF8 1b7b5020 1b7bcb20 1b7cedc8

C Attaching to database server DEV (con=0, svchp=1b7cecf8, srvhp=1b7d0118)

C

C Wed Jul 6 13:07:08 2011

C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:

C ORA-12154: TNS:could not resolve the connect identifier specified

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 14350]

C SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12154.

B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh 1241]

B ***LOG BY2=> sql error 12154 performing CON [dblink 540]

B ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified [dblink 540]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1461]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 11087]

M

M Info for wp 0

M

M pid = 12182

M severity = 0

M status = 0

M stat = WP_NEW

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M req.req_info =

M req.tid = -1

M req.uid = 4294967295

M req.mode = 255

M req.len = -1

M req.rq_id = 65535

M req.rq_source =

M req.vm = no VM

M last_tid = 0

M last_uid = 0

M last_mode = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M ThIErrHandle: current request:

M

M -IN-- sender_id ? tid -1 wp_ca_blk -1 wp_id -1

M -IN-- action - uid -1 appc_ca_blk -1 type -

M -IN-- new_stat NO_CHANGE mode 255 len -1 rq_id -1

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 779]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 303]

M ThCallHooks: hook >ThrSaveSPAFields< o.k.

M ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M ThIErrHandle: entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workp. 0 12182) [dpuxtool.c 327]

Hopfully this will shed some light on the situation.

Thanks in advance for any help with this.

[Former Member · Accepted solution]

As oradev and devadm, are you able to connect with this:

sqlplus /@DEV

[Former Member · Accepted solution]

Yes, I have no problem connecting with "sqlplus /@DEV" with either of the users.

[Former Member · Accepted solution]

I had a look at your dev_w0 file, and what's strange:

You have kernel release 7.20, and you wrote you have ECC6.0.

As far as I know, for ECC 6.0 you will need kernel release 7.00 or 7.01, depending on enhancement packages.

I may be wrong though.

Could you please double check your releases and their compatibility?

[Former Member · Accepted solution]

The installation master CD used was 51040135_8 which included the the EHP5 for ECC6. The kernel required by sapinst during the setup was the 7.20 kernel so i never actually stopped to check that, since it refused any other options. I will double check this but it seem strange to me that I would be required to use an unsupported kernel.

I will post an update in this thread once I have this verified.

[Former Member · Accepted solution]

You are right;

so far I didn't work with EHP 5;

I just looked at the PAM, and kernel 7.20 is correct.

My you learn something new every day for today.

But about your problem:

I'm running out of ideas.

sorry

[Former Member · Accepted solution]

I know exactly how you feel... this issue has stumped me too.

Thanks for all the help though. If I find the answer I will be sure to share it with you all.

[sunny_pahuja2 · Accepted solution]

Hi,

Could you please let me know how many number of processes and sessions you have set on database ?

Thanks

Sunny

[Former Member · Accepted solution]

Hello Niclas

This is related to wrong TNS entries.

Make sure that your listener is listening for the same service name that you are using. Check if you have same db_name and db_domain name in init.ora and in global_name table.

If not you can change the global_name by alter database command.

Also do check the $ORACLE_HOME/network/admin/tnsnames.ora file too for proper SID entries.

Regards

Vivek;

[Former Member · Accepted solution]

Hello Sunny,

I have 168 sessions and 80 processes set in the DB. These are default settings since the DB installation.

/Niclas

[Former Member · Accepted solution]

Hello Vivekwali,

I get the following result:

SQL> select * from global_name;

GLOBAL_NAME

-

---

DEV.WORLD

Which is the same as in tnsnames.ora as well as listener.ora.

SQL> show parameter db_name

NAME TYPE VALUE

-

---

-

---

-

---

db_name string DEV

SQL> show parameter db_domain

NAME TYPE VALUE

-

---

-

---

-

---

db_domain string

so db_name looks correct to me, but db_domain is empty. According to what i could read on Oracles site this is normal.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams046.htm

Should this be set to DEV.WORLD?

[Former Member · Accepted solution]

Hi,

1. Can you please check OS user <sid>adm & ora<sid> are the member of which groups

2. Upgrade the kernel along with DB runtime library kernel & check if it will help.

3. Please paste the output of command "lsnrctl show" & "lsnrctl status"

4. Also paste the env output of users <sid>adm & ora<sid>

Edited by: Mrinal Das on Jul 7, 2011 12:27 PM

[Former Member · Accepted solution]

Hello Mrinal,

I will split up my answer since the formatting on these forums are not the best...

1. oradev and devadm are both members of dba, oper and sapinst groups. devadm is member of sapsys.

2. I have upadted the kernel to the latest available on SAP service place, as well as applied the latest patches for oracle (thanks for this suggestion). It did however not change the situation.

3 and 4 follow in separate posts.

Edited by: Niclas Isgren on Jul 7, 2011 11:18 AM

[Former Member · Accepted solution]

3.

lsnrctl show:

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-JUL-2011 10:50:55

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

The following operations are available after show

An asterisk (*) denotes a modifier or extended command:

rawmode displaymode

rules trc_file

trc_directory trc_level

log_file log_directory

log_status current_listener

inbound_connect_timeout startup_waittime

snmp_visible save_config_on_stop

dynamic_registration enable_global_dynamic_endpoint

oracle_home pid

connection_rate_limit

lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-JUL-2011 10:51:10

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

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

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production

Start Date 07-JUL-2011 10:19:56

Uptime 0 days 0 hr. 31 min. 13 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/DEV/112_64/network/admin/listener.ora

Listener Log File /oracle/diag/tnslsnr/segotl0234/listener/alert/log.xml

Listening Endpoints Summary...

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

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=131.97.103.28)(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

[Former Member · Accepted solution]

The env for oradev:

DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

HOSTNAME=r3dev

dbs_ora_tnsname=DEV

dbms_type=ORA

SHELL=/bin/bash

TERM=vt100

HISTSIZE=1000

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPEXE=/usr/sap/DEV/SYS/exe/run

THREAD=NOPS

USER=oradev

LD_LIBRARY_PATH=/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/oracle/DEV/112_64/lib

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

ORACLE_SID=DEV

ORACLE_BASE=/oracle

dbs_ora_schema=SAPSR3

MAIL=/var/spool/mail/oradev

PATH=/oracle/DEV/112_64/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oradev/bin:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/usr/sap/DEV/SYS/exe/run:/home/oradev:.

INPUTRC=/etc/inputrc

PWD=/home/oradev

SAPDATA_HOME=/oracle/DEV

DB_SID=DEV

LANG=en_US.UTF-8

SAPSYSTEMNAME=DEV

PS1=segotl0234:oradev>

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SHLVL=1

HOME=/home/oradev

LOGNAME=oradev

CVS_RSH=ssh

LESSOPEN=|/usr/bin/lesspipe.sh %s

ORACLE_HOME=/oracle/DEV/112_64

G_BROKEN_FILENAMES=1

_=/bin/env

OLDPWD=/oracle/DEV/112_64

env for user devadm:

DIR_LIBRARY=/usr/sap/DEV/SYS/exe/run

HOSTNAME=r3dev

dbs_ora_tnsname=DEV

dbms_type=ORA

SHELL=/bin/bash

TERM=vt100

HISTSIZE=1000

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPEXE=/usr/sap/DEV/SYS/exe/run

OLDPWD=/usr/sap/DEV/SYS/profile

THREAD=NOPS

USER=devadm

LD_LIBRARY_PATH=/oracle/client/10x_64/instantclient:/usr/sap/DEV/SYS/exe/run:/usr/sap/DEV/SYS/exe/uc/linuxx86_64

LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:

ORACLE_SID=DEV

ORACLE_BASE=/oracle

dbs_ora_schema=SAPSR3

TNS_ADMIN=/usr/sap/DEV/SYS/profile/oracle

MAIL=/var/spool/mail/devadm

PATH=/oracle/DEV/112_64/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/devadm/bin:/usr/sap/DEV/SYS/exe/uc/linuxx86_64:/usr/sap/DEV/SYS/exe/run:/home/devadm:.

INPUTRC=/etc/inputrc

PWD=/home/devadm

SAPDATA_HOME=/oracle/DEV

DB_SID=DEV

LANG=en_US.UTF-8

SAPSYSTEMNAME=DEV

PS1=segotl0234:devadm>

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SHLVL=1

HOME=/home/devadm

LOGNAME=devadm

CVS_RSH=ssh

LESSOPEN=|/usr/bin/lesspipe.sh %s

DISPLAY=localhost:10.0

ORACLE_HOME=/oracle/DEV/11202

G_BROKEN_FILENAMES=1

_=/bin/env

[Former Member · Accepted solution]

Hi Niclas,

Sorry I am out of ideas. Only one thing i want to ask are you using special character "@" in the password of SAPSR3 user if yes please change the password with brtools without "@" character & check.

This might not be the reason, just doing trial & error ......

[Former Member · Accepted solution]

Hi Mrinal,

No, I didn't use any special characters in the password simply because they have on occasion caused problems, so there are only alphanumerical characters used. I have however recreated the OPS$DEVADM user as well as the SAPUSER table, simply to be sure they were not corrupted. Still no luck though.

Thanks for all the help and time, I have posted a message to SAP about this too so once I have an answer I will let you all know.

/Niclas

Edited by: Niclas Isgren on Jul 8, 2011 8:04 AM -

---

typo

[Former Member · Accepted solution]

Hi Niclas,

Can you please also check dev_disp, dev_ms & dev_enq log, is there any error hints

[Former Member · Accepted solution]

Hi,

One question might be redundant is value obtained from select * from global_name; and db_name in your spfile same?

If not please change : alter database rename global_name to "***";

[former_member197668 · Accepted solution]

Hi,

This is issue belong to environment variable set incorrectly,

1 .for example ORACLE_HOME?

2. try to give FQDN host name in tnsora/sqlnet.ora before that try to ping that host at os level what is the result you getting using nslookup. or ip address

3. reboot the server and check all env variables has been set properly.

Regards.,

Susin

[Former Member]

See last post, it seem to have been a kernel bug or something along those lines. Latest kernel solved the issue.

[Former Member]

Hello All,

Sorry for not responding to your requests for more info, but the issue seem to be solved now. I applied the very latest kernel as of 22nd of July and installed the UUID package for RedHat5 and this seem to have solved the issue... I can now start the system with no errors in the logs and so far all seem well.

Thank you all for your time and effort. It is much appreciated.

BR

Niclas Isgren

[sunny_pahuja2]

Hi,

Check whether listener is working or not. If listener is working then might be the reason number of processes and sessions parameter on database is set to too low because of which work process is not able to connect to database.

Same you can check by connecting to sqlplus and if you get error maximum connection exceed then increase above parameters.

Thanks

Sunny

[Former Member]

Hi,

As far as I can see the listener looks fine, is is started and I haven't seen any errors relating to this. R3trans -x and -d works with return code 0000 and I have no problems connecting through sqlplus with either oradev or devadm user.

Below is my config files for the "important three"

LISTENER

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

1. Filename......: listener.ora

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

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

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

5. @(#) $Id: //bas/720_REL/src/krn/tpls/ora/LISTENER.ORA#1 $

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DEV.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DEV)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = r3dev)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = DEV)

(ORACLE_HOME = /oracle/DEV/112_64)

)

1. (SID_DESC =

2. (SID_NAME = DEV)

3. (ORACLE_HOME = /oracle/DEV/112_64)

4. )

)

tnsnames.ora

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

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

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

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

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

5. @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#1 $

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

DEV.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = r3dev)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DEV)

(GLOBAL_NAME = DEV.WORLD)

)

)

sqlnet.ora

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

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

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

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

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

5. @(#) $Id: //bas/720_REL/src/krn/tpls/ora/SQLNET.ORA#1 $

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

NAMES.DIRECTORY_PATH = (TNSNAMES)

NAME.DEFAULT_ZONE = WORLD

1. 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

1. 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

1. 05.01.06 set to default

TCP.NODELAY=YES

1. 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

I have ensured that the sqlnet.ora and tnsnames.ora are the same in both /oracle/DEV/112_64/network/admin and /usr/sap/DEV/SYS/profile/oracle/.

Edited by: Niclas Isgren on Jul 6, 2011 9:31 AM

[sunny_pahuja2]

Hi,

Are you still facing the same problem. If yes, then please paste dev_w0 logs.

Thanks

Sunny