ASM – Automatic Storage Management It’s an oracle 10g feature. ASM is same as normal database instead of storing a DB files on normal filesystem. It will store a file an ASM managed file system, which will give disk redundancy. It only prevents a disk failure not the instance failure. ASM uses a disk group to store the oracle files. A disk group is a collection of disks. It supports single-instance and (Oracle RAC) configurations. ASM only supports for external disk. External disk should be a raw disk, mostly a RAID. “ ASM is a volume manager and a file system for Oracle database files that supports single-instance Oracle…
-
-
Oracle database Migration and upgrade-25
Migration Migration is a major release change. Ex: 9i to 10g or 11g (OR) 10g to 11g. Migration will be going from lower to higher version. The windows to Linux will be cross platform migration. Migrate from 9i Windows to Linux Pre-requesting Note down the following. Sql> select username,default_tablespace from dba_users; Sql> select * from dba_ts_quotas; Sql> select tablespace_name sum(bytes)/1024/1024 from dba_data_files group by tablespace_name; Step 1: Export Schema D:\> exp system/manager file D:\muthu.dump owner =Muthu log=D:\muthu.log Step 2: Move the dump file to Linux D:\> ftp 192.168.9.1 Login: ftp> cd /opt ftp> lcd D:\ ftp> bin ftp> put Muthu.dump ftp> bye Step 3: Create a same…
-
Oracle database Cloning-24
Cloning Cloning is creating a same database as in different name and the DBID will be different. Use It mostly used to test the application functionality and new implementation. Methods of cloning Cold backup Hot Backup RMAN Backup (duplicated database / active database) Pre- Requirement Create a folder according to the versions. 11g: /opt/oracle (ORACLE_BASE ) –> (Admin , Oradata & diag) Admin –>DBname (adump, create, ddump & pfile) Oradata –> DBnames Diag –> RDMBS–>DBname–>DBname–>Trace (bdump,cdump & udump) All in under trace, but without folders Clod backup Cloning It’s an offline cloning. Go to source database. Pre- requesting: Note down the following. Sql> select name from v$datafile; Sql> select member…
-
Oracle Upgradation Patch set apply-23
Upgradation – Patch set apply Upgradation will change the database minor release from one version to another. Ex: major.minor.build.revision.release 10.2.0.1.0 — 10.2.0.5.0 11.2.0.1.0 — 10.2.0.4.0 Go to oracle website — Choose type as patchset — Search and download. Ex: p120205_linux_x86.zip ~1000 MB Why do we need to do an upgrade? When there is a product bug, we need to do an upgrade, since there is no proper solution, there may be a workaround. Ex: ORA-006000 – internal error ORA – 7445 Pre-upgrade checks and tasks Stop listener Down the database $ echo $ORACLE_HOME – Note down it Shared_pool, Large_pool & jave_pool – should be > 128 MB System, sysAux, Undo,…
-
Oracle Patches apply update-22
Oracle Patches Patches are used to correct the bugs. It will change the last number of the version. 11.2.0.3.0 to 11.2.0.3.1 – PSU Ex: 10g -10.2.0.4.0 version – alter system flush shared_pool/buffer_cache will not work 11g -11.2.0.3.0 version – $nid DB newid will not work. (Changing DB ID) Types of Patch: Opatch – Oracle patch (It will fix only one bug) CPU – Critical patch update (Every quarter once) PSU – Patch set update (Bundle patch) 2.0.3.0 to 11.2.0.3.1 Opatch CPU PSU One off patch Security patch Bundle patch Size will be in KB Size will be min 80 MB to Max 150 MB Size will be min…