Thursday, December 23, 2010

Oracle 10g for Windows 7

INSTALLATION STEPS for Oracle 10g

To install and configure Oracle 10.2 on the system, k

indly follow the following steps:

I hope you have already downloaded Oracle 10g on your system.

There are 3 folders :

1. 10.2.0.4

2. Client

3. Net

STEP1 : In the Client folder, Edit 'Oraparam.ini' inside the 'Install' Folder

delete lines from 46 to 74

Save the file.

Step2 : Run the Setup.

Select Runtime option to install

Step3 Installation path should be D:\Oracle\Product\

remove the remaining path.


4 Complete the setup. This will install Oracle 10.1 version. Now, add .Net related setup

5 In NET folder, edit oraparam.ini file inside Install Folder

delete line 39

Save the file.

6 Run the Setup.

Select the dropdown within Home Details and select the pop-up option(eg. oraclient10g_Home).



7 Uncheck Last 3 options to install Server.



8 Click Finish. Now Upgrade Oracle to 10.2.0.4

9 In 10.2.0.4 Folder, edit oraparam.ini file inside Install

delete line 33

Save the file.


10 Run the Setup.

Select the dropdown within Home Details and select the pop-up option(eg. oraclient10g_Home).

11 Click Finish.

12 Copy any existing 'tnsnames.ora' file and place at ‘D:\oracle\product\NETWORK\ADMIN’


And add your server details. Ex:

sc.advin.pg =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST =)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = sc)

)

)


13 Open SQL*Plus application



and test the following login details:

UserID : system

Pwd: abcd

Host:

15 With Authorized credentials, You can see the sql> prompt confirms Oracle is working fine.



2 comments:

  1. sc.advin.pg =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST =)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SID = sc)
    )
    )

    ReplyDelete
  2. Give the host Name in the above snippet as per your Oracle DB Server.

    ReplyDelete