Create the file in ORACLE_HOME/dbs/initWH1.ora with the following content. Control_files = (/home/oradata/wh1/WH1/control01.ctl, /home/oradata/wh1/WH1/control02.ctl, /home/oradata/wh1/WH1/control03.ctl) undo_management = auto db_name = WH1 db_block_size = 8192 audit_file_dest = /home/oradata/wh1/admin/adump background_dump_dest = /home/oradata/wh1/admin/bdump core_dump_dest = /home/oradata/wh1/admin/cdump db_domain = example.com db_recovery_file_dest = /home/oradata/wh1/flash_recovery_area db_recovery_file_dest_size = 0 db_unique_name = WH1 user_dump_dest = /home/oradata/wh1/admin/udump sga_max_size = sga_target = pga_aggregate_target = 2.1.2 Create the folders. This is done in sqlplus, first we export the env variable ORACLE_SID, then we start the oracle instance processes and finally we create the database with a custom query that specify the location of the datafiles, etc $ export ORACLE_SID=WH1 $ env|grep ORACLE_SID ORACLE_SID=WH1 Now connect to the idle instance $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 12 15: Copyright (c) 1982, 2007, Oracle. All Rights Reserved. When I did an Oracle 10g Release 1 (10.1.0.3.0) “General Purpose Database” installation (not including any software from the Oracle Database 10g Companion CD), the Oracle software used about 1.3 GB of disk space, and the preconfigured “General Purpose Database” (datafiles, etc.) used about 710 MB of disk space. Installing Prerequisites for Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part I; Installing Oracle 12c Database in CentOS 6.5. After extracting, we will get database directory which has 2.6GB in size. So, next we can go-head and install the oracle. Let us start the installation by running runInstaller. Navigate the installer Directory and run the Installer. Jan 28, 2009 I wouldn't touch Gentoo with precompiled software with a barge pole. The rational behind Gentoo is you compile everything yourself and I don't think Larry has open sourced Oracle yet. Connected to an idle instance. SYS@WH1 AS SYSDBA> Start the process but don't mount anything (nothing exists yet). SYS@WH1 AS SYSDBA> startup nomount; ORACLE instance started. Total System Global Area bytes Fixed Size 2187776 bytes Variable Size 815570432 bytes Database Buffers bytes Redo Buffers 4325376 bytes This create a bunch of processes on the system: $ ps -edf|grep WH1 oracle 8106 1 0 15:42:53? 0:00 ora_smon_WH1 oracle 8100 1 0 15:42:52? 0:00 ora_dbw1_WH1 oracle 8102 1 0 15:42:52? 0:00 ora_lgwr_WH1 oracle 8110 1 0 15:42:53? 0:00 ora_mmon_WH1 oracle 8092 1 0 15:42:52? 0:00 ora_pmon_WH1 oracle 8098 1 0 15:42:52? 0:00 ora_dbw0_WH1 oracle 8096 1 0 15:42:52? 0:01 ora_mman_WH1 oracle 8104 1 0 15:42:52? 0:00 ora_ckpt_WH1 oracle 8113 8089 0 15:42:53? 0:00 oracleWH1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 8094 1 0 15:42:52? 0:00 ora_psp0_WH1 oracle 8112 1 0 15:42:53? 0:00 ora_mmnl_WH1 oracle 8108 1 0 15:42:53? Configure new EMCA (database needs to be open) $ emca -deconfig dbcontrol db $ emca -config dbcontrol db -repos recreate If this method doesn't work, drop the existing repository manually. ![]() Oracle 10g Download$ sqlplus / AS sysdba SQL> conn sysman/sysman Connected. SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'MGMT_NOTIFY_QTABLE',force =>TRUE); PL/SQL procedure successfully completed. $ sqlplus / AS sysdba SQL> DROP user sysman cascade; DROP role MGMT_USER; DROP user MGMT_VIEW cascade; DROP public synonym MGMT_TARGET_BLACKOUTS; DROP public synonym SETEMVIEWUSERCONTEXT; User dropped. SQL> Role dropped. SQL> Synonym dropped. SQL> Synonym dropped. SQL> DECLARE CURSOR c1 IS SELECT owner, synonym_name name FROM dba_synonyms WHERE table_owner = 'SYSMAN'; BEGIN FOR r1 IN c1 LOOP IF r1.owner = 'PUBLIC' THEN EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name; ELSE EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.' ||r1.name; END IF; END LOOP; END; / PL/SQL procedure successfully completed. System altered. Then, create the repository without dropping the old one: $ emca -config dbcontrol db -repos CREATE 3.2 Oratab. To preserver the directory structure and transfert only the most recent backups, use the following steps: 1. Create a list of the file modified during the last 2 days # find /home/oradata/backup_area -mtime -2 -type f > /tmp/backuplist 2. Create (touch) the file on the target machine, make sure the directory structure exists # for i in $(cat /tmp/backuplist); do touch $i;done 3. Installing Oracle 10g On Freebsd Commands PdfOn the source machine, use rsync to transfert only the file existing on the target machine The rsync command makes sure that the modification time is not taken into account when building the transfert list (only the file size). Bwlimit ensures that we don't consume more than 7MB of bandwidth. Rsync --partial --progress --bwlimit=7000 --existing --size-only -av -e 'ssh -i /opt/oracle/.ssh/id_dsa' /home/oradata/backup_area [email protected]:/home/oradata/ 3.3 Migration Procedure. On server A $ sudo su - oracle $ export ORACLE_SID=ALP1 # rotate the online redo log $ sqlplus / as sysdba.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |