oradim -new -srvc OracleServiceprim9i

CREATE DATABASE prim9iLOGFILE GROUP 1('E:\oracle\oradata\prim9i\admin\redo01.log') SIZE 100M,GROUP 2('E:\oracle\oradata\prim9i\admin\redo02.log') SIZE 100M,GROUP 3('E:\oracle\oradata\prim9i\admin\redo03.log') SIZE 100MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET US7ASCIINATIONAL CHARACTER SET AL16UTF16DATAFILE 'E:\oracle\oradata\prim9i\db\system01.dbf' SIZE 325MUNDO TABLESPACE UNDOTBSDATAFILE 'E:\oracle\oradata\prim9i\db\UNDOTBS01.dbf' size 100Mdefault temporary tablespace temp tempfile 'E:\oracle\oradata\prim9i\db\temp01.dbf' size 100M;

@?/rdbms/admin/catalog.sql@?/rdbms/admin/catproc.sql

@C:\oracle\ora92\rdbms\admin\catalog.sql@C:\oracle\ora92\rdbms\admin\catproc.sql@C:\oracle\ora92\rdbms\admin\catexp.sql

create tablespace data01 datafile 'E:\oracle\product\10.2.0\admin\prim9i\db\data01.dbf' size 100Mextent management local segment space management auto;

create user stud1 identified by stud1default tablespace data01;

grant connect,resource to stud1;

@E:\oracle\product\10.2.0\db_1\sqlplus\admin\pupbld.sql

prim9i = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = winxp_9i)(PORT = 1525)) ) ) )

SID_LIST_prim9i = (SID_LIST = (SID_DESC = (ORACLE_HOME = E:\oracle\ora92) (SID_NAME = prim9i) ) )

lsnrctl start prim9i

prim9i = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = winxp_9i)(PORT = 1525)) ) (CONNECT_DATA = (SERVICE_NAME = prim9i) ) )

############################################ Enabling Archive log mode###########################################SHUTDOWN IMMEDIATE;log_archive_start=TRUElog_archive_dest_1='location=E:\oracle\oradata\prim9i\admin\archive_logs\'log_archive_format='arch_%t_%s.arc'STARTUP MOUNT;ARCHIVE LOG START;ALTER DATABASE ARCHIVELOG;ALTER DATABASE OPEN;

SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination E:\oracle\oradata\prim9i\admin\archive_logs\Oldest online log sequence 1Next log sequence to archive 3Current log sequence 3