Home » RDBMS Server » Server Administration » dbstart errors please help
dbstart errors please help [message #63381] Thu, 30 September 2004 04:21 Go to next message
AIAS
Messages: 1
Registered: September 2004
Junior Member
Hi oracle people,

we have an 8i databases installed on a solaris sun.

When I start the database (dbstart) I get the following errors:

***************************************
ORA-16038: log 2 sequence# 14 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 2 thread 1: '/db02/CTM4_6/redo02_1.dbf'
ORA-00312: online log 2 thread 1: '/db01/CTM4_6/redo02_2.dbf'

SQL> BEGIN dbms_shared_pool.keep('sys.standard'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

SQL> BEGIN dbms_shared_pool.keep('sys.DBMS_APPLICATION_INFO'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

SQL> BEGIN dbms_shared_pool.keep('sys.dbms_sys_sql'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
******************************************

Can anyone help give some clues on what is going on.

Thank you in advance,

AIAS
Re: dbstart errors please help [message #63399 is a reply to message #63381] Fri, 01 October 2004 12:21 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
I believe that error
ORA-16038: log 2 sequence# 14 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 2 thread 1: '/db02/CTM4_6/redo02_1.dbf'
ORA-00312: online log 2 thread 1: '/db01/CTM4_6/redo02_2.dbf'

could be lack of space in filesystem or lack of privileges.

Best luck.
Re: dbstart errors please help [message #64574 is a reply to message #63381] Wed, 09 February 2005 15:06 Go to previous message
winse
Messages: 1
Registered: February 2005
Junior Member
Hi, I got the same problems too. How did you resolve it?

Thanks.
Previous Topic: ORA-01113: file 2 needs media recovery
Next Topic: 9.2 vs 10g
Goto Forum:
  


Current Time: Fri Sep 27 04:20:03 CDT 2024