Database Oracle can not startup

[Former Member]

Dear All,

Our system is Oracle 10.2.0.4 on HP-UX 11v3. ECC 6 EHP4 ready SR1.

I have a problem when want to do "startsap", the error is:

dr1adm > startsap

Checking DR1 database

-

---

Database is not available via R3trans

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

Trying to start DR1 database ...

Log file: /home/dr1adm/startdb.log

/usr/sap/DR1/SYS/exe/run/startdb: Termintating with error code 12 DB startup failed

Below is the error show in the log, and when I try to connect /as sysdba with user dr1adm:

ERROR:

ORA-09925: Unable to create audit trail file

HPUX-ia64 Error: 13: Permission denied

Additional information: 9925

ORA-01075: you are currently logged on

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

ORA-09967: unable to create or open lock file

HPUX-ia64 Error: 13: Permission denied

Now the system is run with this way,

startup manually from oradr1 -> startup via sql command.

startsap from dr1adm.

I see that /oracle/DR1/102_64/rdbms/audit have permission 750 with oradr1:dba

Please your help/advice on this....

Thanks and Regards,

Yudi

[Former Member · Accepted solution]

Login with oracle user then start listener.

Then execute

sqlplus / as sysdba

and in sql prompt type startup;

If oracle services are started well then go to sidadm and type startsap.

Regards,

Shobhit

[Former Member · Accepted solution]

Dear Amit,

I follow your instruction and found below result

USERNAME USER_ID ACCOUNT_STATUS

-

---

-

---

-

---

OPS$SAPSERVICEDR1 31 OPEN

OPS$ORADR1 26 OPEN

OPS$DR1ADM 27 OPEN

SYS 0 OPEN

SYSTEM 5 OPEN

SAPSR3 28 OPEN

OUTLN 11 LOCKED

TSMSYS 21 EXPIRED & LOCKED

DIP 19 EXPIRED & LOCKED

ORACLE_OCM 25 EXPIRED & LOCKED

DBSNMP 24 EXPIRED & LOCKED

But I see the same value with the other system that run normally...... any suggest?

Dear Abhijeet Siras,

I already see the forum, but still no luck....

Dear Shobhit Kumar,

Yes, until now I use same with your way... it can bring the SAP up... but it makes check database in DB13 error continiously... and I think the problem is dr1adm can not connect to database..

please you help

Regards,

Yudi

[former_member220071 · Accepted solution]

Hi ,

Check owner of directory rdbms/audit

Abhijit

[Former Member · Accepted solution]

Dear Abhijit,

I see that /oracle/DR1/102_64/rdbms/audit have permission 750 with user oradr1 and group dba.

is that wrong?

Thanks and Regards,

Yudi

[former_member220071 · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Abhijeet Siras,

thanks for your link... but the link is related to we can not startup database at all.

Actually I still can startup my database with oracle user (oradr1).

what i cannot do is startup my database with sap user (dr1adm), and that is make I can not use script startsap, and all of backgroundjob related to database is error.

I try to create "test" file in $ORACLE_HOME with dr1adm, and there is no permission..

I try it in the other system that can work correctly and it same (I can not create "test" file in audit or oracle_home dir with sap userID).

I got this problem after I install EP in the same server..

please if there is any advice or concern again.

Thanks and Regards,

Yudi

[Former Member]

Dear All,

The issue is close by doing:

cd $ORACLE_HOME

cd bin

chmod 6755 oracle tns*

Thanks you so much all, I rewards poin to all of you...

Best Regards,

Yudi

[Former Member]

Hi

Have you changed anything in system like hostnam, SID, etc.

please check listner.ora and tns.ora files

Run the command

SQL> show parameter CONTROL_FILES

It will tell the locations of your control files, if any changes in the control files or these are not in same ver. then

run the command

SQL>ALTER SYSTEM SET CONTROL_FILES='/oracle/PDR/sapdata1/cntrl/cntrlPDR.dbf' scope=spfile;

after that start oracle, if it does not start then again run above command for another location of control file

This may help you.

Regards

Ganesh Datt Tiwari

[Former Member]

Dear Ganesh Datt Tiwari,

Yes, I change only for tns and listener, below is my listtener

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DP1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DP1)

)

(ADDRESS =

(PROTOCOL = IPC)

(KEY = DR1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = DR1)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ipxsapdev01)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = DP1)

(ORACLE_HOME = /oracle/DP1/102_64)

)

(SID_DESC =

(SID_NAME = DR1)

(ORACLE_HOME = /oracle/DR1/102_64)

)

)

and below is my tnsname.ora

DP1.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ipxsapdev01)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DP1)

(GLOBAL_NAME = DP1.WORLD)

)

)

DR1.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = ipxsapdev01)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = DR1)

(GLOBAL_NAME = DR1.WORLD)

)

)

I can start the listener for both SID.

and below is the parameter for DR1 that you mention

NAME TYPE VALUE

control_files string /oracle/DR1/origlogA/cntrl/cntrlDR1.dbf, /oracle/DR1/origlogB/cntrl/cntrlDR1.dbf, /oracle/

DR1/sapdata1/cntrl/cntrlDR1.dbf

is that ok?

Please your advice...

Thanks and Regards,

Yudi

[former_member220071]

This message was moderated.

[Former Member]

Hi,

Can you check with the following command where if in case any oracle id is locked.

SQL> SELECT USERNAME, USER_ID, ACCOUNT_STATUS FROM dba_users;

If you find the id locked , unlock the same and try to start the database.

Regards,

Amit