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
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
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?
