Post steps of database instance creation

 Execute the following scripts after creating database manually (with no dbca command):

 SYS as sysdba
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/javavm/install/initjvm.sql
@?/javavm/install/initxa.sql
@?/xdk/admin/initxml.sql
@?/xdk/admin/xmlja.sql
@?/rdbms/admin/catjava.sql

 SYSTEM
@?/sqlplus/admin/pupbld.sql

Comments

Post a Comment

Popular posts from this blog

Change bytes into char inside data type of VARCHAR2   begin for r in     (select owner, table_name, column_name, data_length       from all_tab_columns       where data_type = 'VARCHAR2'        and char_used = 'B' and owner = 'SCHEMA') loop execute immediate 'alter table ' || r.owner || '.' || r.table_name || ' modify '  || r.column_name  || ' varchar2(' || r.data_length || ' char)'; end loop; end; / Note: Replace SCHEMA with owner of the tables
Read more
Remove the spurious CR characters The ^M is a carriage return character. Linux uses the line feed character to mark the end of a line, whereas Windows uses the two-character sequence CR LF. Your file has Windows line endings, which is confusing Linux. You can remove the spurious CR characters with the following command: sed -i -e 's/\r$//' 
Read more