Error in startsap on HP-UX

[Former Member]

Hi All,

I installed SAP 2004 Dialoge instance on HP-UX. After Installing, when I try to start SAP, I am getting the following error:

#>su c11adm

$>cd /sapmnt/C11/exe

$>./startsap

$>SAPSYSTEMNAME not set

$>export SAPSYSTEMNAME=C11

$>./startsap

<b>Checking db Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

./startsap: /usr/sap/C11/SYS/exe/run/saposcol: Execute permissioin denied.

Start of saposcol failed.

ABAP Databse db must be started on remote server </b>

It is very urget, please help me out.

Thanks in advance,

Nagarjuna.

[Former Member]

I got the Following error in /usr/sap/C11/D11/work/dev_w0:

+++++++++++++++++++++

sysno 11

M sid C11

M systemid 273 (HP/9000 (PA-RISC) with HP-UX)

M relno 6400

M patchlevel 0

M patchno 58

M intno 20020600

M make: single threaded, ASCII, 64 bit

M pid 6930

M

M

M Tue Oct 24 08:13:52 2006

M ***LOG Q01=> tskh_init, WPStart (Workproc 0 1 6930) [thxxhead.c 1131]

M calling db_connect ...

C Got ORACLE_HOME=/oracle/D11/920_64 from environment

C Client NLS settings: AMERICAN_AMERICA.US7ASCII

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

C Connecting as /@D11 on connection 0 (nls_hdl 0) ...

C Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

C 0 1 80000001023a8e00 80000001023b0658 80000001023b0068

C Attaching to DB Server D11 (con_hdl=0,svchp=80000001023aff98,svrhp=80000001023b0ce8)

C Starting user session (con_hdl=0,svchp=80000001023aff98,srvhp=80000001023b0ce8,usrhp=80000001023ba708)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

[dboci.c 4176]

C Detaching from DB Server (con_hdl=0,svchp=80000001023aff98,srvhp=80000001023b0ce8)

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

[dbsloci.c 9891]

C Try to connect with default password

C Connecting as SAPD11/<pwd>@D11 on connection 0 (nls_hdl 0) ...

C Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

C 0 1 80000001023a8e00 80000001023b0658 80000001023b0068

C Attaching to DB Server D11 (con_hdl=0,svchp=80000001023aff98,svrhp=80000001023b0ce8)

C Starting user session (con_hdl=0,svchp=80000001023aff98,srvhp=80000001023b0ce8,usrhp=80000001023ba708)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4176]

dev_w0" 82 lines, 3623 characters

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4176]

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

[dbsloci.c 9891]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#2 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#2 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

++++++++++++

Thanks,

Nagarjuna.

Message was edited by: Maha Nagarjuna Angalakuditi

[Former Member]

Hi Nagarjuna,

The log shows two SQL errors which are probably related. SQL 12705 indicates an invalid or unknown NLS parameter. This is occuring when it is attempting to retreive logon settings. Then, SQL 1017 occurs which is an invalid logon attempt (username/password). I imagine this is because the retreival of the logon settings was bad due to the bad NLS. Check your ORA_NLS33 parameter.

Best Regards,

Matt

[Former Member]

Here is a tip for you.

R3trans -d command writes a file called trans.log

This log file will assist you in why SAP cannot connect to the database.

The log file will be written to the current directory.

[Former Member]

Hi,

My <b>ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data.</b>

<b>R3trans -d output is:</b>

This is ./R3trans version 6.09 (release 640 - 13.01.05 - 10:38:00).

2EETW169 no connect possible: "environment variable DIR_LIBRARY is not set."

./R3trans finished (0012).

bash-3.00# vi trans.log

"trans.log" 90 lines, 8884 characters

4 ETW000 ./R3trans version 6.09 (release 640 - 13.01.05 - 10:38:00).

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

4 ETW000

4 ETW000 date&time : 25.10.2006 - 01:37:02

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 Oct 25 01:37:02 2006 348 0.000348

4 ETW000 [dev trc ,00000] db_con_init called 17 0.000365

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

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/C11/SYS/exe/run/dboraslib.sl' ...

4 ETW000 42 0.000564

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/C11/SYS/exe/run/dboraslib.sl), hdl 0

4 ETW000 47938 0.048502

4 ETW000 [dev trc ,00000] Library '/usr/sap/C11/SYS/exe/run/dboraslib.sl' loaded

4 ETW000 25 0.048527

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

4 ETW000 44 0.048571

4 ETW000 [dev trc ,00000] Version of '/usr/sap/C11/SYS/exe/run/dboraslib.sl' is "640.00", patchlevel (0.55)

4 ETW000 220 0.048791

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

4 ETW000 29 0.048820

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

4 ETW000 42 0.048862

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

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 0

00, con_max = 255, con_opt = 255, occ = NO

4 ETW000 29 0.048919

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

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

4 ETW000 22 0.049069

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 00

0, con_max = 255, con_opt = 255, occ = NO

4 ETW000 25 0.049094

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

4 ETW000 398 0.049492

4 ETW000 [dev trc ,00000] -->oci_init1 25 0.049517

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 11629 0.061171

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPD11's password 38 0.061209

4 ETW000 [dev trc ,00000] Connecting as /@D11 on connection 0 (nls_hdl 0) ...

4 ETW000 32 0.061241

4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpB

atch

4 ETW000 33 0.061274

4 ETW000 [dev trc ,00000] 0 1 80000001007bd7d8 80000001007

c4ff0 80000001007c4a00

4 ETW000 25 0.061299

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 62 0.061361

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

4 ETW000 [dev trc ,00000] Attaching to DB Server D11 (con_hdl=0,svchp=80000001007c4930,svrhp=80000001007c5640)

4 ETW000 52 0.061439

4 ETW000 [dev trc ,00000] Assigning server context 80000001007c5640 to service context 80000001007c4930

4 ETW000 56182 0.117621

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

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=80000001007c4930,srvhp=80000001007c5640,usrhp=8000000

1007cf018)

4 ETW000 29 0.117723

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 8281 0.126004

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

4 ETW000 24 0.126028

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=80000001007c4930,srvhp=80000001007c5640)

4 ETW000 23 0.126051

4 ETW000 [dev trc ,00000] Deallocating server context handle 80000001007c5640

4 ETW000 631 0.126682

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

4 ETW000 81 0.126763

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

4 ETW000 [dev trc ,00000] Connecting as SAPD11/<pwd>@D11 on connection 0 (nls_hdl 0) ...

4 ETW000 32 0.126831

4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpB

atch

4 ETW000 25 0.126856

4 ETW000 [dev trc ,00000] 0 1 80000001007bd7d8 80000001007

c4ff0 80000001007c4a00

4 ETW000 25 0.126881

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

4 ETW000 [dev trc ,00000] Attaching to DB Server D11 (con_hdl=0,svchp=80000001007c4930,svrhp=80000001007c5640)

4 ETW000 34 0.126930

4 ETW000 [dev trc ,00000] Assigning server context 80000001007c5640 to service context 80000001007c4930

4 ETW000 40692 0.167622

4 ETW000 [dev trc ,00000] Assigning username to user session 80000001007cf018

4 ETW000 27 0.167649

4 ETW000 [dev trc ,00000] Assigning password to user session 80000001007cf018

4 ETW000 46 0.167695

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=80000001007c4930,srvhp=80000001007c5640,usrhp=8000000

1007cf018)

4 ETW000 25 0.167720

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 5946 0.173666

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

4 ETW000 79 0.173745

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]

4 ETW000 197 0.173942

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]

4 ETW000 25 0.173967

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

Thanks,

Nagarjuna.

[Former Member]

Hi Nagarjuna,

I do not know if you have your NLS setting correct, you need to follow SAP Note 180430 to determine it for yourself.

This forum is not a substitue for consulting or SAP support. See the .

Best Regards,

Matt

[Former Member]

Hi,

Thanks for your help.

I'll try to solve it.

Thanks,

Nagarjuna.

[Former Member]

Try and set your DIR_LIBRARY as well... the top of the log shows that this variable is not set...

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

[Former Member]

Hi All,

I was able to solve the starting problem with the Dialouge Instance after reinstalling it.

I am unable to connect using SAPGUI to the dialouge Instance.

I got the following messages when I start SAP dialouge instance:

<b>#su – c11adm

$ csh

% startsap

Checking D11 Database

-

---

ABAP Database is not available via R3trans

Checking D11 Database

-

---

Starting SAP-Collector Daemon

-

---

10:21:32 23.10.2006 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.87 640 - hpxOscol 07/2003

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• Starting collector (create new process)

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

could not move /usr/sap/tmp/dev_coll to /usr/sap/tmp/dev_coll.old

saposcol on host <myhost> started

Starting SAP Instance D11

-

---

Startup-Log is written to /home/c11adm/startsap_D11.log

Instance on host <myhost> started

IGS on host <myhost> started</b>

Thanks in Advance,

Nagarjuna.

Message was edited by: Maha Nagarjuna Angalakuditi

[Former Member]

What Databse are you using?

Is it running?

Log onto via sql*plus (or similar) and check the status of the database!

[Former Member]

I am using Oracle 9.2. And the Database is on the Central Instance which is on a AIX machine. I am able to login to Central Instance on AIX using SAPGUI.

I installed Oracle Client 920_64 while installing SAP Dialogue instance on HP-UX.

Thanks,

Nagarjuna.