Not able to start db

[Former Member]

Hi,

After the new installation, of ECC6.0, When i start db i run with the below error

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

Checked in the Google, couldn't find the relevant information.

Please help.

Thanks

[markus_doehr2 · Accepted solution]

Is this Oracle?

Markus

[Former Member · Accepted solution]

Yes, Oracle 10.2.0.2

sorry i have posted in SAPon unix.

[markus_doehr2 · Accepted solution]

login as ora<SID>

try then

sqlplus / as sysdba
shutdown immediate
startup

any error message coming?

Markus

[Former Member · Accepted solution]

This is the message i get below

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

SQL> startup

ORA-10997: another startup/shutdown operation of this instance inprogress

ORA-09968: unable to lock file

HPUX-ia64 Error: 13: Permission denied

Additional information: 8534

SQL>

Thanks.

[markus_doehr2 · Accepted solution]

You have permission problems.

I assume this is the instance you installed as you were doing in the other message here right - second instance on that machine?

If yes, then please open an OSS call and let the support have a look on the system. It´s impossible to help without having access to the machine and knowing all things like environment variables and such.

Markus

[Former Member · Accepted solution]

Hi,

I have checked the permission , permission probems have been resolved. But still getting the startdb error.

Thanks.

[sebastian_sebaraj · Accepted solution]

Krishna

If you have only one Oracle Instance is running do the following steps.

Do the following steps as root

check any process running with name ora by typing

ps -ef | grep ora

kill -9 process_name

try to start again, if you still get any problem, may be to do with Semaphores

Follow the steps to remove semaphore

Removing a semaphore set for Oracle

root> ipcs -sb|grep oracle

s 67 0x00000000 ra-r--- oracle dba 400

s 223 0x00000000 ra-r--- oracle dba 400

s 334 0x00000000 ra-r--- oracle dba 300

Now, you can remove the semaphores from the list. In this example, we assume that set 223 is the one for the crippled database.

root> ipcrm -s 223

hope it helps.

If you killed all the oracle process using kill -9 and cleaned up the semaphore you should be good to restart the Database.

Do not use startsap script.

type the following command and update this message with what you get.

make sure all the processes are cleanup.

$sqlplus "/as sysdba"

sqlplus>startup

If Oracle Startsup without error then you can shutdown

sqlplus>shutdown imemdiate;

and then user startsap script

good luck

[Former Member · Accepted solution]

Thanks for the reply, will let you know once i do the same.

Thanks

[Former Member · Accepted solution]

Hi,

It is not recommended to kill oracle processes. Our R3trans -d will fail as you have tried to shutdown the database once it OPS$ user wont be able to connect to the DB in that state, try the following :

1) Logout from the SQL prompt and the current session

2) Login again

3) shutdown abort

If you try to fire the sql query from the same session where you have issued shutdown immediate and it has failed the shutdown abort will also fail, so you have to logout from the currrent session and then relogin via telnet or ssh whatever you are using and then try shutdown abort.

[Former Member · Accepted solution]

Try

sqlplus / as sysdba

shutdown immediate

startup

thanks

[Former Member · Accepted solution]

Thanks Debojyoti, your response really helped.

[former_member204746]

try this:

sqlplus / as sysdba

shutdown abort;

startup

try starting SAP again., if it fails:

please provide contents of startdb.log

also, try this command:

R3trans -d

and provide resulting trans.log

[Former Member]

SQL> shutdown abort;

ORA-01031: insufficient privileges

SQL> startup

ORA-01081: error

When i startsap i get the below error

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

DB startup failed

When i run R3trans -d i get the below error

This is R3trans version 6.14 (release 700)

unicode enabled version

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

R3trans finished (0012).

STARTDB.log

Trying to start GRD database ...

-

---

Tue Dec 16 16:04:29 GMT 2008

checking required environment variables

ORACLE_HOME is >/oracle/GRD/102_64<

ORACLE_SID is >GRD<

-

---

Tue Dec 16 16:04:29 GMT 2008

check initora

-

---

Tue Dec 16 16:04:29 GMT 2008

checking V2 connect

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 16-DEC-2008 16:04:29

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

Used parameter files:

/usr/sap/GRD/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 = mdsvidb9) (PORT = 1529))) (CONNECT_DATA = (SID

OBAL_NAME = GRD.WORLD)))

OK (0 msec)

tnsping: V2 connect to GRD

-

---

Tue Dec 16 16:04:29 GMT 2008

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

First trying to shutdown the database - May be,

the database is in the nomount or mount state

ORA-16038: log 3 sequence# 1003 cannot be archived

ORA-19502: write error on file "", blockno (blocksize=)

ORA-00312: online log 3 thread 1: '/oracle/GRD/origlogA/log_g13m1.dbf'

ORA-00312: online log 3 thread 1: '/oracle/GRD/mirrlogA/log_g13m2.dbf'

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

startdb: Terminating with error code 12

trans.log

4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 16.12.2008 - 14:11:48

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] Tue Dec 16 14:11:48 2008 446 0.000446

4 ETW000 [dev trc ,00000] db_con_init called 30 0.000476

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

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

4 ETW000 62 0.000654

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

4 ETW000 47101 0.047755

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

4 ETW000 49 0.047804

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

4 ETW000 100 0.047904

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

4 ETW000 303 0.048207

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

4 ETW000 52 0.048259

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

4 ETW000 64 0.048323

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

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, oc

4 ETW000 170 0.048539

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

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

4 ETW000 44 0.048684

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

4 ETW000 47 0.048731

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 580 0.049311

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 4217 0.053570

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

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

4 ETW000 53 0.053704

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

4 ETW000 112 0.053816

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x60000000010739f0 0x600000000107b320 0x600000000108ba98

4 ETW000 56 0.053872

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

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

4 ETW000 [dev trc ,00000] Attaching to DB Server GRD (con_hdl=0,svchp=0x600000000108b9c8,srvhp=0x600000000108dcd8)

4 ETW000 51 0.054052

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

4 ETW000 76539 0.130591

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

4 ETW000 93 0.130684

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 29 0.130713

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

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

4 ETW000 63 0.130898

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

4 ETW000 47 0.130945

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x60000000010739f0 0x600000000107b320 0x600000000108ba98

4 ETW000 46 0.130991

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

4 ETW000 52 0.131043

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

4 ETW000 45 0.131088

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x600000000108dcd8

4 ETW000 73 0.131161

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

4 ETW000 [dev trc ,00000] Attaching to DB Server GRD (con_hdl=0,svchp=0x600000000108b9c8,srvhp=0x600000000108dcd8)

4 ETW000 49 0.131273

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

4 ETW000 61208 0.192481

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

4 ETW000 44 0.192525

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12537 28 0.192553

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

4 ETW000 438 0.192991

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12537: TNS:connection closed [dblink#5 @ 431]

4 ETW000 44 0.193035

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