Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below

Find knowledge base article(s) by browsing the subject categories of articles

Technology quick references, cheatsheets, user manuals etc.

Shop Online through ShopifyLite

Tutorials on various IT applications.

How to install Oracle 8i on Solaris

Assumes SID of X136 1. Login to the server 2. vi ~/.profile change ORACLE_SID as ORACLE_SID X136 3. create initX136.ora in $HOME/LABS/ # vi $HOME/LABS/initX136.ora ------------------------------------------------------------- # $Header: init.ora # Sample parameter file for # Oracle8i: database Administration Class Edition 1.0 compatible = 8.1.5 db_block_buffers = 100 db_file_multiblock_read_count = 8 db_files = 30 distributed_transactions = 10 dml_locks = 200 job_queue_interval = 10 job_queue_processes = 2 log_checkpoint_interval = 10000 log_checkpoint_timeout = 1800 max_dump_file_size = 10240 # limit trace file size to 5M each parallel_max_servers = 5 processes = 60 processes = 60 #service_names = db01 sort_area_size = 64000 db_file_multiblock_read_count = 8 shared_pool_size = 3500000 #remote_login_passwordfile=exclusive #timed_statistics = true parallel_max_servers = 12 # SMALL global_names = TRUE db_domain = world #rollback_segments = (sysrol) # Parameters to be edited db_name = X136 db_block_size = 8192 control_files = ($HOME/DATA/DISK5/control01.con) background_dump_dest = ($HOME/BDUMP) user_dump_dest = ($HOME/UDUMP) core_dump_dest = ($HOME/CDUMP) java_pool_size = 1000000 ------------------------------------------------------------- 4. create a password file for INTERNAL $ vi $ORACLE_HOME/dbs/orapwX136 $ rm $ORACLE_HOME/dbs/orapwX136 $ orapwd file=$ORACLE_HOME/dbs/orapwX136 entries=5 password=admin $ chmod 777 $ORACLE_HOME/dbs/orapwX136 5. create an sql script to perform the create database $ vi $HOME/LABS/creX136.sql ------------------------------------------------------------- spool $HOME/LABS/creX136.log set echo on connect INTERNAL/admin as sysdba startup nomount pfile=$HOME/LABS/initX136.ora CREATE DATABASE "X136" MAXLOGFILES 10 MAXLOGMEMBERS 2 MAXDATAFILES 30 MAXLOGHISTORY 100 LOGFILE GROUP 1 ('$HOME/DATA/DISK6/redo0101.log') size 150K, GROUP 2 ('$HOME/DATA/DISK6/redo0201.log') size 150K DATAFILE '$HOME/DATA/DISK4/system01.dbf' SIZE 20M REUSE AUTOEXTEND ON MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1; spool off ------------------------------------------------------------- 6. Ensure current $ORACLE_SID is pointing to X136 $ export ORACLE_SID=X136 $ echo $ORACLE_HOME 7. Run the script from SVRMGRL $ svrmgrl SVRMGRL> connect internal/admin as sysdba SVRMGRL> @$HOME/LABS/creX136.sql 8. If successful, confirm database exist by $ SVRMGRL SVRMGRL> connect internal/admin as sysdba SVRMGRL> SELECT name,created,log_mode FROM v$database; SVRMGRL> SELECT status, instance FROM v$thread; SVRMGRL> SELECT name from v$datafile; SVRMGRL> SELECT member FROM v$logfile; SVRMGRL> SELECT name FROM v$controlfile; SVRMGRL> show SGA 9. Create the data dictionaries by running @$ORACLE_HOME/rdbms/admin/catalog.sql Create the packages by running @$ORACLE_HOME/rdbms/admin/catproc.sql $ SVRMGRL SVRMGRL> connect internal/admin as sysdba SVRMGRL> @$ORACLE_HOME/rdbms/admin/catalog.sql SVRMGRL> @$ORACLE_HOME/rdbms/admin/catproc.sql