Re: HOW TO SET DEFAULT SERVICE NAME.???????????

What is in your tnsnames.ora file on the client and the listener.ora on the server? - without seeing more info, it is hard to solve your problem

Here is more info on your underlying error :

ORA-12203
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORA-12203TNS:Unable to connect to destination

Cause:Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Action:Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.

"Ivan V Canalejo" <ivan_at_ats-corp.com> wrote:

>Hi comunity.
>Do any one knows how can I set the default service name with a method
>different than using the environment variable TWO_TASK
>
>Thanks,
>Ivan.
>
>I'm using forms 6i and in one of the clients it always give me the following
>error.
>
>***********************************************************************
>
>Fatal NI connect error 12203, connecting to:
>
>(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o
>racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON
>NECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\orant\BIN\ifrun60.EXE)(HOST=WS04)(USER=
>ora))))
>
>VERSION INFORMATION:
>
>TNS for 32-bit Windows: Version 8.0.6.0.0 -
>
>Production
>
>Oracle Bequeath NT Protocol Adapter for 32-bit
>
>Windows: Version 8.0.6.0.0 - Production
>
>Time: 12-JUL-01 16:43:32
>
>Tracing not turned on.
>
>Tns error struct:
>
>nr err code: 12203
>
>TNS-12203: TNS:unable to connect to destination
>
>ns main err code: 12560
>
>TNS-12560: TNS:protocol adapter error
>
>ns secondary err code: 0
>
>nt main err code: 530
>
>TNS-00530: Protocol adapter error
>
>nt secondary err code: 0
>
>nt OS err code: 0
>
>
>
>AND I'm trying to use a defined TCP/IP service ("service1") to connect to
>the server.
>
>Please any help is appreciated.!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
>
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jul 13 2001 - 08:42:00 CDT