Installgen
Features and Benefits
Installgen
Demo Available for download...
-- script: 19_sol_901_build_intermedia_1.sql
-- Features: This sql script adds the Intermedia feature to the Oracle database.
--
-- Script Sequence#: 19
-- Used By: 8_sol_901_db_build_1.sh
-- Copyright 2002 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 9-30-2001 dsimpson Initial Release
-- 12-14-2001 dsimpson Added UNLOCK of ctxsys,wksys,ordsys,mdsys accounts
-- corrected ctxsys default login password
-- This output file was created by Installgen version 1.38 on Sun Nov 10 14:51:56 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
-- ordinst.sql is always before the main Intermedia and context scripts are run
-- in order to create the ORDSYS account and grant privileges
connect / as SYSDBA
set echo on
spool /u01/v901/assistants/dbca/logs/ordinst.log
@/u01/v901/ord/admin/ordinst.sql;
ALTER USER wksys IDENTIFIED BY wksys ACCOUNT UNLOCK;
ALTER USER ORDSYS IDENTIFIED BY ORDSYS ACCOUNT UNLOCK;
ALTER USER MDSYS IDENTIFIED BY MDSYS ACCOUNT UNLOCK;
-- run script again - some parts were not completed due to locked accounts
@/u01/v901/ord/admin/ordinst.sql;
spool off
connect / as SYSDBA
set echo on
spool /u01/v901/assistants/dbca/logs/interMedia.log
@/u01/v901/ord/im/admin/iminst.sql;
spool off
-- always run the context script after running the Intermedia script
set echo on
spool /u01/v901/assistants/dbca/logs/context.log
@/u01/v901/ctx/admin/dr0csys change_on_install DRSYS TEMP;
-- unlock ctxsys account before logging in
ALTER USER ctxsys IDENTIFIED BY ctxsys ACCOUNT UNLOCK;
connect CTXSYS/CTXSYS
@/u01/v901/ctx/admin/dr0inst /u01/v901/ctx/lib/libctxx9.so;
@/u01/v901/ctx/admin/defaults/drdefus.sql;
spool off
exit;
