Oracle Study Guide

contents too big for a post see file http://oracle.3dub.com/vdollar.txt

SYSDBA users cannot do export/import.

Users need to be added to OEM Administrators in order to login to OEM. (’Setup’ link at top of screeen).



http://docstore.mik.ua/orelly/oracle/prog2/

http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnRHEL5.php

alter system set log_archive_trace=7935;

This will cause lgwr and archN to write a bunch of stuff to the alert log.

Make sure the server hostname does NOT change. It will cause problems with all of the oracel services restarting!

edit $ORACLE_HOME/sqlplus/admin/glogin.sql

– parm: my specific stuff
ALTER SESSION SET nls_date_format = ‘HH:MI:SS’;
SET SQLPROMPT “_USER’@'_CONNECT_IDENTIFIER _DATE> ”
SET PAGESIZE 24
SET LINESIZE 78

This can also be set in user’s home directory, but will only be run if user connects to sqlplus from their home directory.

http://oracle.3dub.com/10g/

http://www.oracle.com/technology/obe/obe10gdb/storage/datapump/datapump.htm#t2

http://www.dba-oracle.com/oracle_tips_db_copy.htm

Actual commands:

1. login to source db and backup the controlfile:
alter database backup controlfile to trace as ‘<filename>’ reuse;

2. shut down source database and target database

3. Copy all data files into the new directories on the new server. You may change the file names if you want, but you must

edit the controlfile to reflect the new data files names on the new server. DO NOT copy over the control files.

4. edit the trace control file and change all references to the old database name to the new database name. BEWARE that there

are 2 cases. Just delete all of the lines for the second case.

5. Look out for comments in sql blocks and remove them!! they cause the script to blow up.

6. Move the control files for the target database to backup.

7. Comment out the ‘RECOVER DATABASE’ — it is not necessary as the source was shutdown cleanly.

8. change the line:
CREATE CONTROLFILE REUSE DATABASE “OLDSQL” NORESETLOGS  ARCHIVELOG

to

CREATE CONTROLFILE SET DATABASE “NEWLSQ” RESETLOGS ARCHIVELOG

9. The OPEN statement needs to be with the resetlogs clause.

10. login to the idle target database and run the updated trace script!