今天create db instance,sqlplus 登录后遇到PLS-00201这个错:
SQL> set serveroutput on
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL> exec dbms_output.enable(10000);
BEGIN dbms_output.enable(10000); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.ENABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
解决办法:
1. use sysdba to execute two sql(/$Oracle_home/rdbms/admin).
logging as sysdba
try to run standard.sql,catalog.sql
2. use sys and system to execute these sql scrīpt
as SYS (or connect internal)
$Oracle_home/rdbms/admin/catalog.sql
$Oracle_home/rdbms/admin/catsnmp.sql
$Oracle_home/rdbms/admin/catexp7.sql
$Oracle_home/rdbms/admin/catproc.sql
$Oracle_home/rdbms/admin/caths.sql
as SYSTEM (not SYS)
$Oracle_home/rdbms/admin/catdbsyn.sql
unix 重启oraclesu -oracle
sqlplus / as sysdba
shutdown immediate;
startup