Create Database Ora-06553 Pls-213

SQL Code

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21st 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100

--the database created with the script creates a total error, Ora-06553 Pls-213 package is not Accessible. Originally thought to be the issue of version relink, to later suspect is the problem of environment variables. The environment variable is lost because the remote SSH IP su-oradce-c "sh test.sh". --Direct execution of Createdb.sql without error. But there were errors when executing sid.sh and sid.sql. Study for half a day, finally found the cause of the error in Metalink. -Simply remove the/opt/oracle/products/10.2.0/sqlplus/admin/login.sql set serveroutput on size 1000000 format wrapped this line. Col Temporary_tablespaceformatA30 Col Default_tablespaceformatA30 Col usernameformatA30 Col table_nameformatA30 Col segment_nameformatA30 Col column_nameformatA30 Setpages9999 SetLines - SetArraySize - Set Long 4000 SetServeroutput on size 1000000 formatWrapped SetTrimspool on Define _editor=vi Define User_name="" Define Instance_name="" SETTermoutOFF COLUMNuser_name New_value user_name COLUMNinstance_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 fromGlobal_name; SETsqlprompt' &[email protected]&instance_name> ' SET Term on /* Metalink The original text as follows: --create Database Statement generates Error Ora-06553 Pls-213 package No Accessible [ID 400942.1] -------------------------------------------------------------------------------- Modification time 16-jul-2007 type problem state moderated In this Document Symptoms Cause Solution -------------------------------------------------------------------------------- This document was being delivered to your via Oracle support ' s Rapid Visibility (RaV) process, and therefore have not been SU Bject 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, "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 "executed," and the database creation is not a complete yet. When the This command is Issued, and because the Dbms_output package are 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 was executed, and the same error is Returned. Solution Remove any "from the Glogin.sql file, at least before issuing the" CREATE DATABASE "command. However, the set SERVEROUTPUT statement was not found in Glogin.sql. Then the login.sql is removed. No more errors after that. -------------------------------------------------------------------------------- Related Products -------------------------------------------------------------------------------- Oracle Database Products > Oracle database > Oracle Database > Oracle server-enterprise Edition Key words -------------------------------------------------------------------------------- CREATE DATABASE; Dbms_output Error -------------------------------------------------------------------------------- ORA-6553; PLS-213 */

Create Database Ora-06553 Pls-213