今天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 重启oracle

su -oracle
sqlplus / as sysdba
shutdown immediate;
startup