Oracle错误ORA
我使用Oracle 11g。 几天前我遇到了一个ORA-12514错误。 我试图通过遵循这个网站的建议来解决它：
C:>set oracle_sid=SID
Create a new environment variable called TNS_ADMIN:
in the ‘value’ field, add the new folder: c:oraclenetworkadmin
Copy tnsnames.ora, sqlnet.ora and listener.ora from c:oracleproduct102networkadmin
Paste into c:oraclenetworkadmin
Stop/start listener
C:>lsnrctl stop
C:>lsnrctl start
之后，我收到以下错误（ ORA-01033 ）：
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: pentacms
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
我试图解决错误，但它引发了其他错误，我尝试打开日志文件，但我收到下面的错误（最后一行）“错误在第1行：ORA-00600：内部错误代码，参数：[kcratr_nab_less_than_odr]，1 ，[46]，[32689]，[32690]，[]，[]，[]，[]，[]，[]，[]“请告诉我，这是一个紧急情况。
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION SEQ# EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT P3
---------------------------------------------------------------- ----------
P3RAW WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------
SYS$USERS DISABLED FALSE
SADDR SID SERIAL# AUDSID PADDR USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME COMMAND OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER PROCESS
------------------------------ ------------------------
MACHINE PORT
---------------------------------------------------------------- ----------
TERMINAL
----------------
PROGRAM TYPE
---------------------------------------------------------------- ----------
SQL_ADDRESS SQL_HASH_VALUE SQL_ID SQL_CHILD_NUMBER SQL_EXEC_
---------------- -------------- ------------- ---------------- ---------
SQL_EXEC_ID PREV_SQL_ADDR PREV_HASH_VALUE PREV_SQL_ID PREV_CHILD_NUMBER
----------- ---------------- --------------- ------------- -----------------
PREV_EXEC PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID
--------- ------------ --------------------- -------------------------
PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID
--------------- -------------------
MODULE MODULE_HASH
------------------------------------------------ -----------
ACTION ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION SEQ# EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT P3
---------------------------------------------------------------- ----------
P3RAW WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------
FALSE FIRST EXEC 0 000007FF5D4D8D70 2
SADDR SID SERIAL# AUDSID PADDR USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME COMMAND OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER PROCESS
------------------------------ ------------------------
MACHINE PORT
---------------------------------------------------------------- ----------
TERMINAL
----------------
PROGRAM TYPE
---------------------------------------------------------------- ----------
SQL_ADDRESS SQL_HASH_VALUE SQL_ID SQL_CHILD_NUMBER SQL_EXEC_
---------------- -------------- ------------- ---------------- ---------
SQL_EXEC_ID PREV_SQL_ADDR PREV_HASH_VALUE PREV_SQL_ID PREV_CHILD_NUMBER
----------- ---------------- --------------- ------------- -----------------
PREV_EXEC PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID
--------- ------------ --------------------- -------------------------
PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID
--------------- -------------------
MODULE MODULE_HASH
------------------------------------------------ -----------
ACTION ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION SEQ# EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT P3
---------------------------------------------------------------- ----------
P3RAW WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------
SADDR SID SERIAL# AUDSID PADDR USER#
---------------- ---------- ---------- ---------- ---------------- ----------
USERNAME COMMAND OWNERID TADDR
------------------------------ ---------- ---------- ----------------
LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME
---------------- -------- --------- ---------- ------------------------------
OSUSER PROCESS
------------------------------ ------------------------
MACHINE PORT
---------------------------------------------------------------- ----------
TERMINAL
----------------
PROGRAM TYPE
---------------------------------------------------------------- ----------
SQL_ADDRESS SQL_HASH_VALUE SQL_ID SQL_CHILD_NUMBER SQL_EXEC_
---------------- -------------- ------------- ---------------- ---------
SQL_EXEC_ID PREV_SQL_ADDR PREV_HASH_VALUE PREV_SQL_ID PREV_CHILD_NUMBER
----------- ---------------- --------------- ------------- -----------------
PREV_EXEC PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID
--------- ------------ --------------------- -------------------------
PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID
--------------- -------------------
MODULE MODULE_HASH
------------------------------------------------ -----------
ACTION ACTION_HASH
-------------------------------- -----------
CLIENT_INFO
----------------------------------------------------------------
FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
-------------------- ------------- -------------- --------------- -------------
TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI
--------------- --------- ------------ --- ------------- ---------- ---
RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU
-------------------------------- -------- -------- --------
CURRENT_QUEUE_DURATION
----------------------
CLIENT_IDENTIFIER BLOCKING_SE
---------------------------------------------------------------- -----------
BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCK FINAL_BLOCKING_INSTANCE
----------------- ---------------- ----------- -----------------------
FINAL_BLOCKING_SESSION SEQ# EVENT#
---------------------- ---------- ----------
EVENT
----------------------------------------------------------------
P1TEXT P1
---------------------------------------------------------------- ----------
P1RAW
----------------
P2TEXT P2
---------------------------------------------------------------- ----------
P2RAW
----------------
P3TEXT P3
---------------------------------------------------------------- ----------
P3RAW WAIT_CLASS_ID WAIT_CLASS#
---------------- ------------- -----------
WAIT_CLASS WAIT_TIME
---------------------------------------------------------------- ----------
SECONDS_IN_WAIT STATE WAIT_TIME_MICRO TIME_REMAINING_MICRO
--------------- ------------------- --------------- --------------------
TIME_SINCE_LAST_WAIT_MICRO
--------------------------
SERVICE_NAME SQL_TRAC SQL_T
---------------------------------------------------------------- -------- -----
SQL_T SQL_TRACE_ SESSION_EDITION_ID CREATOR_ADDR CREATOR_SERIAL#
----- ---------- ------------------ ---------------- ---------------
ECID
----------------------------------------------------------------
16 rows selected.
SQL> desc dba_user;
ERROR:
ORA-04043: object dba_user does not exist
SQL> desc dba_users;
ERROR:
ORA-04043: object dba_users does not exist
SQL> desc v$user;
ERROR:
ORA-04043: object v$user does not exist
SQL> desc v$users
ERROR:
ORA-04043: object v$users does not exist
SQL> seleect * from dba_users;
SP2-0734: unknown command beginning "seleect * ..." - rest of line ignored.
SQL> select * from dba_users;
select * from dba_users
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[46], [32689], [32690], [], [], [], [], [], [], []
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted
SQL> alter database mount;
发生什么事情了？ 该rdbms清楚地表明，它不是开放的生产。 可能会坠毁。 可能会损坏。 联系你的dba解决。 你的数据库被挂载。
alter database open;
如果它打开，那么确定，如果没有，请检查alertlog文件的内容以查看它抱怨的内容。 如果您收到投诉，最有可能希望恢复。 它失败了，所以尝试：
recover database until cancel;
并看看它走多远。 您的问题可能是受损的在线重做日志文件。 如果恢复要求不存在任何现有的归档日志文件，请为其提供包含数据库请求的更改的重做日志组成员。 如果无法完成恢复，请恢复数据库。
startup mount
select member from v$logfile;
-- take a note for their full names.
recover database until cancel;
现在恢复过程将要求存档日志文件。 如果你有他们，如果他们在默认位置，如果过程建议一个，按回车键。 重复该操作，直到过程失败，因为无法找到该文件。 然后再次启动恢复，而不是接受建议的答案，请输入日志组的日志成员的全名。 如果你幸运的话，并不是所有的成员都变得腐败，你可以完成恢复过程。
如果这不起作用，则显示错误，日志等。您非常接近不得不从头开始。 这不是你想听到的答案，但它很现实....
链接地址: http://www.djcxy.com/p/36925.html上一篇: Oracle error ORA