PRD Down -Unable to start DB from startsap command

[former_member319296]

We accidently changed the permissions on /oracle/SID/ folder and

after that when we do "startsap" we are getting following error.

GPILPRD:gpradm 66> startsap

Checking GPR Database

-

---

Database is not available via R3trans

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

Trying to start GPR database ...

Log file: /home/gpradm/startdb.log

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

DB startup failed

The "R3trans -d" output trans.log with the message and

permissions of $ORACLE_HOME directory.

Furthermore , we are able to start the database by logging into SIDADM

user and database is in open state. However when we do startsap from

sidadm user we are facing mentioned issue.

Regards

[Former Member]

You can start Oracle using sqlplus manually ? is linstener started ?

[former_member319296]

Yes oracle is getting mounted and in open mode through sqlplus . The listener is also up. The issues seems to be with permissions of file and I am not sure which permissions I have to change.

Regards

[former_member266290]

Hi

Stop Oracle database and

Run the $ORACLE_HOME/root.sh script.

Now again try to start the database.

Regards

[former_member319296]

Note note 583861 , resolved the issue.

Regards

[former_member524429]

Hi,

Its looking like the Oracle executables under $ORACLE_HOME/bin location are disturbed with insufficient permissions.

You can refer this [SAP Note 583861 - UNIX: Errors due to Oracle executable |https://service.sap.com/sap/support/notes/583861]and change the permissions accordingly.

Ooops.. You have already seen that.

I was late....

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Apr 9, 2011 3:29 PM

[former_member319296]

Output of trans.log---

4 ETW000 R3trans version 6.14 (release 701 - 23.07.10 - 09:23:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 08.04.2011 - 19:02:48

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 Apr 8 19:02:48 2011 449 0.000449

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

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

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

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

4 ETW000 35020 0.035547

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

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

4 ETW000 95 0.035750

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

4 ETW000 357 0.036107

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

4 ETW000 36 0.036143

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

4 ETW000 59 0.036202

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

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 48 0.036281

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

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

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 44 0.036395

4 ETW000 [dev trc ,00000] -->oci_init1 522 0.036917

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.4.0', (dbsl 701 140910) 125 0.037042

4 ETW000 [dev trc ,00000] Default connection: tnsname ='GPR' 21 0.037063

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 21 0.037084

4 ETW000 [dev trc ,00000] application info callback registered 18 0.037102

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

4 ETW000 39515 0.076617

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrHp=0x60000000010a2070)

4 ETW000 102 0.076719

4 ETW000 [dev trc ,00000] OCIHandleAlloc(OCI_HTYPE_ERROR, con_hdl=0, ErrBt=0x60000000010b2c28)

4 ETW000 33 0.076752

4 ETW000 [dev trc ,00000] NLS env. settings: lang=0041004D00450052004900430041004E00000000000000000000000000000000

4 ETW000 238 0.076990

4 ETW000 [dev trc ,00000] terr=0041004D00450052004900430041000000000000000000000000000000000000

4 ETW000 39 0.077029

4 ETW000 [dev trc ,00000] char=0055005400460031003600000000000000000000000000000000000000000000

4 ETW000 38 0.077067

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 20 0.077087

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 31 0.077118

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 19 0.077137

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

4 ETW000 [dev trc ,00000] Connecting as /@GPR on connection 0 (nls_hdl 0) ... (dbsl 701 140910)

4 ETW000 31 0.077204

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

4 ETW000 45 0.077249

4 ETW000 [dev trc ,00000] 0 UTF8 0x600000000109a5c0 0x60000000010a2070 0x60000000010b2c28

4 ETW000 32 0.077281

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

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

4 ETW000 [dev trc ,00000] Attaching to DB Server GPR (con_hdl=0,svchp=0x60000000010b2b58,srvhp=0x60000000010b6a08)

4 ETW000 35 0.077393

4 ETW000 [dev trc ,00000] Assigning server context 0x60000000010b6a08 to service context 0x60000000010b2b58

4 ETW000 57395 0.134788

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

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x60000000010b2b58, srvhp=0x60000000010b6a08, usrhp=0x60000000011454d0)

4 ETW000 67 0.134971

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

4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034: 241 0.141256

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 28 0.141284

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

4 ETW000 HPUX-ia64 Error: 13: Permissi

4 ETW000 [dev trc ,00000] on denied

4 ETW000 70 0.141354

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

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

4 ETW000 33 0.141409

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x60000000010b6a08 from con_hdl=0

4 ETW000 993 0.142402

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

4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1034 22 0.142489

4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1034) 85 0.142574

4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1034 125 0.142699

4 ETW000 [dev trc ,00000] ORA-01034: ORACLE not available 26 0.142725

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

4 ETW000 HPUX-ia64 Error: 13: Permissi

4 ETW000 [dev trc ,00000] on denied

4 ETW000 47 0.142772

4 ETW000 [dev trc ,00000] SAPUSER or connect error 99=DBSL_ERR_DB, oerr=1034. 46 0.142818

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 1034 performing CON [dblink#4 @ 433] 240 0.143058

4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-01034: ORACLE not available 27 0.143085

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

4 ETW000 HPUX-ia64 Error: 13: Permission denied [dblink#4 @ 433]

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

[former_member319296]

Output of File permissions on ORACLE_HOME---

GPILPRD:gpradm 65> ls -l

total 150

drwxrwxr-x 5 oragpr dba 1024 Oct 10 22:44 OPatch

drwxrwxr-x 7 oragpr dba 96 Oct 10 2010 assistants

drwxrwxr-x 2 oragpr dba 8192 Oct 10 23:07 bin

drwxr-x--- 7 oragpr dba 1024 Oct 10 22:44 ccr

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 cdata

drwxr-x--- 4 oragpr dba 1024 Oct 10 22:52 cfgtoollogs

drwxrwxr-x 4 oragpr dba 96 Oct 10 2010 clone

drwxr-x--- 2 oragpr dba 96 Oct 10 2010 config

drwxrwxr-x 6 oragpr dba 96 Oct 10 2010 crs

drwxrwxr-x 7 oragpr dba 96 Oct 10 2010 css

drwxrwxr-x 10 oragpr dba 1024 Oct 10 2010 ctx

drwxrwxr-x 2 oragpr dba 1024 Apr 8 19:43 dbs

drwxrwxr-x 3 oragpr dba 96 Oct 10 2010 demo

drwxrwxr-x 3 oragpr dba 96 Oct 10 2010 diagnostics

drwxrwxr-x 5 oragpr dba 96 Oct 10 2010 has

drwxrwxr-x 7 oragpr dba 96 Oct 10 2010 hs

drwxrwxr-x 5 oragpr dba 1024 Oct 10 22:51 install

-rwxrwxr-x 1 oragpr dba 38 Oct 10 22:43 install.platform

drwxrwxr-x 14 oragpr dba 1024 Oct 10 22:51 inventory

drwxrwxr-x 7 oragpr dba 96 Oct 10 2010 javavm

drwxrwxr-x 4 oragpr dba 96 Oct 10 2010 jdbc

drwxrwxr-x 11 oragpr dba 1024 Oct 10 2010 jdk

drwxrwxr-x 2 oragpr dba 2048 Oct 10 22:44 jlib

drwxrwxr-x 3 oragpr dba 96 Oct 10 2010 jre

drwxrwxr-x 13 oragpr dba 1024 Oct 10 2010 ldap

drwxrwxr-x 4 oragpr dba 6144 Oct 10 22:51 lib

drwxrwxr-x 2 oragpr dba 4096 Oct 10 22:51 lib32

drwxrwxr-x 3 oragpr dba 96 Oct 16 16:11 log

drwxrwxr-x 2 oragpr dba 96 Oct 9 2010 lost+found

drwxrwxr-x 6 oragpr dba 96 Oct 10 2010 md

drwxrwxr-x 2 oragpr dba 96 Oct 10 2010 mesg

drwxrwxr-x 7 oragpr dba 96 Oct 10 2010 mgw

drwxrwxr-x 13 oragpr dba 1024 Oct 10 2010 network

drwxrwxr-x 6 oragpr dba 96 Oct 10 2010 nls

drwxrwxr-x 15 oragpr dba 1024 Oct 10 2010 oc4j

drwxrwxr-x 5 oragpr dba 96 Oct 10 2010 olap

drwxr-x--- 7 oragpr dba 96 Oct 10 2010 opmn

-rw-rr 1 oragpr dba 50 Oct 10 2010 oraInst.loc

drwxrwxr-x 4 oragpr dba 96 Oct 10 2010 oracore

drwxrwxr-x 8 oragpr dba 1024 Oct 10 2010 ord

drwxrwxr-x 7 oragpr dba 1024 Oct 10 22:44 oui

drwxrwxr-x 4 oragpr dba 96 Oct 10 2010 owm

drwxr-x--- 6 oragpr dba 96 Oct 10 2010 perl

drwxr-x--- 7 oragpr dba 1024 Oct 10 2010 plsql

drwxr-x--- 9 oragpr dba 1024 Oct 10 2010 precomp

drwxr-x--- 7 oragpr dba 96 Oct 10 2010 racg

drwxr-x--- 15 oragpr dba 1024 Oct 10 22:45 rdbms

drwxr-x--- 4 oragpr dba 1024 Oct 10 2010 relnotes

-rwxrwxr-x 1 oragpr dba 11393 Oct 10 22:51 root.sh

-rwxr-xr-x 1 oragpr dba 0 Jun 7 2005 root.sh.old

-rwxr-xr-x 1 oragpr dba 9437 Oct 10 2010 root.sh.old.1

-rwxr-xr-x 1 oragpr dba 9437 Oct 10 2010 root.sh.old.2

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 slax

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 sqlj

drwxr-x--- 9 oragpr dba 1024 Oct 10 2010 sqlplus

drwxr-x--- 13 oragpr dba 1024 Oct 10 2010 srvm

drwxr-x--- 14 oragpr dba 1024 Oct 10 22:44 sysman

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 tg4ifmx

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 tg4ingr

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 tg4sybs

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 tg4tera

drwxr-x--- 4 oragpr dba 96 Oct 10 2010 uix

drwxr-x--- 3 oragpr dba 96 Oct 10 2010 wwg

drwxr-x--- 6 oragpr dba 1024 Oct 10 2010 xdk