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…
-
Oracle SQL Loader DB link-21
SQL Loader It’s a utility. It will load the external data table into oracle. Like excel, Csv & notepad. Keyword: sqlldr Syntax: $ sqlldr un/pw parameter 1,2, etc .. Parameters: Control= <controlfile name> Inline = <input file name> Badfile= <badfile name> – it will have an unloaded data, incase of any failure and mismatch Discardfile=< discordfile name> – It will store the condition of the data. Like eno should be 3 digit Log =<logfile name> – log Ex: We have an employee table ENo: 101,102,103ABC & 05 etc… SO the tow digit will not upload, since we have a condition and character will not upload and it will go to…