当前位置：Gxlcms >
数据库问题 >
Create Database Ora-06553 Pls-213
Create Database Ora-06553 Pls-213
时间：2021-07-01 10:21:17
帮助过：48人阅读
--只要把/opt/oracle/products/10.2.0/sqlplus/admin/login.sql中的set serveroutput on size 1000000 format wrapped这一行去掉即可。
col temporary_tablespace format a30
col default_tablespace format a30
col username format a30
col table_name format a30
col segment_name format a30
col column_name format a30
set pages 9999
set lines 100
set arraysize 100
set long 4000
set serveroutput on size 1000000 format wrapped
set trimspool on
define _EDITOR=vi
define user_name=""
define instance_name=""
SET TERMOUT OFF
COLUMN user_name NEW_VALUE user_name
COLUMN instance_name NEW_VALUE instance_name
SELECT lower(user) user_name,
decode(instr(global_name,‘.‘),0,global_name,
substr(global_name,1,instr(global_name,‘.‘)-1 )) instance_name
FROM global_name;
SET SQLPROMPT ‘&user_name@&instance_name>‘
SET TERM ON
/* metalink原文如下:
--Create Database Statement Generates Error Ora-06553 Pls-213 Package Standard Not Accessible [ID 400942.1]
--------------------------------------------------------------------------------
修改时间 16-JUL-2007 类型 PROBLEM 状态 MODERATED
In this Document
Symptoms
Cause
Solution
--------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support‘s Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.
Symptoms
Database creation using the CREATE DATABASE command generates the following error after some processing:
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
Cause
The problem was caused by including the line "SET SERVEROUT ON" in the glogin.sql file.
During database creation, the glogin.sql file is executed, which in turn causes the "SET SERVEROUT
ON" line to be executed, while the database creation is not complete yet. When this command is
issued, and because the DBMS_OUTPUT package is not created yet, the database creation fails and
the following error is returned:
ORA-06553: PLS-213: package STANDARD not accessible
Also, during subsequent logins to SQL Plus, the glogin.sql file is executed, and the same error is
returned.
Solution
Remove any "" from the glogin.sql file, at least before issuing the "CREATE DATABASE" command.
但是在glogin.sql 并未发现set serveroutput 语句。于是将login.sql中的去掉。之后没有再报错
--------------------------------------------------------------------------------
相关的产品
--------------------------------------------------------------------------------
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
--------------------------------------------------------------------------------
CREATE DATABASE; DBMS_OUTPUT
错误
--------------------------------------------------------------------------------
ORA-6553; PLS-213
*/
Create Database Ora-06553 Pls-213
标签：
