Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
-- script: 19_sol_920_build_intermedia_1.sql
-- Features: This sql script adds the Intermedia feature to the Oracle database.
--
-- Script Sequence#: 19
-- Used By: 3_sol_920_prepinstall_1.sh
-- Copyright 2002 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 10-14-2002 dsimpson Initial Release for Oracle 9.2.0
-- Updated parameters passed to dr0csys
-- This output file was created by Installgen version 1.38 on Sun Nov 10 14:20:50 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
-- create ctxsys user
@/u01/v901/ctx/admin/dr0csys CTXSYS 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/bin/oractxx9.dll;
@/u01/v901/ctx/admin/defaults/dr0defin.sql AMERICAN;
spool off
exit;
