Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
-- script: 19_win_920_build_intermedia_1.sql
-- Features: This sql script adds the Intermedia feature to the Oracle database.
--
-- Script Sequence#: 19
-- Used By: 3_win_920_prepinstall_1.pl
-- Copyright 2002 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 07-26-2001 dsimpson Initial Release for Oracle 9.2.0
-- Updated parameters passed to dr0csys
-- This output file was created by Installgen version 1.38 on Thu Nov 14 17:48:05 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 priviledges
connect / as SYSDBA
set echo on
spool c:\v901\assistants\dbca\logs\ordinst.log
@c:\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
@c:\v901\ord\admin\ordinst.sql;
spool off
connect / as SYSDBA
set echo on
spool c:\v901\assistants\dbca\logs\interMedia.log
@c:\v901\ord\im\admin\iminst.sql;
spool off
-- always run the context script after running the Intermedia scipt
set echo on
spool c:\v901\assistants\dbca\logs\context.log
-- create ctxsys user
@c:\v901\ctx\admin\dr0csys CTXSYS DRSYS TEMP;
-- unlock ctxsys account before logging in
ALTER USER ctxsys IDENTIFIED BY ctxsys ACCOUNT UNLOCK;
connect CTXSYS/CTXSYS
@c:\v901\ctx\admin\dr0inst c:\v901\bin\oractxx9.dll;
@c:\v901\ctx\admin\defaults\dr0defin.sql AMERICAN;
spool off
exit;
