Unable to Start SAP

[Former Member]

Hi,

I get a following message when i try to start SAP using STARTSAP.

maltr35:sbdadm 16> startsap

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

***********************************************************************

• This is Saposcol Version COLL 20.94 640 - AIX v10.35 5L-64 bit 070216

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 4448328) is already running .....

************************************************************************

saposcol already running

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

Trying to start SBD database ...

Log file: /home/sbdadm/startdb.log

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

DB startup failed

The STARTDB.LOG states that the DATABASE is already OPEN with error code 0012.

<b>I tried to start the oracle manually and tried starting sap using startsap R3. then it gives me the following error. </b>

maltr35:sbdadm 15> startsap R3

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

***********************************************************************

• This is Saposcol Version COLL 20.94 640 - AIX v10.35 5L-64 bit 070216

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 4448328) is already running .....

************************************************************************

saposcol already running

Database SBD must be started first

ALSO STARTED THE LISTERNER AND STARTED THE DATABASE AND TRIED STARTING SAP STILL IT FAILS WITH THE FIRST ERROR MESSAGE MENTIONED ABOVE, KINDLY LET ME KNOW WHAT SHOULD BE DONE.

[madhukara_shenoy]

Hello Naresh,

Did you check the all the points from the SAP note 592657 (which i mentioned in some replies) .

Even if the problem occurs after this (make sure permission and authorization is correct), then the reason could be some files are corrupted / missing from the client directory. So you can try for re-installation of client.

Anyways, can attach the latest trans.log generated by the R3trans -d

Regards,

Madhukar

[Former Member]

Hi madhukar,

I fixed the problem by setting the NLS_33 variable pointing to the server

setenv ORA_NLS33 /oracle/SBD/920_64/ocommon/nls/admin/data and this fixed the issue. but i am still not statisfied as the the systems doesnt starts if the NLS is pointing to the client, so i guess there might be problem with the client. And also I have an Other Issue, i am trying to install a QA system on the same server where my Development is existing. do i need to install the client software for the QA system??? Kindly let me know what i can do...

[madhukara_shenoy]

Hello Naresh,

Somehow I had strong feeling of the client issue (that's the reason in first reply itself i asked you to set the ORA_NLS33 to server software and try) for the initial startsap error. Please reinstall the client (refer the note 539922 and make sure all the points given in this note is taken care). Then it will be fixed.

If you are installing the another system which has the same SAP kernel then you need not install the separate oracle client. Same client can be used by both the systems. Make sure ORA_NLS33 points to the same client.

Please reward the points if hints given by any processor helped you.

Regards,

Madhukar

[Former Member]

Hi Madhukar,

I have fixed the problem by changing environmental variable NLS_33 of <SID>adm with ORA<sid> and that has worked, but i guess that is the temporary fix as the client software might me corrupted and i need to reinstall it. Thanks for u time and patience to answer the question.

[madhukara_shenoy]

Hi,

Sorry, I may not be very clear enough in last reply.

I meant, ORA_NLS33 need not point to oracle client software directory in ora<sid>. And the above error (startsap) is mainly because of some issues in ORA_NLS33 in <sid>adm.

In ORA<SID> it should point to $ORACLE_HOME/ocommon/nls/admin/data and not to the client software.

Regards,

Madhukar

Message was edited by:

Madhukara Shenoy

[Former Member]

hi madhukar,

When i try setting this env var ORA_NLS33 "$ORACLE_HOME/ocommon/nls/admin/data" in ORASID, the changes doesnt takes place as i see the same old values in it and how abt editing the SIDADM env variable should that be ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data???

With Regards.

Naresh

[madhukara_shenoy]

Hello,

In <SID>adm ORA_NLS33 should be set to /oracle/client/92x_64/ocommon/nls/admin/data.

Make sure client software exsist under the above path.

As i said in previous reply, set ORA_NLS33 is <sid>adm and see the result.

Regards,

Madhukar

[Former Member]

Hi ,

In SIDADM the ORA_NLS33 is already set to /oracle/client/92x_64/ocommon/nls/admin/data, i tried changing it to /oracle/client/920_64/ocommon/nls/admin/data and tried starting sap, but it doesnt works.

Regards

Naresh

[Former Member]

Hi Naresh

I was reviewing your trans.log:

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 54 0.004694

4 ETW000 [dev trc ,00000] got NLS_LANG=<b>'AMERICAN_AMERICA.WE8DEC'</b> from environment

4 ETW00030 0.004724

4 ETW000 [dev trc ,00000] Client NLS settings: <b>AMERICAN_AMERICA.US7ASCII</b> 1412 0.006136

Again SAP note 592657:

NLS_LANG contains a value that depends on the database code page. This can be set in a running database using

SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

NLS_LANG must then be set to

NLS_LANG = AMERICAN_AMERICA.<codepage>

Also check this variable for possible typing errors.

Regards

Michael

[madhukara_shenoy]

Hello Naresh,

It is just enough if you change the envoirnment variable for <sid>adm, because all workprocesses and startsap are running from <sid>adm user.

Regards,

Madhukar

[Former Member]

Madhukar,

You mean ORA_NLS33 is not required for <ora>sid !!!

Thanks

Prince Jose

[former_member256615]

Hi Madukar,

May I know that is this your new installed system ?

Because the OCI connection failed will be occured due to following two reasons:

1. your DB client binaries permission is not ok.....

2. your OPS$ mechanism is not working properly...

Please check both and can you can send me the R3trans -x log ( trans.log in the working directory ) ?

Thanks

[Former Member]

Hello again

It looks like either the ORA_NLS33 or NLS_LANG environnement vars are not correct or not set. Do you have another system to compare them?

Regards

Michael

[Former Member]

Michael,

I have compared the NLS_33 and NLS_lang on both systems they show the same.

[Former Member]

your DB is not starting. /usr/sap/SBD/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

could you please paste db log? (startsap_<hostname>_<system no>.log

Cheers,

-Sunil

[Former Member]

Hi Sunil,

can u tell me the dir were DB log is present.

[Former Member]

Sunil i am past the log info below.

Trace of system startup/check of SAP System SBD on Mon Oct 29 13:13:28 CDT 2007

Called command: /usr/sap/SBD/SYS/exe/run/startsap

Starting SAP Instance DVEBMGS00

-

---

SAP-R/3-Startup Program Rel 640 V1.8 (2003/04/24)

-

---

Starting at 2007/10/29 13:13:28

Startup Profile: "/usr/sap/SBD/SYS/profile/START_DVEBMGS00_maltr35"

Execute Pre-Startup Commands

-

---

(4546784) Local: /usr/sap/SBD/SYS/exe/run/sapmscsa -n pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_maltr35

/usr/sap/SBD/SYS/exe/run/sapmscsa: SCSA is attached and useable.

/usr/sap/SBD/SYS/exe/run/sapmscsa: finished.

(4546784) Local: rm -f ms.sapSBD_DVEBMGS00

(4546784) Local: ln -s -f /usr/sap/SBD/SYS/exe/run/msg_server ms.sapSBD_DVEBMGS00

(4546784) Local: rm -f dw.sapSBD_DVEBMGS00

(4546784) Local: ln -s -f /usr/sap/SBD/SYS/exe/run/disp+work dw.sapSBD_DVEBMGS00

(4546784) Local: rm -f co.sapSBD_DVEBMGS00

(4546784) Local: ln -s -f /usr/sap/SBD/SYS/exe/run/rslgcoll co.sapSBD_DVEBMGS00

(4546784) Local: rm -f se.sapSBD_DVEBMGS00

(4546784) Local: ln -s -f /usr/sap/SBD/SYS/exe/run/rslgsend se.sapSBD_DVEBMGS00

Starting Programs

-

---

(4514028) Starting: local ms.sapSBD_DVEBMGS00 pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_maltr35

(4739084) Starting: local dw.sapSBD_DVEBMGS00 pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_maltr35

(4730888) Starting: local co.sapSBD_DVEBMGS00 -F pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_maltr35

(4726790) Starting: local se.sapSBD_DVEBMGS00 -F pf=/usr/sap/SBD/SYS/profile/SBD_DVEBMGS00_maltr35

(4546784) Waiting for Child Processes to terminate.

Instance on host maltr35 started

Checking Installation

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

Starting IGS

...

[1] 4448318

IGS on host maltr35 started

(4546784) **** 2007/11/15 04:53:29 Caught Signal to Stop all Programs. ****

(4546784) Parent Shutdown at 2007/11/15 04:53:31

(4546784) Stop Child Process: 4726790

(4546784) Wait 300 sec for Process 4726790 terminating...

(4546784) Stop Child Process: 4730888

(4546784) Wait 300 sec for Process 4730888 terminating...

(4546784) Stop Child Process: 4739084

(4546784) Wait 300 sec for Process 4739084 terminating...

(4546784) Stop Child Process: 4514028

(4546784) Wait 300 sec for Process 4514028 terminating...

Execute Post-Shutdown Commands

-

---

(4546784) Exiting with Return-Code 0. (Ok)

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol on host maltr35 started

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol on host maltr35 started

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

Database SBD must be started first

Checking SBD Database

-

---

ABAP Database is not available via R3trans

Checking SBD Database

-

---

Starting SAP-Collector Daemon

-

---

saposcol already running

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

DB startup failed

[Former Member]

that will be in /home/sbdadm ,

Check whether you can start DB using brtools or sqlplus ? Is it a new installation or was something changed lately ?

Thanks

Prince

[Former Member]

I am able to start DB using BRTOOLS and SQLPLUS. when i try to start sap using STARTSAP R3 it says that DB needs to be started first. and when i check the instance status it shows it is UP.

[Former Member]

Hi Naresh

Can you please do an <b>R3trans -d</b> as sidadm while the db is started and the listener running. The command ist just trying to connec to the database. Example:

myhost:sidadm 24> R3trans -d
This is R3trans version 6.14 (release 700 - 28.11.06 - 18:05:00).
R3trans finished (0000).

You will probably get a finished (0012). This command writes a logfile called trans.log. You need to check for an error in there, if you cannot solve that error yourself, please post it here.

Best regards

Michael

[Former Member]

maltr35:sbdadm 3> vi trans.log

"trans.log" 93 lines, 9081 characters

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

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

4 ETW000

4 ETW000 date&time : 15.11.2007 - 07:35:44

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 Nov 15 07:35:44 2007

41 0.000041

4 ETW000 [dev trc ,00000] db_con_init called

11 0.000052

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

37 0.000089

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SBD/SYS/exe/r

un/dboraslib.o' ...

4 ETW000

36 0.000125

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SBD/SYS/exe/

run/dboraslib.o), hdl 0

4 ETW000

3740 0.003865

4 ETW000 [dev trc ,00000] Library '/usr/sap/SBD/SYS/exe/run/dborasli

b.o' loaded

4 ETW000

18 0.003883

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /

usr/sap/SBD/SYS/exe/run/dboraslib.o

4 ETW000

33 0.003916

4 ETW000 [dev trc ,00000] Version of '/usr/sap/SBD/SYS/exe/run/dbora

slib.o' is "640.00", patchlevel (0.142)

4 ETW000

216 0.004132

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library

/usr/sap/SBD/SYS/exe/run/dboraslib.o

4 ETW000

20 0.004152

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library

/usr/sap/SBD/SYS/exe/run/dboraslib.o

4 ETW000

36 0.004188

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

26 0.004214

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state =

DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_o

pt = 255, occ = NO

4 ETW000

24 0.004238

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

24 0.004262

4 ETW000 [dev trc ,00000] find_con_by_name found the following conne

ction for reuse:

4 ETW000

19 0.004281

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state =

DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_op

t = 255, occ = NO

4 ETW000

21 0.004302

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/SBD/920_64 from en

vironment

4 ETW000

338 0.004640

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0)

54 0.004694

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' fro

m environment

4 ETW000

30 0.004724

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7A

SCII 1412 0.006136

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSBD's passwor

d 28 0.006164

4 ETW000 [dev trc ,00000] Connecting as /@SBD on connection 0 (nls_h

dl 0) ... (dbsl 640 110706)

4 ETW000

38 0.006202

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalC

harSet C EnvHp ErrHp ErrHpBatch

4 ETW000

40 0.006242

4 ETW000 [dev trc ,00000] 0 US7ASCII

1 1107baa80 1107c2540 1107c1df8

4 ETW000

32 0.006274

4 ETW000 [dev trc ,00000] Allocating service context handle for con_

hdl=0 13 0.006287

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

32 0.006319

4 ETW000 [dev trc ,00000] Attaching to DB Server SBD (con_hdl=0,svch

p=1107c3b78,svrhp=1107c3d98)

4 ETW000

65 0.006384

4 ETW000 [dev trc ,00000] Assigning server context 1107c3d98 to serv

ice context 1107c3b78

4 ETW000

36239 0.042623

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

26 0.042649

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110

7c3b78,srvhp=1107c3d98,usrhp=1107cd8d0)

4 ETW000

37 0.042686

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' fa

iled: rc = 12705

4 ETW000

1609 0.044295

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1107

c3d98)

4 ETW000

40 0.044335

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=

1107c3b78,srvhp=1107c3d98)

4 ETW000

20 0.044355

4 ETW000 [dev trc ,00000] Deallocating server context handle 1107c3d

98 178 0.044533

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

'12705'

4 ETW000

29 0.044562

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

31 0.044593

4 ETW000 [dev trc ,00000] Connecting as SAPSBD/<pwd>@SBD on connecti

on 0 (nls_hdl 0) ... (dbsl 640 110706)

4 ETW000

23 0.044616

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalC

harSet C EnvHp ErrHp ErrHpBatch

4 ETW000

22 0.044638

4 ETW000 [dev trc ,00000] 0 US7ASCII

1 1107baa80 1107c2540 1107c1df8

4 ETW000

21 0.044659

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

12 0.044671

4 ETW000 [dev trc ,00000] Attaching to DB Server SBD (con_hdl=0,svch

p=1107c3b78,svrhp=1107c3d98)

4 ETW000

27 0.044698

4 ETW000 [dev trc ,00000] Assigning server context 1107c3d98 to serv

ice context 1107c3b78

4 ETW000

26006 0.070704

4 ETW000 [dev trc ,00000] Assigning username to user session 1107cd8

d0 15 0.070719

4 ETW000 [dev trc ,00000] Assigning password to user session 1107cd8

d0 15 0.070734

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110

7c3b78,srvhp=1107c3d98,usrhp=1107cd8d0)

4 ETW000

22 0.070756

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' fa

iled: rc = 12705

4 ETW000

18348 0.089104

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=1107

c3d98)

4 ETW000

22 0.089126

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=

1107c3b78,srvhp=1107c3d98)

4 ETW000

19 0.089145

4 ETW000 [dev trc ,00000] Deallocating server context handle 1107c3d

98 170 0.089315

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

'12705'

4 ETW000

28 0.089343

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CO

N [dblink#1 @ 419]

4 ETW000

55 0.089398

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown

NLS parameter value specified [dblink#1 @ 419]

4 ETW000

19 0.089417

2EETW169 no connect possible: "DBMS = ORACLE ---

dbs_ora_tnsname = 'SBD'"

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

[madhukara_shenoy]

Hello Naresh,

The issue could be because of the wrong environment variable or improper oracle client settings.

I guess you have CI and DB on same host. In that case, try the following (I believe you are using 640 kernel)

1. Set ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

Then try the sapstart? What is the result? If it fails

2. Set ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

What is the result? If the first option succeeds then it is well and good and if the first fails and second succeeds that mean you have to install the client software correctly and then change the ORA_NLS33 accordingly.

Anyways SAP note 592657 will give detailed information on how to fix ora-12705 error.

Regards,

Madhukar

[Former Member]

do i need to change the enviroment variables on both SAPSID and ORASID???

[Former Member]

Yes you have to

Thanks

Prince Jose