problems in setting SID/HOST/PORT

[Vasantha Prabha]

hi Iam working with weblogic 8.1
I want to set Oracle.SID/host and port in the Adimconsole
to lookup and use oracle.I have Oracle Enterprise Edition 8.1
How should I set this in my Oracle 8.1
Regards,
vasantha

[Mark Spritzler]

This isn't something you set up in Oracle, it is something that is in Oracle. Meaning where you put your Oracle database and name it is what creates the SID/Host/Port. If you have the Oracle client already installed on your machine, you can find out these values that you need to enter in the adminstration screen for the App Server, you go to ORACLE_HOME/network/admin and look at your tnsnames.ora file, this has all the entries to connect to the database.
Mark

[Mark Spritzler]

OH, if you can't figure out what you need form there, I highly suggest going to your DBA and ask him for that information.
Mark

[Vasantha Prabha]

Hi,
Iam using Oracle 8.i Enterprise server edition in windows XP.Can u please tell How should I set It??.
Regards,
vasantha

[Vasantha Prabha]

Hi,
I came accross tnsNames and found out number of names like
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
my Question is
In my database connection.Iam using
"jdbc racle:thin@:host ort:sid","scott","tiger"
for thin driver which protocol should I use?