Created
August 23, 2016 14:28
-
-
Save goutham27/a30eed6ee71f57bab6aa25d9bdf6e89a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-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