RE: Oracle for Windows XP with INTEL inside

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Mon, 20 Sep 2004 17:15:26 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401677BCC@antares.bcsgroup.com.sg>

Hi all,
I am so confuse now, I am able to connect to my database without a listener and not even set the Oracle_SID variable.

I show you my log... I don't even have ORACLE_SID

C:\>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Sinardy Xing\Application Data CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=SINARDY
ComSpec=C:\WINDOWS\system32\cmd.exe
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Sinardy Xing JSERV=C:\oracle\ora92/Apache/Jserv/conf
LOGONSERVER=\\SINARDY
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\ Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\ Program Files\Common Files\Ulead Systems\MPEG PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 7, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0207

ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\SINARD~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\SINARD~1\LOCALS~1\Temp
USERDOMAIN=SINARDY
USERNAME=Sinardy Xing
USERPROFILE=C:\Documents and Settings\Sinardy Xing windir=C:\WINDOWS
WV_GATEWAY_CFG=C:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app

C:\>sqlplus sinardy/vancouver

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Sep 20 17:05:56 2004

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------

canada OPEN

SQL>

If let say I have other instances namely ITALY and INDONESIA, how I connect to ITALY?

Please help me

Unix and Windows are so diffrent...

thanks,

Sinardy

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 20 2004 - 04:11:26 CDT