Dear All

I am having challenges in starting up my system after upgrading from 10.2.0.5.0 to oracle 11.2.0.3.All the upgrade stages went on successful without any issues and I even upgraded my client to oracle 11.2 guided by the upgrade guide from SAP Service Market place.I can start my listerner with the following command:

lsnrctl start

and it starts successfully.I can also logon to the database using sqlplus and the database starts without any problems.The challenge nows comes on starting SAP,the command 'startsap' returns the following message.

Checking LSM Database

------------------------------

Database is not available via R3trans

Running /usr/sap/LSM/SYS/exe/run/startdb

Trying to start LSM database ...

Log file: /home/lsmadm/startdb.log

No SQL*Net V2 connect to LSM available.

Check that the listener is running: "lsnrctl status".

Start the listener as user oralsm: "lsnrctl start".

/usr/sap/LSM/SYS/exe/run/startdb: Terminating with error code 14

DB startup failed

...................................................................................................

My server is on linux redhat 5.6 ,i have tried restarting the listener and checking if all is well but the listener is very much up.I have also checked the tnsnanes.ora,sqlnet.ora and listener.ora for possible errors and typos but i havent noticed any problems with the files.I have attached copies of my tnsnames and listener.ora files to this message.

Your assistance would be greatly appreciated.

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (8)

Thank you all for your contributions,i decided to do a restore to my original version oracle 10.2.0.2 .0 and restart the whole upgrade procedure.This time around the upgrade completed successfully and i managed to start my SAP system without any challenges,your contributions gave me so much insight into areas i might have overlooked during the upgrade especially on the listener.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

why rthere are 2 same parameter entires in PATH and 2 other parameters.

and also make sure that your ora files are fine there.

TNS_ADMIN=/sapmnt/LSM/profile/oracle:/usr/sap/LSM/SYS/profile/oracle????

did any one try this 2 values for TNS_ADMIN?

regards,

Meenakshi

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

can you check the env variable of both the users sidadm and orasid

ORA-12705: Cannot access NLS data files or invalid environment specified

there is some enviroment issue..

can you paste the result of env

as well as listerner.ora and tnsname.ora from the parameter where TNS_ADMIN env poiniting

regards,

Meenakshi

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

redeph:lsmadm 51> env

HOSTNAME=redeph

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

KDE_NO_IPV6=1

SSH_CLIENT=192.168.1.166 61762 22

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

SSH_TTY=/dev/pts/2

USER=lsmadm

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:

KDEDIR=/usr

SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre

MAIL=/var/spool/mail/lsmadm

PATH=/oracle/LSM/112_64/bin:/oracle/LSM/112_64/bin:/opt/IBMJava2-amd64-142/bin:.:/home/lsmadm:/usr/sap/LSM/SYS/exe/run:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

INPUTRC=/etc/inputrc

PWD=/root

JAVA_HOME=/opt/IBMJava2-amd64-142

LANG=en_US.UTF-8

KDE_IS_PRELINKED=1

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

SHLVL=2

HOME=/home/lsmadm

LOGNAME=lsmadm

QTLIB=/usr/lib64/qt-3.3/lib

CVS_RSH=ssh

SSH_CONNECTION=192.168.1.166 61762 192.168.1.55 22

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

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

GROUP=sapsys

HOST=redeph

REMOTEHOST=192.168.1.166

SAPSYSTEMNAME=LSM

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

LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/client/11x_64/instantclient

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=LSM

dbs_ora_schema=SAPSR3

ORACLE_SID=LSM

DB_SID=LSM

ORACLE_BASE=/oracle/LSM

TNS_ADMIN=/sapmnt/LSM/profile/oracle:/usr/sap/LSM/SYS/profile/oracle

ORACLE_HOME=/oracle/LSM/112_64

NLS_LANG=AMERICAN_AMERICAN.UTF8

SAPDATA_HOME=/oracle/LSM

DIR_ORAHOME=/oracle/LSM/112_64

DIR_CLIENT_ORAHOME=/oracle/LSM/112_64

dbs/ora/tnsname=LSM

ORA_NLS33=/oracle/LSM/11203/nls/data

-------------------------------------------------------------------------------------------------------------------------------------------

redeph:lsmadm 51> env

HOSTNAME=redeph

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

KDE_NO_IPV6=1

SSH_CLIENT=192.168.1.166 61762 22

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

SSH_TTY=/dev/pts/2

USER=lsmadm

KDEDIR=/usr

SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre

MAIL=/var/spool/mail/lsmadm

INPUTRC=/etc/inputrc

PWD=/root

JAVA_HOME=/opt/IBMJava2-amd64-142

LANG=en_US.UTF-8

KDE_IS_PRELINKED=1

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

SHLVL=2

HOME=/home/lsmadm

LOGNAME=lsmadm

QTLIB=/usr/lib64/qt-3.3/lib

CVS_RSH=ssh

SSH_CONNECTION=192.168.1.166 61762 192.168.1.55 22

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

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

GROUP=sapsys

HOST=redeph

REMOTEHOST=192.168.1.166

SAPSYSTEMNAME=LSM

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

LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/client/11x_64/instantclient

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=LSM

dbs_ora_schema=SAPSR3

ORACLE_SID=LSM

DB_SID=LSM

ORACLE_BASE=/oracle/LSM

TNS_ADMIN=/sapmnt/LSM/profile/oracle:/usr/sap/LSM/SYS/profile/oracle

ORACLE_HOME=/oracle/LSM/112_64

NLS_LANG=AMERICAN_AMERICAN.UTF8

SAPDATA_HOME=/oracle/LSM

DIR_ORAHOME=/oracle/LSM/112_64

DIR_CLIENT_ORAHOME=/oracle/LSM/112_64

dbs/ora/tnsname=LSM

ORA_NLS33=/oracle/LSM/11203/nls/data

redeph:lsmadm 52> su oralsm

Password:

redeph:oralsm 51> env

HOSTNAME=redeph

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

KDE_NO_IPV6=1

SSH_CLIENT=192.168.1.166 61762 22

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

SSH_TTY=/dev/pts/2

USER=oralsm

KDEDIR=/usr

SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre

MAIL=/var/spool/mail/oralsm

PATH=/oracle/LSM:/oracle/LSM/112_64/bin:/oracle/LSM/112_64/bin:/opt/IBMJava2-amd64-142/bin:.:/home/lsmadm:/usr/sap/LSM/SYS/exe/run:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

INPUTRC=/etc/inputrc

PWD=/root

JAVA_HOME=/opt/IBMJava2-amd64-142

LANG=en_US.UTF-8

KDE_IS_PRELINKED=1

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

SHLVL=3

HOME=/oracle/LSM

LOGNAME=oralsm

QTLIB=/usr/lib64/qt-3.3/lib

CVS_RSH=ssh

SSH_CONNECTION=192.168.1.166 61762 192.168.1.55 22

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

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

GROUP=sapsys

HOST=redeph

REMOTEHOST=192.168.1.166

SAPSYSTEMNAME=LSM

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

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=LSM

dbs_ora_schema=SAPSR3

ORACLE_SID=LSM

DB_SID=LSM

ORACLE_BASE=/oracle

TNS_ADMIN=/sapmnt/LSM/profile/oracle:/usr/sap/LSM/SYS/profile/oracle

ORACLE_HOME=/oracle/LSM/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/LSM

DIR_ORAHOME=/oracle/LSM/112_64

DIR_CLIENT_ORAHOME=/oracle/LSM/112_64

dbs/ora/tnsname=LSM

ORA_NLS33=/oracle/LSM/11203/nls/data

LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/LSM/112_64/lib

DIR_SERVER_ORAHOME=/oracle/LSM/112_64

------------------------------------------------------------------------------------------------------------------------

As I have mentioned earlier tnsnames.ora and listener.ora under the path to TNS_ADMIN are just direct copies of tnsnames.ora/listener.ora in my oracle directory whose contents are as just the same as are ones i pasted earlier.

Hi Roy,

Try this:

"cd /oracle/LSM/11203/nls/data" using lsmadm and let us know if you get any error

Regards.

Ruchit

lsmadm can cd into in the nls directory:

cd /oracle/LSM/11203/nls/data/

redeph:lsmadm 52> pwd

/oracle/LSM/11203/nls/data

the startdb.log contents:

------------------------------ Sat Aug 25 10:53:00 CAT 2012

starting database

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 10:53:00 2012

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

ORA-01031: insufficient privileges

------------------------------ Sat Aug 25 10:53:00 CAT 2012

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/LSM/SYS/exe/run/startdb: Terminating with error code 12

Hi Roy,

Please do one thing. Please ensure that group "dba" is set as the group for /oracle/LSM/112_64 and then :

chmod -R g+rx /oracle/LSM/112_64

Try with that. If that doesn't work then

chmod -R g+w /oracle/LSM/112_64

And then again do a restart.

Shutdown listener and DB (if started) before issuing chmod.

Also before you do any of it try to start DB using sqlplus as lsmadm and see if that throws up some additional error logs.

Regards.

Ruchit.

redeph:lsmadm 55> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 11:35:35 2012

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

......................................................................................................................................................

Hi Roy,

Just for a second can you confirm if the directory /oracle/LSM/11203/ocommon/nls/admin/data exist on your system? Ideally this must be the value of ORA_NLS33 for both <sid>adm and ora<sid> on DB server. On Appl Server it has to be /oracle/<oracle client_rel>/ocommon/nls/admin/data for <sid>adm.

So if the directory /oracle/LSM/11203/ocommon/nls/admin/data exists and has files in it just try to set ORA_NLS33 to this path for <sid>adm on DB server and then try startdb.

Regards.

Ruchit

You need to set the following environment variable for ora<sid>

ORA_NLS10=/oracle/LSM/11203/nls/data

Do not set this for <sid>adm since it is using the oracle instant client .

Regards

Ratnajit

hi,

just check you sidadm is aslo part of dba and oper group.

this the issue with Orcale 11.2.0.3

when you upgrade oracle in upgarde result screen it will tell you about the parameter added LOCAL_LISTERNER= Listerner_<SID>

this is new statgery followed by oracle.

the other work around

so we renamed the file initCP9.ora with initCP9.ora.old file for backup in new oracle home and copy the file initCP9.ora from old Oracle home. in ur case (10.2.0.5.0)

As well as there are few changes need to be maintain in listener.ora file like Oracle Home.

regards,

Meenakshi

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

SIDadm is indeed a member of dba an oper groups .Which specific changes did you make to the initSID.ora if it worked for you because i have tried that but im still facing return code 12 being attributed to ORA-12705.listener.ora was changed to point to the new oracle home ,are you suggesting that it has to be set back to the old home if the initSID.ora file from the old home is to be used?

Go to dbs inside your oracle home

ewru080001:oranwd 67> pwd

/oracle/NWD/11203/dbs

And copy initNWD.ora and spfileNWD.ora

cp -p initNWD.ora initNWD.ora.old

cp -p spfileNWD.ora spfileNWD.ora.old

copy initNWD.ora and spfileNWD.ora from old oracle home

cp -p ../../112_64_old/dbs/initNWD.ora .

cp -p ../../112_64_old/dbs/initNWD.sap

start listener.

Start lsnrctl

also check the oracle home env variable...

lsnrctl-> name? must be the same as specified in listener.ora and tnsname.ora file.

in these file oracle home is also defined.. so check oracle home is also set.

regards,

Meenakshi

I have done as suggested but since i am upgrading from from 10.2.0.5.0 to 11.2 it also means i must adjust the Compatible parameter to 11.2 ,this i have also done my database and lsnrctl both starts successfully.On starting SAP ,im still facing return code 12 and according to the trans.log file my problem is still being caused by ORA-12705 ,see below for the content of trans.log:

ETW000 R3trans version 6.14 (release 701 - 24.07.12 - 20:12:04 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 24.08.2012 - 16:34:54

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Fri Aug 24 16:34:54 2012 72 0.000072

4 ETW000 [ dev trc,00000] db_con_init called 21 0.000093

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 30 0.000123

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/LSM/SYS/exe/run/dboraslib.so' ... 29 0.000152

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/LSM/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 8689 0.008841

4 ETW000 [ dev trc,00000] Library '/usr/sap/LSM/SYS/exe/run/dboraslib.so' loaded 18 0.008859

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 30 0.008889

4 ETW000 [ dev trc,00000] Version of '/usr/sap/LSM/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.186)

4 ETW000 52 0.008941

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 19 0.008960

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 39 0.008999

4 ETW000 [ dev trc,00000] New connection 0 created 16 0.009015

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 34 0.009049

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 21 0.009070

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 13 0.009083

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 26 0.009109

4 ETW000 [ dev trc,00000] -->oci_init1 216 0.009325

4 ETW000 [ dev trc,00000] Oracle Client Version: '11.2.0.3.0', (dbsl 701 110412, UNICODE[2]) 51 0.009376

4 ETW000 [ dev trc,00000] Default connection: tnsname ='LSM' 31 0.009407

4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2) 18 0.009425

4 ETW000 [ dev trc,00000] Application info callback registered. 17 0.009442

4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 10204 0.019646

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0xfc49c38) 34 0.019680

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0xfc4acb8) 32 0.019712

4 ETW000 [ dev trc,00000] NLS env.: lang=41004D00450052004900430041004E00 75 0.019787

4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 17 0.019804

4 ETW000 [ dev trc,00000] char=55005400460031003600 13 0.019817

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'

4 ETW000 21 0.019838

4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 12 0.019850

4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 15 0.019865

4 ETW000 [ dev trc,00000] Connecting as /@LSM on connection 0 (nls 0) ... (dbsl 701 110412, UNICODE[2])

4 ETW000 20 0.019885

4 ETW000 [ dev trc,00000] Allocating service context handle for con=0 19 0.019904

4 ETW000 [ dev trc,00000] Allocating server context handle 14 0.019918

4 ETW000 [ dev trc,00000] Attaching to DB Server LSM (con=0,svchp=0xfc4abd8,srvhp=0xfc4dc80) 33 0.019951

4 ETW000 [ dev trc,00000] Assigning server context 0xfc4dc80 to service context 0xfc4abd8 21599 0.041550

4 ETW000 [ dev trc,00000] Allocating user session handle 53 0.041603

4 ETW000 [ dev trc,00000] Starting user session: OCISessionBegin(con=0, usr='/',svchp=0xfc4abd8, srvhp=0xfc4dc80, usrhp=0xfc7c100)

4 ETW000 37 0.041640

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 2253 0.043893

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 12705: 98 0.043991

4 ETW000 [ dev trc,00000] ORA-12705: Cannot access NLS data files or invalid environment specified

4 ETW000 28 0.044019

4 ETW000 [ dev trc,00000] server_detach(con=0,stale=1,svrhp=0xfc4dc80) 13 0.044032

4 ETW000 [ dev trc,00000] Detaching from DB Server (con=0,svchp=0xfc4abd8,srvhp=0xfc4dc80) 13 0.044045

4 ETW000 [ dev trc,00000] Deallocating server context handle 0xfc4dc80 from con=0 217 0.044262

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

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 12705 17 0.044326

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12705) 14 0.044340

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 12705 82 0.044422

4 ETW000 [ dev trc,00000] ORA-12705: Cannot access NLS data files or invalid environment specified

4 ETW000 25 0.044447

4 ETW000 [ dev trc,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12705. 18 0.044465

4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 12705 performing CON [dblink#4 @ 433] 43 0.044508

4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-12705: Cannot access NLS data files or invalid environment specified [dblink#4 @ 433]

4 ETW000 22 0.044530

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'LSM'"

if possible please paste startdb.log it will have some details and also try what Ratnajit recommended above. These two log files will help us troubleshoot further.

Regards

Amit Padmawar

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear All

Below is copy of my trans.log after running R3trans -d

4 ETW000 R3trans version 6.14 (release 701 - 24.07.12 - 20:12:04 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 22.08.2012 - 15:37:39

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Wed Aug 22 15:37:39 2012 677 0.000677

4 ETW000 [ dev trc,00000] db_con_init called 40 0.000717

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 34 0.000751

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/LSM/SYS/exe/run/dboraslib.so' ... 29 0.000780

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/LSM/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 7803 0.008583

4 ETW000 [ dev trc,00000] Library '/usr/sap/LSM/SYS/exe/run/dboraslib.so' loaded 16 0.008599

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 25 0.008624

4 ETW000 [ dev trc,00000] Version of '/usr/sap/LSM/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.186)

4 ETW000 52 0.008676

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 19 0.008695

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 58 0.008753

4 ETW000 [ dev trc,00000] New connection 0 created 16 0.008769

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 35 0.008804

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 23 0.008827

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 14 0.008841

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 28 0.008869

4 ETW000 [ dev trc,00000] -->oci_init1 156 0.009025

4 ETW000 [ dev trc,00000] Oracle Client Version: '11.2.0.3.0', (dbsl 701 110412, UNICODE[2]) 49 0.009074

4 ETW000 [ dev trc,00000] Default connection: tnsname ='LSM' 14 0.009088

4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2) 15 0.009103

4 ETW000 [ dev trc,00000] Application info callback registered. 13 0.009116

4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 9663 0.018779

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0xb1c5e18) 35 0.018814

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0xb1c6e98) 32 0.018846

4 ETW000 [ dev trc,00000] NLS env.: lang=41004D00450052004900430041004E00 92 0.018938

4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 20 0.018958

4 ETW000 [ dev trc,00000] char=55005400460031003600 17 0.018975

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'

4 ETW000 20 0.018995

4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 13 0.019008

4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 15 0.019023

4 ETW000 [ dev trc,00000] Connecting as /@LSM on connection 0 (nls 0) ... (dbsl 701 110412, UNICODE[2])

4 ETW000 21 0.019044

4 ETW000 [ dev trc,00000] Allocating service context handle for con=0 4788 0.023832

4 ETW000 [ dev trc,00000] Allocating server context handle 25 0.023857

4 ETW000 [ dev trc,00000] Attaching to DB Server LSM (con=0,svchp=0xb1c6db8,srvhp=0xb1c9e60) 53 0.023910

4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 393 0.024303

4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 100 0.024403

4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 26 0.024429

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

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 12154 15 0.024462

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12154) 15 0.024477

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 12154 62 0.024539

4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 22 0.024561

4 ETW000 [ dev trc,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12154. 16 0.024577

4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 12154 performing CON [dblink#4 @ 433] 3947 0.028524

4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#4 @ 433]

4 ETW000 29 0.028553

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'LSM'"

...............................................................................................................................................

Output of SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS

------------------------------ --------------------------------

SYSTEM OPEN

SYS OPEN

OPS$LSMADM OPEN

OPS$ORALSM OPEN

OPS$SAPSERVICELSM OPEN

OPS$SR3ADM OPEN

SAPSR3 OPEN

SAPSR3DB OPEN

ORACLE_OCM LOCKED

DIP LOCKED

OUTLN LOCKED

USERNAME ACCOUNT_STATUS

------------------------------ --------------------------------

APPQOSSYS LOCKED

DBSNMP LOCKED

13 rows selected.

............................................................................................................................................

startdb.log

----------------------------- Wed Aug 22 19:02:00 CAT 2012

LOGFILE FOR STARTING ORACLE

Trying to start LSM database ...

------------------------------ Wed Aug 22 19:02:00 CAT 2012

checking required environment variables

ORACLE_HOME is >/oracle/LSM/112_64<

ORACLE_SID is >LSM<

------------------------------ Wed Aug 22 19:02:00 CAT 2012

check initora

------------------------------ Wed Aug 22 19:02:00 CAT 2012

check initora

------------------------------ Wed Aug 22 19:02:00 CAT 2012

checking V2 connect

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 22-AUG-2012 19:02:00

Used parameter files:

/oracle/LSM/112_64/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

V2 connect is not available. Terminating

/usr/sap/LSM/SYS/exe/run/startdb: Terminating with error code 14

.............................................................................................................................................

In the tnsnames.ora , please change the port to 1527 . Its 1521.

Then try R3trans -d should work and start the system.

Regards

Ratnajit

I have made the changes but im still facing the same error

can you restart the listener ?

Then run R3trans -d and paste the output.

Regards

Ratnajit

Hello Roy,

Please go through Note 443867 - ORA-12154 Collective SAP note, in case you didnt check it.

Regards,

Vishal

latest trans.log

4 ETW000 R3trans version 6.14 (release 701 - 24.07.12 - 20:12:04 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 23.08.2012 - 09:57:37

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [ dev trc,00000] Thu Aug 23 09:57:37 2012 72 0.000072

4 ETW000 [ dev trc,00000] db_con_init called 18 0.000090

4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 24 0.000114

4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/LSM/SYS/exe/run/dboraslib.so' ... 29 0.000143

4 ETW000 [ dev trc,00000] DlLoadLib() success: dlopen("/usr/sap/LSM/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 8406 0.008549

4 ETW000 [ dev trc,00000] Library '/usr/sap/LSM/SYS/exe/run/dboraslib.so' loaded 19 0.008568

4 ETW000 [ dev trc,00000] function DbSlExpFuns loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 30 0.008598

4 ETW000 [ dev trc,00000] Version of '/usr/sap/LSM/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.186)

4 ETW000 72 0.008670

4 ETW000 [ dev trc,00000] function dsql_db_init loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 20 0.008690

4 ETW000 [ dev trc,00000] function dbdd_exp_funs loaded from library /usr/sap/LSM/SYS/exe/run/dboraslib.so

4 ETW000 76 0.008766

4 ETW000 [ dev trc,00000] New connection 0 created 26 0.008792

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 38 0.008830

4 ETW000 [ dev trc,00000] db_con_connect (con_name=R/3) 22 0.008852

4 ETW000 [ dev trc,00000] find_con_by_name found the following connection for reuse: 14 0.008866

4 ETW000 [ dev trc,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 27 0.008893

4 ETW000 [ dev trc,00000] -->oci_init1 340 0.009233

4 ETW000 [ dev trc,00000] Oracle Client Version: '11.2.0.3.0', (dbsl 701 110412, UNICODE[2]) 58 0.009291

4 ETW000 [ dev trc,00000] Default connection: tnsname ='LSM' 15 0.009306

4 ETW000 [ dev trc,00000] -->oci_initialize(con=0, char='UTF16', nchar='AL16UTF16', uc_ln=2) 18 0.009324

4 ETW000 [ dev trc,00000] Application info callback registered. 13 0.009337

4 ETW000 [ dev trc,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 33642 0.042979

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrHp=0x6f7ec38) 34 0.043013

4 ETW000 [ dev trc,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con=0, ErrBt=0x6f7fcb8) 37 0.043050

4 ETW000 [ dev trc,00000] NLS env.: lang=41004D00450052004900430041004E00 80 0.043130

4 ETW000 [ dev trc,00000] terr=41004D0045005200490043004100 18 0.043148

4 ETW000 [ dev trc,00000] char=55005400460031003600 13 0.043161

4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo): con=0, 'AMERICAN_AMERICA.UTF16'

4 ETW000 23 0.043184

4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 12 0.043196

4 ETW000 [ dev trc,00000] Logon as OPS$-user to get SAPSR3's password 16 0.043212

4 ETW000 [ dev trc,00000] Connecting as /@LSM on connection 0 (nls 0) ... (dbsl 701 110412, UNICODE[2])

4 ETW000 21 0.043233

4 ETW000 [ dev trc,00000] Allocating service context handle for con=0 21 0.043254

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

4 ETW000 [ dev trc,00000] Attaching to DB Server LSM (con=0,svchp=0x6f7fbd8,srvhp=0x6f82c80) 36 0.043305

4 ETW000 [ dev trc,00000] Thu Aug 23 09:57:40 2012 3550307 3.593612

4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR 48 3.593660

4 ETW000 [ dev trc,00000] OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154: 112 3.593772

4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 27 3.593799

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

4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 12154 16 3.593836

4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=12154) 16 3.593852

4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 12154 62 3.593914

4 ETW000 [ dev trc,00000] ORA-12154: TNS:could not resolve the connect identifier specified

4 ETW000 22 3.593936

4 ETW000 [ dev trc,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=12154. 17 3.593953

4 ETW000 [ dblink ,00433] ***LOG BY2=>sql error 12154 performing CON [dblink#4 @ 433] 41 3.593994

4 ETW000 [ dblink ,00433] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#4 @ 433]

4 ETW000 22 3.594016

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'LSM'"

I have checked the sapnote and also checked the files against recommendation from the sapnote but i havent noticed where the problem is

Can you run the command

# tnsping <SID>

and check .

If things work fine , please run cleanipc (cleanipc <instance_no> remove) as <sid>adm

Can you paste the tnsnames.ora and listener.ora again.

Regards

Ratnajit

tnsping LSM : returns the following

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 10:20:17

Used parameter files:

/oracle/LSM/112_64/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

...................................................................................................................................................................................

I have attached listener.ora and tsnames.ora ,i ahve also incuded sqlnet.ora in case you may also want to look into it.

What command you use to start listener?

Regards

Roman

Hi Roy,

Simply do this:

ps -ef|grep tns and post the output here.

Anyways let me tell you the solution. Your listener isn't running.

In the first you have mentioned that u stared listener as lsnrctl start (i.e default listernewd)

You have to start LISTENER_LSM and not LISTENER. So do this :

lsnrctl stop

lsnrctl LISTENER_LSM start

and then do tnsping.

Regards.

Ruchit Khushu

If you update your tnsnames.ora file in $TNS_ADMIN folder for <sid>adm user after oracle upgrade? You have listener with name LISTENER_LSM but command to start (in your first post) is lsnrctl start

Regards

Roman

The first time you pasted the listener.ora had LISTENER as the name but now its LISTENER_LSM . Did you change in between ?

Regards

Ratnajit

ps ef|grep tns returns:

18845 pts/2 R+ 0:00 \_ ps ef HOSTNAME=redeph TERM=vt100 SHELL=/bin/csh HISTSIZE=1000 KDE_NO_IPV6=1 SSH_CLIENT=192.168.1.166 58866 22 QTDIR=/usr/lib64/qt-3.3 QTINC=/usr/lib64/qt-3.3/include SSH_TTY=/dev/pts/2 USER=oralsm 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: KDEDIR=/usr SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre MAIL=/var/spool/mail/oralsm PATH=/oracle/LSM/112_64/bin:.:/oracle/LSM:/usr/sap/LSM/SYS/exe/run:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin INPUTRC=/etc/inputrc PWD=/root JAVA_HOME=/opt/IBMJava2-amd64-142 LANG=en_US.UTF-8 KDE_IS_PRELINKED=1 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=2 HOME=/oracle/LSM LOGNAME=oralsm QTLIB=/usr/lib64/qt-3.3/lib CVS_RSH=ssh SSH_CONNECTION=192.168.1.166 58866 192.168.1.55 22 LESSOPEN=|/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES=1 _=/bin/su HOSTTYPE=x86_64-linux VENDOR=unknown OSTYPE=linux MACHTYPE=x86_64 GROUP=dba HOST=redeph REMOTEHOST=192.168.1.166 SAPSYSTEMNAME=LSM DIR_LIBRARY=/usr/sap/LSM/SYS/exe/run LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/LSM/112_64/lib THREAD=NOPS dbms_type=ORA dbs_ora_tnsname=LSM dbs_ora_schema=SAPSR3 ORACLE_SID=LSM DB_SID=LSM ORACLE_BASE=/oracle ORACLE_HOME=/oracle/LSM/112_64 NLS_LANG=AMERICAN_AMERICA.UTF8 SAPDATA_HOME=/oracle/LSM DIR_SERVER_ORAHOME=/oracle/LSM/112_64 dbs/ora/tnsname=LSM

18846 pts/2 S+ 0:00 \_ grep tns HOSTNAME=redeph TERM=vt100 SHELL=/bin/csh HISTSIZE=1000 KDE_NO_IPV6=1 SSH_CLIENT=192.168.1.166 58866 22 QTDIR=/usr/lib64/qt-3.3 QTINC=/usr/lib64/qt-3.3/include SSH_TTY=/dev/pts/2 USER=oralsm 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: KDEDIR=/usr SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre MAIL=/var/spool/mail/oralsm PATH=/oracle/LSM/112_64/bin:.:/oracle/LSM:/usr/sap/LSM/SYS/exe/run:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin INPUTRC=/etc/inputrc PWD=/root JAVA_HOME=/opt/IBMJava2-amd64-142 LANG=en_US.UTF-8 KDE_IS_PRELINKED=1 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=2 HOME=/oracle/LSM LOGNAME=oralsm QTLIB=/usr/lib64/qt-3.3/lib CVS_RSH=ssh SSH_CONNECTION=192.168.1.166 58866 192.168.1.55 22 LESSOPEN=|/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES=1 _=/bin/su HOSTTYPE=x86_64-linux VENDOR=unknown OSTYPE=linux MACHTYPE=x86_64 GROUP=dba HOST=redeph REMOTEHOST=192.168.1.166 SAPSYSTEMNAME=LSM DIR_LIBRARY=/usr/sap/LSM/SYS/exe/run LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/LSM/112_64/lib THREAD=NOPS dbms_type=ORA dbs_ora_tnsname=LSM dbs_ora_schema=SAPSR3 ORACLE_SID=LSM DB_SID=LSM ORACLE_BASE=/oracle ORACLE_HOME=/oracle/LSM/112_64 NLS_LANG=AMERICAN_AMERICA.UTF8 SAPDATA_HOME=/oracle/LSM DIR_SERVER_ORAHOME=/oracle/LSM/112_64 dbs/ora/tnsname=LSM

.......................................................................................................................................

and start listener that command returns :

redeph:oralsm 61> lsnrctl LISTENER_LSM start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 11:07:58

NL-00853: undefined command "LISTENER_LSM". Try "help"

...............................................................................................................................

My bad. Typo error.

Try:

lsnrctl start LISTENER_LSM

Regards.

Ruchit.

Yes it has been changed infact returned to the name recommended by the upgrade guide "LISTENER_LSM".the latest listener.ora is the current status of the file

1) Check current status of unnamed listener with lsnrctl status command. If it active, stop it with lsnrctl stop command.

2) start listener with lsnrctl start LISTENER_LSM command

3) check connection with R3trans -d command. If all ok, start SAP system

Regards

Roman

Make sure you are copying the tnsnames.ora under $ORACLE_HOME/network/admin to the path specified by environment variable TNS_ADMIN (for <sid>adm) on all SAP application servers

Regards.

Ruchit Khushu

The database and SAP application server are all on one server and yes the tnsnames.ora has been copied to /sapmnt/LSM/profile/oracle,

I have restarted the server and started the listener successfully with command:

>lsnrctl start LISTENER_LSM

>R3trans -d still returns error code 0012:

This is R3trans version 6.14 (release 701 - 24.07.12 - 20:12:04 ).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'LSM'"

R3trans finished (0012).

>tnsping LSM

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 12:32:46

Used parameter files:

/oracle/LSM/112_64/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

.............................................................................................................................................

My problem is still the same

Please remove LISTENER_ from the very first line of tnsnames.ra file.

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

# Filename......: tnsnames.ora

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

# Name..........:

# Date..........:

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#1 $

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

LSM.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = redeph)

(PORT = 1521)

)

(CONNECT_DATA =

(SID = LSM)

(GLOBAL_NAME = LSM.WORLD)

)

Check if this works.

Regards

Ratnajit

Removing LISTENER will result in following scenarios:

1) tnsping LSM

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 13:16:01

Used parameter files:

/oracle/LSM/112_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = redeph) (PORT = 1521))) (CONNECT_DATA = (SID = LSM) (GLOBAL_NAME = LSM.WORLD)))

OK (0 msec)

But the database will result in the following error

2) SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_LSM'

Which is solved by appending LISTENER_ to the starting of tnsnames.ora

3) startsap

Checking LSM Database

------------------------------

Database is not available via R3trans

Running /usr/sap/LSM/SYS/exe/run/startdb

Trying to start LSM database ...

Log file: /home/lsmadm/startdb.log

/usr/sap/LSM/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

Please paste the output from the following commands:

lsnrctl status

lsnrctl status LISTENER_LSM

In addition to Ratnajit Day suggestion, add the following to tnsnames.ora file:

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

# Filename......: tnsnames.ora

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

# Name..........:

# Date..........:

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#1 $

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

LISTENER_LSM.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = redeph) (PORT = 1521))

LSM.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = redeph)

(PORT = 1521)

)

(CONNECT_DATA =

(SID = LSM)

(GLOBAL_NAME = LSM.WORLD)

)

Regards

Roman

>lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 13:48:12

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER_LSM

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 23-AUG-2012 13:44:11

Uptime 0 days 0 hr. 4 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

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

Listener Log File /oracle/diag/tnslsnr/redeph/listener_lsm/alert/log.xml

Listening Endpoints Summary...

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

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redeph.ttcs.co.zw)(PORT=1521)))

The listener supports no services

The command completed successfully

..........................................................................................................................................

2> lsnrctl status LISTENER_LSM

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 13:49:14

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

STATUS of the LISTENER

------------------------

Alias LISTENER_LSM

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 23-AUG-2012 13:44:11

Uptime 0 days 0 hr. 5 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

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

Listener Log File /oracle/diag/tnslsnr/redeph/listener_lsm/alert/log.xml

Listening Endpoints Summary...

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

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redeph.ttcs.co.zw)(PORT=1521)))

The listener supports no services

The command completed successfully

........................................................................................................................................

The above are the output of both commands,but this setting of tnsnames.ora results in ORA-00119 when starting my database

Please check if LOCAL_LISTENER parameter was set in pfile/spfile

Regards

Roman

Hi Roy,

Assuming LISTENER_LSM is the only one that is up. What is the value in tnsnames.ora under TNS_ADMIN path of lsmadm ?

Regards.

Ruchit.

local_listener is set to LISTENER_LSM in the initLSM.ora

tnsnames.ora under the path to $TNS_ADMIN (/sapmnt/LSM/profile/oracle) is the same as the one in /oracle/LSM/11203/network/admin since it is a direct copy and updated simultanesously

Hi Roy,

Start the DB manually. Using <sid>adm do tnsping LSM and see if that is working and next do an R3trans -d. Publish the resultant trans.log. Ensure LISTENER_LSM is the only listener running.

Regards.

Ruchit Khushu

Did you try what Roman had suggested . In tnsnames.ora edit as follows

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

# Filename......: tnsnames.ora

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

# Name..........:

# Date..........:

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#1 $

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

LSM.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = redeph)

(PORT = 1521)

)

(CONNECT_DATA =

(SID = LSM)

(GLOBAL_NAME = LSM.WORLD)

)

LISTENER_LSM.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = redeph) (PORT = 1521))

Regards

Ratnajit

Oh yeah...This should be done before anything else.

Regards.

Ruchit.

Yes that is the current setting of my tnsnames.ora.

I have attached a copy the startdb log file ,it appears to be a permissions issue with ORA-12705 and ORA-01031 ,if so which permissions are missing?

startdb.log contents

------------------------------ Thu Aug 23 15:10:48 CAT 2012

LOGFILE FOR STARTING ORACLE

Trying to start LSM database ...

------------------------------ Thu Aug 23 15:10:48 CAT 2012

checking required environment variables

ORACLE_HOME is >/oracle/LSM/112_64<

ORACLE_SID is >LSM<

------------------------------ Thu Aug 23 15:10:48 CAT 2012

check initora

------------------------------ Thu Aug 23 15:10:48 CAT 2012

check initora

------------------------------ Thu Aug 23 15:10:48 CAT 2012

checking V2 connect

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 23-AUG-2012 15:10:48

Used parameter files:

/oracle/LSM/112_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = redeph) (PORT = 1521))) (CONNECT_DATA = (SID = LSM) (GLOBAL_NAME = LSM.WORLD)))

OK (0 msec)

tnsping: V2 connect to LSM

------------------------------ Thu Aug 23 15:10:48 CAT 2012

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

------------------------------ Thu Aug 23 15:10:48 CAT 2012

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

------------------------------ Thu Aug 23 15:10:48 CAT 2012

starting database

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 23 15:10:48 2012

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

ORA-01031: insufficient privileges

------------------------------ Thu Aug 23 15:10:48 CAT 2012

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/LSM/SYS/exe/run/startdb: Terminating with error code 12

Please paste the environment of <sid>adm .

Also make sure there is no ORA_NLS* env set for <sid>adm user.

Also check the NLS_LANG = language_territory.characterset is set correctly.

Regards

Ratnajit

Output of env for sidadm

redeph:lsmadm 51> env

HOSTNAME=redeph

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

KDE_NO_IPV6=1

SSH_CLIENT=192.168.1.166 64852 22

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

SSH_TTY=/dev/pts/2

USER=lsmadm

KDEDIR=/usr

SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre

MAIL=/var/spool/mail/lsmadm

PATH=/oracle/LSM/112_64/bin:/oracle/LSM/112_64/bin:/opt/IBMJava2-amd64-142/bin:/home/lsmadm:/oracle/LSM/112_64/bin:.:/oracle/LSM:/usr/sap/LSM/SYS/exe/run:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

INPUTRC=/etc/inputrc

PWD=/usr/sap

JAVA_HOME=/opt/IBMJava2-amd64-142

LANG=en_US.UTF-8

KDE_IS_PRELINKED=1

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

SHLVL=5

HOME=/home/lsmadm

LOGNAME=lsmadm

QTLIB=/usr/lib64/qt-3.3/lib

CVS_RSH=ssh

SSH_CONNECTION=192.168.1.166 64852 192.168.1.55 22

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

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

GROUP=dba

HOST=redeph

REMOTEHOST=192.168.1.166

SAPSYSTEMNAME=LSM

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

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=LSM

dbs_ora_schema=SAPSR3

ORACLE_SID=LSM

DB_SID=LSM

ORACLE_BASE=/oracle/LSM

ORACLE_HOME=/oracle/LSM/112_64

NLS_LANG=AMERICAN_AMERICAN.UTF8

SAPDATA_HOME=/oracle/LSM

DIR_SERVER_ORAHOME=/oracle/LSM/112_64

dbs/ora/tnsname=LSM

TNS_ADMIN=/oracle/LSM/112_64/network/admin:/usr/sap/LSM/SYS/profile/oracle

LIBPATH=/usr/sap/LSM/SYS/exe/run:/usr/sap/LSM/DVEBMGS00/exe:/oracle/client/11x_64/instantclient:/oracle/LSM/112_64/lib

SHLIB_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/client/11x_64/instantclient:/oracle/LSM/112_64

DIR_ORAHOME=/oracle/LSM/112_64

DIR_CLIENT_ORAHOME=/oracle/LSM/112_64

LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/usr/sap/LSM/DVEBMGS00/exe:/oracle/client/11x_64/instantclient:/oracle/LSM/112_64/lib

What is the SAP netweaver version you are on ?

Is the oracle client version 11.2.0.3?

What is the SAP kernel and patch level ?

Also paste the environment of oa<sid>

I suggest you upgrade the kernel as well.

Also check SAP note Note 819829 - Oracle Instant Client Installation and Configuration on Unix

You do not require LIBPATH and SHLIB_PATH

Set LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/client/11x_64/instantclient

and not the way specified.

Regards

Ratnajit

My system is solman 7.00 Ehp1 ,the kernel version is 701 and the latest patch was applied so its running on patch level 194 .The client is oracle 11.2.0.3.0 and the suggested sapnote is the one i used for the client configuration (8198269) ,i have made the changes to the LD_LIBRARY_PATH environment for sidadm.Below are the environment variables for orasid

redeph:oralsm 51> env

HOSTNAME=redeph

TERM=vt100

SHELL=/bin/csh

HISTSIZE=1000

KDE_NO_IPV6=1

SSH_CLIENT=192.168.1.166 49773 22

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

SSH_TTY=/dev/pts/2

USER=oralsm

KDEDIR=/usr

SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142/jre

MAIL=/var/spool/mail/oralsm

INPUTRC=/etc/inputrc

PWD=/root

JAVA_HOME=/opt/IBMJava2-amd64-142

LANG=en_US.UTF-8

KDE_IS_PRELINKED=1

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

SHLVL=3

HOME=/oracle/LSM

LOGNAME=oralsm

QTLIB=/usr/lib64/qt-3.3/lib

CVS_RSH=ssh

SSH_CONNECTION=192.168.1.166 49773 192.168.1.55 22

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

G_BROKEN_FILENAMES=1

_=/bin/su

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

GROUP=sapsys

HOST=redeph

REMOTEHOST=192.168.1.166

SAPSYSTEMNAME=LSM

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

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=LSM

dbs_ora_schema=SAPSR3

ORACLE_SID=LSM

DB_SID=LSM

ORACLE_BASE=/oracle

TNS_ADMIN=/sapmnt/LSM/profile/oracle:/usr/sap/LSM/SYS/profile/oracle

ORACLE_HOME=/oracle/LSM/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/LSM

DIR_ORAHOME=/oracle/LSM/112_64

DIR_CLIENT_ORAHOME=/oracle/LSM/112_64

dbs/ora/tnsname=LSM

LD_LIBRARY_PATH=/usr/sap/LSM/SYS/exe/run:/oracle/LSM/112_64/lib

DIR_SERVER_ORAHOME=/oracle/LSM/112_64

Can you please check this SAP note

Note 592657 - ORA-12701/ORA-12705/ORA-12709

Regards

Ratnajit

Hi,

Fire this command from sql

select username, account_status from dba_users;

Let me know the output. May be SAPSR3 user is locked.

Regards,

karthik

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Can you please runs R3trans -d using <sid>adm and paste the trans.log file here.

Regards

Ratnajit

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

Startsap Terminating with error code 14

Accepted Solutions (0)

Answers (8)

Answers (8)

Note 592657 - ORA-12701/ORA-12705/ORA-12709

Re: SAP Cloud Identity Services - Identity Authent...

There were some trfcs error in SAP car but we have...

Re: The deployed project is not reflecting in Agen...

Re: SAP MAXDB : Content Server Administration - Re...

Re: LLM, RAG and Cloud Foundry: No space left on d...