Re: SQLPlus & TNSListener

From: (wrong string) édric <cedric.malderez_at_answork.com>
Date: Thu, 11 Sep 2003 09:31:01 +0200
Message-ID: <3f602488$0$2773$626a54ce_at_news.free.fr>


You were right .. It works perfectly

Thanks again :)

"Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> a écrit dans le message de news:sUC7b.7131$D82.2353_at_bignews6.bellsouth.net...
> Forgot, also the sqlnet.ora might have a default domain and this would
cause
> problems the way you have the tnsnames.ora coded.
>
> At least temporarily rename the sqlnet.ora file to something else and try
> again.
>
> --
> "Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message
> news:6RC7b.7129$D82.3564_at_bignews6.bellsouth.net...
> > I am in a hurry right now, but I seem to recall the SERVER=DEDICATED
might
> > be a problem.
> >
> > Edit and remove that line from the tnsnames.ora and try again.
> >
> > --
> > "Malderez Cédric" <cedric.malderez_at_answork.com> wrote in message
> > news:3f5ed59a$0$13273$626a54ce_at_news.free.fr...
> > > > Are you doing tests while logged onto the server?
> > > >
> > > Yes, I'm using a local domain account with administrator rights
> > >
> > > > Are you doing tests while logged onto another machine/client-pc and
> does
> > > it
> > > > have the correct tnsnames.ora file?
> > > >
> > > I've tried running the client on an other computer. Using the
DBAStudio,
> > > I've added BASE1 in the Database list.
> > > I've never touch the tnsnames.ora file directly
> > >
> > > > Can you ping (using TCP/IP ping command) the server from the
> client-pc?
> > > >
> > > Yes, the network is working well
> > >
> > > > Can you tnsping the databases ? Of course, sqlplus is the
> real/ultimate
> > > test
> > > > if you have complete connectivity, but it could be useful info if
you
> > have
> > > > good test with tnsping and not good tests with sqlplus.
> > > >
> > > I've tried the following command line "tnsping BASE1". It seems to be
> > > working
> > > Here is the dump:
> > > > D:\oracle\ora81\bin>tnsping TSEDF
> > > > TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production
on
> > > 10-SEP-2003 09:01:33
> > > > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> > > > Attempting to contact
> > > (ADDRESS=(PROTOCOL=TCP)(HOST=172.31.0.17)(PORT=1521))
> > > > OK (30 msec)
> > >
> > > > Do you have any other *.ora files in the directory where you store
the
> > > > tnsnames.ora (other than listener.ora on the server)? Or, do you
have
> > any
> > > > *.ora files anywhere else on the client-pc or server?
> > > In the D:\oracle\ora81\network\admin I have the following files:
> > > - listener.ora
> > > - snmp_ro.ora
> > > - snmp_rw.ora
> > > - sqlnet.ora
> > > - tnsnames.ora
> > >
> > > > Are you mistakenly pointing to another location for tnsnames.ora
other
> > > than
> > > > the default? Do you have any TNS_ADMIN entries in the registry? Do
you
> > > have
> > > > any environment variable named TNS_ADMIN? Is your tnsnames.ora
stored
> in
> > > the
> > > > default location (ORACLE_HOME\network\admin)?
> > > >
> > > I don't have any TNS_ADMIN env set
> > > When I'v used DBAStudio in order to add a new database in the list,
the
> > > ORACLE_HOME\network\admin\tnsnames.ora was modified
> > >
> > > > Include the listener.ora and tnsnames.ora files (and other *.ora
> files)
> > in
> > > > your reply if possible. If the tnsnames.ora is large, then maybe
just
> > > > cut/paste the databases you are having problems with.
> > > >
> > > Here is the listener.ora file
> > > # LISTENER.ORA Network Configuration File:
> > > D:\oracle\ora81\network\admin\listener.ora
> > > # Generated by Oracle configuration tools.
> > >
> > > LISTENER =
> > > (DESCRIPTION_LIST =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > > )
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > )
> > > (DESCRIPTION =
> > > (PROTOCOL_STACK =
> > > (PRESENTATION = GIOP)
> > > (SESSION = RAW)
> > > )
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 2481))
> > > )
> > > )
> > >
> > > SID_LIST_LISTENER =
> > > (SID_LIST =
> > > (SID_DESC =
> > > (SID_NAME = PLSExtProc)
> > > (ORACLE_HOME = D:\oracle\ora81)
> > > (PROGRAM = extproc)
> > > )
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = BASE1)
> > > (ORACLE_HOME = D:\oracle\ora81)
> > > (SID_NAME = BASE1)
> > > )
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = BASE2)
> > > (ORACLE_HOME = D:\oracle\ora81)
> > > (SID_NAME = BASE2)
> > > )
> > > )
> > >
> > > And here is the tnsnames.ora file:
> > > # TNSNAMES.ORA Network Configuration File:
> > > D:\oracle\ora81\network\admin\tnsnames.ora
> > > # Generated by Oracle configuration tools.
> > >
> > > BASE2 =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SID = BASE2)
> > > (SERVER = DEDICATED)
> > > )
> > > )
> > >
> > > BASE1 =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SID = BASE1)
> > > (SERVER = DEDICATED)
> > > )
> > > )
> > >
> > > ####################################
> > > # Date..........: Tue Sep 09 15:14:29 CEST 2003
> > > ####################################
> > >
> > > INST1_HTTP =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SERVER = SHARED)
> > > (SERVICE_NAME = BASE2)
> > > (PRESENTATION = http://admin)
> > > )
> > > )
> > >
> > > EXTPROC_CONNECTION_DATA =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > > )
> > > (CONNECT_DATA =
> > > (SID = PLSExtProc)
> > > (PRESENTATION = RO)
> > > )
> > > )
> > >
> > > Thanks for your help :)
> > >
> > >
> >
> >
>
>
Received on Thu Sep 11 2003 - 09:31:01 CEST

Original text of this message