Home » Infrastructure » Windows » Value for PATH environment variable (Oracle 11gR2, windows XP)
Value for PATH environment variable [message #575475] Wed, 23 January 2013 09:23 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Hi,

Can someone tell me what value exactly I need to give for the PATH environment variable in oracle 11g running on windows xp?
Re: Value for PATH environment variable [message #575477 is a reply to message #575475] Wed, 23 January 2013 09:26 Go to previous messageGo to next message
BlackSwan
Messages: 22844
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

PATH should include $ORACLE_HOME/bin

is V11.2 certified on XP?
Re: Value for PATH environment variable [message #575478 is a reply to message #575477] Wed, 23 January 2013 09:38 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
That command is not working in windows.
Re: Value for PATH environment variable [message #575479 is a reply to message #575478] Wed, 23 January 2013 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 22844
Registered: January 2009
Senior Member
my car won't go.
tell me how to make my car go.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

Re: Value for PATH environment variable [message #575480 is a reply to message #575479] Wed, 23 January 2013 09:53 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member

C:\Documents and Settings>set PATH=c:\app\xxxxxxx\product\11.2.0\dbhome_1/bin

I created 2 databases. one is "A" and the other database is called "B".

In sql plus tool, I do "sqlplus / as sysdba". It asks for the password. I give the correct password. Then, I give this command "select name from v$database" to make sure whether i am in the right database. Instead of showing database "B", it is showing database "A". So, I feel that I havent set the environment variables properly. I was able to set the ORACLE_HOME and ORACLE_SID. But I am not sure about the PATH environment variable. Here is what I did to set the 3 environment variables.

-- oracle home
C:\Documents and Settings>set ORACLE_HOME=c:\app\xxxxxxx\product\11.2.0\dbhome_1/bin
C:\Documents and Settings>echo %ORACLE_HOME%
c:\app\xxxxxxx\product\11.2.0\dbhome_1/bin

-- oracle sid
C:\Documents and Settings>set ORACLE_SID=B
C:\Documents and Settings>echo %ORACLE_SID%
B

-- PATH
C:\Documents and Settings>set PATH=c:\app\xxxxxxx\product\11.2.0\dbhome_1/bin
C:\Documents and Settings>echo %PATH%
c:\app\xxxxxxx\product\11.2.0\dbhome_1/bin

After setting the above environment variables, if i try to connect to database "B" and query like this "select name from v$database", still it is giving the result as database "A" and not database "B". I want it to show as database "B". Please help.
Re: Value for PATH environment variable [message #575481 is a reply to message #575480] Wed, 23 January 2013 10:00 Go to previous messageGo to next message
BlackSwan
Messages: 22844
Registered: January 2009
Senior Member
post results from following OS commands

set
lsnrctl status
lsnrctl service


COPY the results from above then PASTE all back here
Re: Value for PATH environment variable [message #575483 is a reply to message #575481] Wed, 23 January 2013 10:42 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I am NOT sure how safe it is to paste the company database details here.



C:\Documents and Settings\Lakshmg3>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Lakshmg3\Application Data
CLASSPATH=.;C:\Program Files\Java\jre6\lib\ext\QTJava.zip
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=LNGDAYD-5002192
ComSpec=C:\WINDOWS\system32\cmd.exe
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Lakshmg3
HOMESHARE=\\LEGAL.REGN.NET\DAY
LDMS_LOCAL_DIR=C:\Program Files\LANDesk\LDClient\Data
LOGONSERVER=\\LNGDAYDCXP024
MANU=Dell Inc.
MODEL=755
NUMBER_OF_PROCESSORS=2
ORACLE_SID=content
OS=Windows_NT
Path=c:\app\Lakshmg3\product\11.2.0\dbhome_1/bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 11, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0b
ProgramFiles=C:\Program Files
PROMPT=$P$G
QTJAVA=C:\Program Files\Java\jre6\lib\ext\QTJava.zip
RoxioCentral=C:\Program Files\Common Files\Roxio Shared\9.0\Roxio Central33\
SERIAL=9MCLCH1
SESSIONNAME=RDP-Tcp#2
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\Lakshmg3\LOCALS~1\Temp
TMP=C:\DOCUME~1\Lakshmg3\LOCALS~1\Temp
TYPE=OptiPlex
USERDNSDOMAIN=LEGAL.REGN.NET
USERDOMAIN=LEGAL
USERNAME=Lakshmg3
USERPROFILE=C:\Documents and Settings\Lakshmg3
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS


***************************************************************************************


C:\Documents and Settings\Lakshmg3>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 23-JAN-2013 11:3
:47

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 22-JAN-2013 05:02:19
Uptime 1 days 6 hr. 33 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Lakshmg3\product\11.2.0\dbhome_1\network\admin
listener.ora
Listener Log File c:\app\lakshmg3\diag\tnslsnr\LNGDAYD-5002192\listener
alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LNGDAYD-5002192.legal.regn.net)(POR
=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "avaya.legal.regn.net" has 1 instance(s).
Instance "avaya", status READY, has 1 handler(s) for this service...
Service "avayaXDB.legal.regn.net" has 1 instance(s).
Instance "avaya", status READY, has 1 handler(s) for this service...
Service "content.legal.regn.net" has 1 instance(s).
Instance "content", status READY, has 1 handler(s) for this service...
Service "contentXDB.legal.regn.net" has 1 instance(s).
Instance "content", status READY, has 1 handler(s) for this service...
The command completed successfully


********************************************************************************


C:\Documents and Settings\Lakshmg3>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 23-JAN-2013 11:36
:29

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "avaya.legal.regn.net" has 1 instance(s).
Instance "avaya", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "avayaXDB.legal.regn.net" has 1 instance(s).
Instance "avaya", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: LNGDAYD-5002192, pid: 2904>
(ADDRESS=(PROTOCOL=tcp)(HOST=LNGDAYD-5002192.legal.regn.net)(PORT=1092)
)
Service "content.legal.regn.net" has 1 instance(s).
Instance "content", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1859 refused:0 state:ready
LOCAL SERVER
Service "contentXDB.legal.regn.net" has 1 instance(s).
Instance "content", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: LNGDAYD-5002192, pid: 1876>
(ADDRESS=(PROTOCOL=tcp)(HOST=LNGDAYD-5002192.legal.regn.net)(PORT=1093)
)
The command completed successfully

**************************************************************************************
Re: Value for PATH environment variable [message #575485 is a reply to message #575483] Wed, 23 January 2013 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am NOT sure how safe it is to paste the company database details


You can always modify the server names and IPs (telling us you do so and modifying them consistently) and remove the lines that are not related to Oracle and Windows (for instance Roxio).

In addition, we already told you about one hundred times to FORMAT your post.

Regards
Michel
Re: Value for PATH environment variable [message #575488 is a reply to message #575485] Wed, 23 January 2013 11:07 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I have pasted the content in a file called "dummy.txt" and uploaded here. Please let me know if you are able to see it?
  • Attachment: dummy.txt
    (Size: 4.85KB, Downloaded 75 times)
Re: Value for PATH environment variable [message #575489 is a reply to message #575488] Wed, 23 January 2013 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand, are you the databases server or are connecting remotely?
In the first listener is irrelevant, in the second ORACLE_SID is irrelevant.

An no, I can't download file, put in the post and put it FORMATTED. If you don't remember how to do it just go back to the forum guide at top of each forum.

Regards
Michel
Re: Value for PATH environment variable [message #575493 is a reply to message #575489] Wed, 23 January 2013 11:55 Go to previous messageGo to next message
BlackSwan
Messages: 22844
Registered: January 2009
Senior Member
you should be able to connect to the other DB by first doing as below

SET ORACLE_SID=avaya

sqlplus / as sysdba

SELECT NAME FROM V$DATABASE;
Re: Value for PATH environment variable [message #575495 is a reply to message #575493] Wed, 23 January 2013 12:02 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I gave the below commands in the command prompt..

C:\Documents and Settings\Lakshmg3>set ORACLE_SID=content

C:\Documents and Settings\Lakshmg3>echo %ORACLE_SID%
content

In SQL plus, I gave the following :

Enter user-name: sqlplus / as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
AVAYA


I dont want AVAYA, I want the result to be content. I am trying to access the content database, not avaya database. Please help.
Re: Value for PATH environment variable [message #575496 is a reply to message #575495] Wed, 23 January 2013 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Why should we help someone that completely refuse to follow our rules?
If you are not part of our forum, we have no reason to help you.

Regards
Michel

[Updated on: Wed, 23 January 2013 12:06]

Report message to a moderator

Re: Value for PATH environment variable [message #575497 is a reply to message #575495] Wed, 23 January 2013 12:05 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I got the desired output. Instead of using 2 different windows, one for command prompt and the other one for SQL Plus, this time I used the same window.

C:\Documents and Settings\Lakshmg3>set ORACLE_SID=content

C:\Documents and Settings\Lakshmg3>echo %ORACLE_SID%
content

C:\Documents and Settings\Lakshmg3>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 13:02:58 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
CONTENT

Thanks for the help.
Re: Value for PATH environment variable [message #575498 is a reply to message #575497] Wed, 23 January 2013 12:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 23 January 2013 19:05
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Why should we help someone that completely refuse to follow our rules?
If you are not part of our forum, we have no reason to help you.

Regards
Michel

Re: Value for PATH environment variable [message #575499 is a reply to message #575497] Wed, 23 January 2013 12:09 Go to previous message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Instead of using 2 different windows, one for command prompt and the other one for SQL Plus, this time I used the same window.


Really stupid.

Regards
Michel
Previous Topic: need hummingbird exceed software for windows?
Next Topic: OS
Goto Forum:
  


Current Time: Wed Oct 01 13:10:38 CDT 2014

Total time taken to generate the page: 0.11289 seconds