7/14/2009

Setting up Oracle 10g in Windows - Tips to a Newbie

Are you new to Oracle? Have you been spending tiresome hours troubleshooting Oracle?
Well.. I would say 'Yes' if someone asked me :)
But I never think that the time has been wasted. Remember... 'No pain, No gain' :)
Recently I did setup an Oracle 10g on a Vista machine and I would like to share some important scenarios that I experienced.

1. Is your Oracle compatible with the OS?
Well.. the first issue came across is this. I tried to install 10.2.0.3 on a XP machine and it says 'Your OS does not support...'. I should have had 10.2.0.1 to install in a XP

How the DB is versioned?
10.2.0 is the actual release version and '3' is the patch set. Check Oracle site (http://www.oracle.com/technology/software/products/database/index.html) for compatibility, before you download.


2. Is your DB server DHCP enabled?

If your server is DHCP enabled, you will get a test failed condition in verification phase. To solve this add a Microsoft loop back adapter
Go to Control panel->Add Hardware
Select Network adapters
select Microsoft Loop back adapter
Once Installed, configure properties for IPV4 with following static IP values 10.10.10.10/255.255.255.0


3. Have you come across a situation where you are in front of the Db server and trying to connect to the database via sqlplus "/ as sydba", and get the following error 'ORA-01031: insufficient privileges' enter your use-name: and your sys password is not accepted

One reason might probably be that you have logged in to the DB server not as the administrator.(or probably not as product owner). If that is the case and if you are unable to log in as product owner, and if you still want to log in to database, there is a work around for you.

1. Delete and recreate a new password file
give password file name and location, and password
In DOS prompt type:
orapwd file = c:\ora_home\database\pwdfile.ora password=oracle

2. Restart Oracle database
Go to Services and restart the service (OracleService)

3. Now try to log in to DB via
sqlplus "/ as sydba"
with new password





No comments:

Post a Comment