You seem to make a sport of not posting error messages.
How do you think anyone can help you out?
Please refrain from comments like
'doesn't work'
What doesn't work????
ERROR MESSAGES, PLEASE!!!
You seem also to make a sport of not reading documentation.
You should either use the SID (for *pre 8i* software)
or the *service_name* (parameter in init.ora, which defaults to the global
database name, which is db_name||'.'||db_domain)
You are inconsistent with respect to using domains,
in the o1 instance you use a domain in the global database name,
however you don't seem to use any domain for the other instances and you
don't use a names.default_domain in sqlnet.ora
How do you expect this is going to work????
Regards,
Sybrand Bakker, Senior Oracle DBA
"simon gu" <guxinhong_at_yahoo.com> wrote in message
news:ae637542.0110020621.680f5b8b_at_posting.google.com...
> I tried to trace the activity on the client side. however, no *.trc
> found in the specified directory. by the way my db server is win2000
> server. How to make tracing work on ora817 client?
>
> now this time, please focus on the instance o1.
> another oberservation is: If I use sql*net 8.05 client to connect to
> oracle817eent server, everything (tnsping, sqlpus, etc ) works ok
> using just SID instead of global_nameon the client side. So questions
> are still in the client side. I need to make ora817 client work
> concerning the version compatibilities down the road. where do I
> need to pay attention to this stuff?
>
>
> the two files are copies below. please comment.
>
> thanks.
>
> /********************sqlnet.ora**************************/
> # SQLNET.ORA Network Configuration File:
> C:\oracle\ora81\NETWORK\ADMIN\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> trace_level_client = 16
> trace_directory_client = C:\oracle\ora81\network\trace
> trace_unique_client = true
>
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
>
> SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf
>
>
>
>
>
>
>
/****************************listener.ora*********************************/
> # LISTENER.ORA Network Configuration File:
> c:\oracle\ora81\NETWORK\ADMIN\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = goldfinger)(PORT = 1521))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = goldfinger)(PORT = 2481))
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = c:\oracle\ora81)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = o1.goldfinger.syr.edu)
> (ORACLE_HOME = c:\oracle\ora81)
> (SID_NAME = o1)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = o2)
> (ORACLE_HOME = c:\oracle\ora81)
> (SID_NAME = o2)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = o3)
> (ORACLE_HOME = c:\oracle\ora81)
> (SID_NAME = o3)
> )
> )
>
>
>
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:<9p51t0$gmscl$1_at_ID-62141.news.dfncis.de>...
> > "simon gu" <guxinhong_at_yahoo.com> wrote in message
> > news:ae637542.0109290821.58160ca0_at_posting.google.com...
> > > hmmm, I tried both global_name, and ora8 compatible sid. Both still do
> > > not work. Should I pay any attention to the sqlnet.ora.
> > > I presume a client net8 app parses TNSnames.ora for oracle server
> > > connection info, any other files or configturation tool that I need to
> > > pay attention.
> > >
> > > help, help...
> > >
> > >
> > > "Van Messner" <vmessner_at_bestweb.net> wrote in message
> > news:<tr76d4btglu35f_at_corp.supernews.com>...
> > > > try using a qualified servicename in your tnsnames.ora instead of
that
> > sid
> > > >
> > > > "simon gu" <guxinhong_at_yahoo.com> wrote in message
> > > > news:ae637542.0109271305.41a7cb88_at_posting.google.com...
> > > > > Net Assistant test ok, but command line login does not
> > > > > work. connectivity problems
> > > > >
> > > > > hi, gurus,
> > > > >
> > > > > I could install ora817 client on win2000 pro. Using
> > > > > Net8 assistant, I could setupa servicing name, and
> > > > > test it just ok.
> > > > >
> > > > > however, it does not work on command line: sqlplus
> > > > > scott/tiger_at_o3. The Error is ORA_12154: TNS could not
> > > > > resolve service name.
> > > > >
> > > > > and also sqlplus will not connect to the servrer,
> > > > > using scott/tiger, host_string: o3. the same error
> > > > > message.
> > > > >
> > > > > The related 2 .ora files are print in part for
> > > > > refereces.
> > > > >
> > > > > please offer your suggestions and any hints. thanks
> > > > > in advance.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > tnsnames.ora --------------
> > > > > O3 =
> > > > > (DESCRIPTION =
> > > > > (ADDRESS_LIST =
> > > > > (ADDRESS = (PROTOCOL = TCP)(HOST =
> > > > > goldfinger)(PORT = 1521))
> > > > > )
> > > > > (CONNECT_DATA =
> > > > > (SID = o3)
> > > > > )
> > > > > )
> > > > >
> > > > >
> > > > > sqlnet.ora-----------------------------------
> > > > > #SQLNET.ORA Network Configuration File:
> > > > > C:\oracle\ora81\network\admin\sqlnet.ora
> > > > > # Generated by Oracle configuration tools.
> > > > >
> > > > > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> > > > >
> > > > > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
> >
> >
> > Pleaseb enable tracing.
> > Add to your sqlnet.ora
> >
> > trace_level_client = 16
> > trace_directory_client = <any sensible directory>
> > trace_unique_client = true
> >
> > Post : the resulting cli*.trc
> > Your *listener.ora*
> > Note: an unbalanced parenthesis on any location in tnsnames.ora will
result
> > in 12154.
> >
> >
> > And yes: I don't agree with Ban Spam there are various methods to
connect.
> > I do agree with him the 3 files have to match.
> >
> >
> > Hth,
> >
> > Sybrand Bakker, Senior Oracle DBA
Received on Tue Oct 02 2001 - 15:28:37 CDT
