Unable to start Database after the installation

[Former Member]

Hi,

Recently i build the SAP Netweaver dual stack server, After the installation i'm unable to start the database. listener is running but when i execute startsap DB command i get the following error message.

Trying to start ERD database ...

Log file: /home/erdadm/startdb.log

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

DB startup failed

and here is the trans.log file output.

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 25.04.2013 - 14:21:26

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000  [dev trc     ,00000]  Thu Apr 25 14:21:26 2013                             116  0.000116

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

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

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

4 ETW000                                                                              31  0.000194

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

4 ETW000                                                                            9261  0.009455

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

4 ETW000                                                                              23  0.009478

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

4 ETW000                                                                              22  0.009500

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

4 ETW000                                                                              64  0.009564

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

4 ETW000                                                                              20  0.009584

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

4 ETW000                                                                              31  0.009615

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

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

4 ETW000                                                                              26  0.009659

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

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

4 ETW000                                                                              21  0.009703

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

4 ETW000                                                                              23  0.009726

4 ETW000  [dev trc     ,00000]  Oracle Client Version: '10.2.0.2.0'                  267  0.009993

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

4 ETW000  [dev trc     ,00000]  Client NLS settings: AMERICAN_AMERICA.UTF8          2479  0.012490

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

4 ETW000  [dev trc     ,00000]  Connecting as /@ERD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              22  0.012538

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                              29  0.012567

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0x952fe70  0x95354dc  0x9534d64

4 ETW000                                                                              21  0.012588

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

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

4 ETW000  [dev trc     ,00000]  Attaching to DB Server ERD (con_hdl=0,svchp=0x9534cf0,srvhp=0x95464d4)

4 ETW000  [dev trc     ,00000]  Attaching to DB Server ERD (con_hdl=0,svchp=0x9534cf0,srvhp=0x95464d4)

4 ETW000                                                                              48  0.012701

4 ETW000  [dev trc     ,00000]  Assigning server context 0x95464d4 to service context 0x9534cf0

4 ETW000                                                                           33653  0.046354

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

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0x9534cf0,srvhp=0x95464d4,usrhp=0x957112c)

4 ETW000                                                                              33  0.046418

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

4 ETW000                                                                            3572  0.049990

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

4 ETW000                                                                              21  0.050011

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

4 ETW000                                                                              19  0.050030

4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0x95464d4         147  0.050177

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

4 ETW000                                                                              41  0.050218

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1034         21  0.050239

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

4 ETW000  [dev trc     ,00000]  Connecting as SAPSR3/<pwd>@ERD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000                                                                              26  0.050314

4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

4 ETW000                                                                              23  0.050337

4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0x952fe70  0x95354dc  0x9534d64

4 ETW000                                                                              21  0.050358

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

4 ETW000  [dev trc     ,00000]  Attaching to DB Server ERD (con_hdl=0,svchp=0x9534cf0,srvhp=0x95464d4)

4 ETW000                                                                              27  0.050398

4 ETW000  [dev trc     ,00000]  Assigning server context 0x95464d4 to service context 0x9534cf0

4 ETW000                                                                           20031  0.070429

4 ETW000  [dev trc     ,00000]  Assigning username to user session 0x957112c          19  0.070448

4 ETW000  [dev trc     ,00000]  Assigning password to user session 0x957112c          27  0.070475

4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0x9534cf0,srvhp=0x95464d4,usrhp=0x957112c)

4 ETW000                                                                              24  0.070499

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

4 ETW000                                                                            3104  0.073603

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

4 ETW000                                                                              20  0.073623

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

4 ETW000                                                                              19  0.073642

4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0x95464d4          77  0.073719

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

4 ETW000                                                                              53  0.073772

4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1034         12  0.073784

4 ETW000  [dblink      ,00431]  ***LOG BY2=>sql error 1034   performing CON [dblink#3 @ 431]

4 ETW000                                                                             100  0.073884

4 ETW000  [dblink      ,00431]  ***LOG BY0=>ORA-01034: ORACLE not available           17  0.073901

4 ETW000                        ORA-27121: unable to determine size of shared memory segment

4 ETW000                        Linux Error: 13: Permission denied [dblink#3 @ 431]

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

Please help me here.

Many thanks in Advance.

Khan

[Former Member]

Guy's I'm glad the problem is resolved and many thanks to all of you for providing technical tips.

The resolution was i changed the password for user SAPSR3 using brconnect tool and here is command i used.

brconnect -u system/<syst_pwd> -f chpass -o sap<sid> -p <new_sap_pwd>

where sap<sid> = sapsr3 and <new_sap_pwd> = sap (the password must be sap otherwise database won't start)

Take Care and once again many thanks to all.

[Former Member]

Hi Khan,

  It seems that permissions error in oracle client.

Permission should  be like the attached picture.

Secondly check whether Oracle is up and running or not.

Thanks and Regards,

Vimal

[Former Member]

Thanks Maria for looking into it.

I'm sorry i don't see the picture you are referring to.

2nd ly i can Start oracle under erdadm session using salplus / as sysdba but won't run when i execute startsap DB command, Also i can login as salplus sapsr3/(pwd>@ERD to verify the password and account status.

Please advise.

Thanks

Khan

[Former Member]

Hi,

login with sidadm, hit which startsap

check whether it is taking you to run directory which further takes to path of exe.

If it gives you correct path then go to /home/sidadm and check the hidden file with ls -altr , do open file .dbenv_hostname.sh and .dbenv_hostnme.csh and same ways for the .sapenv_hostname.sh/.csh

Compare these files with the system which are running in your landscape.

Regards,

SJ

[Former Member]

Check /home/erdadm/startdb.log log file or attach it here.

[Former Member]

Many Thanks for your reply. Here is the startdb.log file output.

------------------------------ Thu Apr 25 15:06:41 EDT 2013
LOGFILE FOR STARTING ORACLE

Trying to start ERD database ...

------------------------------ Thu Apr 25 15:06:41 EDT 2013
checking required environment variables

ORACLE_HOME  is >/oracle/ERD/102_32<
ORACLE_SID   is >ERD<

------------------------------ Thu Apr 25 15:06:41 EDT 2013
check initora

------------------------------ Thu Apr 25 15:06:41 EDT 2013
check initora

------------------------------ Thu Apr 25 15:06:41 EDT 2013
checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 25-APR-2013 15:06:41

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

Used parameter files:
/usr/sap/ERD/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 = ERD) (PORT = 1527))) (CONNECT_DATA = (SID = ERD) (GLOBAL_NAME = ERD.WORLD)))
OK (0 msec)
tnsping: V2 connect to ERD

------------------------------ Thu Apr 25 15:06:41 EDT 2013
Connect to the database to check the database state:

R3trans: connect check finished with return code: 12
Database not available

------------------------------ Thu Apr 25 15:06:41 EDT 2013
Shutdown database

First trying to shutdown the database - May be,
the database is in the nomount or mount state

------------------------------ Thu Apr 25 15:06:58 EDT 2013

starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 25 15:06:58 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.
ORACLE instance started.

Total System Global Area  599785472 bytes
Fixed Size                  1220796 bytes
Variable Size             310382404 bytes
Database Buffers          285212672 bytes
Redo Buffers                2969600 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options

------------------------------ Thu Apr 25 15:07:04 EDT 2013
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/ERD/SYS/exe/run/startdb: Terminating with error code 12

Thanks

Khan

[Former Member]

Are you ran the root.sh script after oracle installation? Please provide output of

> ls -l $ORACLE_HOME/bin/oracle

command.

[Former Member]

yup i did run the root.sh script after oracle installation and here is the result of the command.

-rwxrwxrwx 1 oraerd dba 86177203 2022-04-21 09:45 /oracle/ERD/102_32/bin/oracle

[Former Member]

You need to perform steps provided in Solution for Note 583861 - UNIX: Errors due to Oracle executable.