Environment variable for ORACLE

[Former Member]

Hi All

Any Bod ylet me know , What is the Environment variable settings for oracle ?.After oracle 10 g installed in windows system for ECC installation . how to set enviromnet variables for oracle ?

Regards

Selvan

[Former Member]

Hi All,

Please correct me if i'm wrong. One prerequisite of installing NW2004s is that you must use windows server or another operating systems that is compatible and NOT windows

XP.

Please let me know.

Thanks.

[JPReyes]

Hi Joseph...

Installation of SAP 2004s is possible under windows XP... at lease the trial version

Regards

Juan

[Former Member]

HI Prem

This is a windows xp professional system ,

I check the services , but there was no service like Oracle .

What i do ?

selvan

[Former Member]

HI Prem

Oracle Deinstalled successfully , Then how to find the oracle service name and path ?

Selvan

[Former Member]

To find out the oracle services.

Please go to the Start--> run and enter services.msc

You will get a list of services running on your windows Server.

Now search for Services with the name starting with oracle.(it should be oracle TNS, ORACLE AGENT, ORACLE HTTP). Stop all these services and when you right click these services --> properies , then you will get the path for it.

Regards,

Prem

[Former Member]

Hi Prem

How to delete OS level service ?

selvan

[Former Member]

go to command level and use the SC utility

You will rquire to use the command in the following format:

sc delete <service name>

Paste the full path for the service name.

Regards,

Prem

[Former Member]

Hi Prem

I installed oracle with database creation . installation also completed .

What i have to do ?

kindly advice me

Selvan

[Former Member]

Hi,

In this scenario what I wud suggest you to uninstall the complete Oracle database and software using the OUI installer.

Next is you need to delete the services created on windows OS level.

Next is you can delete the Oracle entry created in windows Registery.

Last is delete the Oracle folders created on OS level manually,.

Please maintain the sequence.

Rewards points if useful and update the thread status!

Regards,

Prem

[Former Member]

Hi Bidwan

noted , one doubt . Oracle installation succuessfully completed , While Central instance installing , now it asking Database ID DBSID , Shall i give the same SAPSID here also ? kindly letme know

selvan

[Former Member]

Yes...Usually the Database SID and SAP Sid for a particular system is kept the same...Go ahead....

[Former Member]

Hi Bidwan

While oracle installation , it askiing 3 options

1. creating a new database

2. Database software only

Which one i have to select for ECC - 6 server installation ?

Regards

Selvan

[Former Member]

If you are installing Oracle database for your ECC6 installtion you have to select create a new database...This will create a new database with whatever SID you give at a later stage...say DEV...

[Former Member]

Hi Selvan,

While installing Oracle (i.e before installation of SAP Central Instance & Database Instance), you need to install ONLY the database software.

The Creation of database is done by SAP from the Export CDs.

@ Bidwan: Why have you suggested him to create a New Database.

It should have been - only database software! ...

Regards,

Prem

[Former Member]

HI Bidwan ,

Thanks yaar ,

Selvan

[Former Member]

Right-click on "My Computer" to select Properties.

Click the "Advanced" tab.

Click the "Environment Variable" button.

Scroll down the "System variables" list to the "Path" variable.

Double click on "Path"

Press the "End" key

Type (beginning with a semicolon separator) ;....path of oracle/bin

Click "OK"

Click "OK" to close the System Properties window.

Now Add 2 more System Variables using the "New" Button

ORACLE_SID and ORACLE_HOME

Hope this helps!