jump to navigation

Installation / Re-Installation of Oracle Database 10g on Windows November 17, 2007

Posted by Muhammad Habib in DBA.
1 comment so far

1.    Take back-up of data (Full Database).
2.    Shutdown your database. (Shutdown Abort).
3.    Take back-up of SP file.
(If you have set some parameters previously according to your environment)
4.    Note the size and names of all table spaces.
5.    Delete Database through wizard (If previously installed).
6.    Run Installer and uninstall Oracle from your system.
7.    Remove Oracle entries from registry.
8.    Restart your system.
9.    Remove Oracle Directory from System.
10.    Check services from Administrative tools. Please verify that there should not any Oracle related service existing in the list. No TNS, no oracle home etc.
11.    Reboot your system.
12.    Run Oracle Installer and start installation. Follow wizard and select options according to your requirements.
13.    When Database is created, verify your work by connecting to database.
14.    Shutdown Database.
15.    Restore SP file.
16.    Start Database.
(Note if you find any error on startup, then you have to generate SP file from init.ora file)
17.    Install patch from its installer and run the related scripts. (It will take around 45 minutes so no need to worry).
18.    Reboot your machine.
19.    Create table spaces by same name and size as we noted in step 4.
20.    Load (Import) backup from dmp file. Create log file as well.
(View log file. If you find any error of “table space already exists”, then don’t worry. It is because we have created the table spaces our selves.)

Good Luck!!!

Advertisements

Multi-Master Replication (MMR) October 17, 2007

Posted by Muhammad Habib in DBA.
1 comment so far

Very comprehensive guide to understand, plan and implement Multi-Master Replication.

http://www.oracle.com/technology/books/pdfs/book_rep_chap6_ce2.pdf

Cheers ……..

Protected: Transferring data using FNDLOAD August 10, 2007

Posted by Muhammad Habib in DBA, Oracle Applications.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Increase the Size of Tablespace March 31, 2007

Posted by Muhammad Habib in DBA.
53 comments

If you want to increase the size of tablespace, its so simple. You can do this by enterprise manager console. Increase the size of datafile for particular tablespace.

OR

For Example

ALTER DATABASE
DATAFILE ‘/u03/oradata/ userdata02. dbf’
RESIZE 200M;

If you don’t have any free space on that partition of disk then you can add another datafile on the other partition  for particular tablespace.

For example

ALTER TABLESPACE app_data
ADD DATAFILE ‘/u01/oradata/ userdata03. dbf’
SIZE 200M;

Now you can insert data with in this tablespace.

Flashback Version March 9, 2007

Posted by Muhammad Habib in DBA.
add a comment

As of oracle database 10g, you can display the different versions of rows that existed during specified intervals.

Flashback version queries require that the DBA has set a nonzero value for the UNDO_RETENTION initialization parameter. If the UNDO_RETENTION value is too low, you may get an ORA- 30052 error.

To prepare for these examples, delete the old rows from MY_TABLE:

delete from MY_TABLE;
Next, repopulate MY_TABLE:
select SysTimeStamp from DUAL;
insert into MY_TABLE
select * from MY_TABLE_OLD;

select SysTimeStamp from Dual;

Then, wait for a few minutes and update all rows:

select sysTimestamp from dual;

update MY_TABLE set categoryName = ‘ABCD’;

SELECT SYSTIMESTAMP FROM DUAL;

To execute a flashback version query, use the version between clause of the select command. You can specify either the timestamp or the SCN, In this example, the format for the timestamp clause is based on Oracle’s standard format(select systimestamp from dual for the current value):

select * from MY_TABLE
versions between timestamp
to_timestamp(’03-MAR-07 17.10.10′, ‘DD-MON-YY HH24.MI.SS’)
AND
to_timestamp(’03-MAR-07 17.25.10′, ‘DD-MON-YY HH24.MI.SS’);

When you execute the query, oracle will return one row for
each version of each row that occured between the start and
end points you specify in the versions between clause. For
the rows that are returned, you can query additional pseudo-columns.