Skip to content

Instantly share code, notes, and snippets.

@goutham27
Created August 23, 2016 14:28
Show Gist options
  • Save goutham27/a30eed6ee71f57bab6aa25d9bdf6e89a to your computer and use it in GitHub Desktop.
Save goutham27/a30eed6ee71f57bab6aa25d9bdf6e89a to your computer and use it in GitHub Desktop.
-bash-4.1$ sqlplus -S /nolog @xdb_protocol.sql
Session altered.
Starting Oracle XML DB Installation ...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter Parameter #1 <XDB_PASSWD>, password for XDB schema:
Enter Parameter #2 <TABLESPACE>, tablespace for XDB:
Enter Parameter #3 <TEMP_TABLESPACE>, temporary tablespace for XDB:
Session altered.
Enter Parameter #4 <SECURE_FILES_REPO>, YES/NO
...................If YES
...................then XDB repository will be stored as secure files.
...................Otherwise, old LOBS are used
PL/SQL procedure successfully completed.
IF (dbms_registry.is_loaded('XDB') IS NULL) THEN
*
ERROR at line 6:
ORA-06550: line 6, column 21:
PLS-00302: component 'IS_LOADED' must be declared
ORA-06550: line 6, column 3:
PL/SQL: Statement ignored
SP2-1506: START, @ or @@ command has no arguments
Session altered.
IF (dbms_registry.version('XDB') is null) THEN
*
ERROR at line 2:
ORA-06550: line 2, column 21:
PLS-00302: component 'VERSION' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
-bash-4.1$ cat xdb_protocol.sql
SET VERIFY OFF
connect sys/vertex as SYSDBA
set echo on
spool /u01/app/oracle/admin/A001/scripts/xdb_protocol.log append
@/u01/app/oracle/product/12/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP
YES;
connect sys/vertex as SYSDBA
@/u01/app/oracle/product/12/rdbms/admin/catxdbj.sql;
@/u01/app/oracle/product/12/rdbms/admin/catrul.sql;
spool off
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment