Can not connect to PO8i from Forms6i

[Sue Han]

Hi,

My PC is a NT named 'oracle'. I have first installed Forms6i in
DEFAULT_HOME, c:/orant.

PO8i is installed as:
Oracle Home: ora8i
Full Path: c:\orant\ora8i
Choose Typical Install
Global Database Name: ora8i.oracle.master.com.au
SID: ora8i

Then I added an entry in c:\orant\net80\admin\tnsnames.ora as:
test.world
(DESCRIPTION
(ADDRESS_LIST
(ADDRESS
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ora8i)
)
)

I can connect to PO8i from SQL*Plus using scott/tiger or
scott/tiger@ora8i.

When I tried to connect to PO8i from Forms6i using scott/tiger@test or
scott/tiger@ora8i. I got ORA-12154: TNS:could not resolve service name.

If I use scott/tiger@test from SQL*Plus, I got the same error.

If I use scott/tiger from Forms6i, I got ORA-12203: TNS:unable to
connect to destination.

Help please.

Sue

Sent via Deja.com http://www.deja.com/
Before you buy.

[Zekun Zou]

Try:

scott/ti...@test.world
If that working, you should modify/create the file:
\orant\net80\admin\sqlnet.ora
add line:
NAMES.DEFAULT_DOMAIN = world

good luck
Quinn

"Sue Han" <sue...@my-deja.com> wrote in message
news:8io51e$e8q$1...@nnrp1.deja.com...

[Sue Han]

Hi Quinn,

It is OK with 'test.world'. When I opened \orant\net80\admin\sqlnet.ora
, I can read it, but it has some non-printable characters. So I think
it is not a text file. How do I add a line

NAMES.DEFAULT_DOMAIN = world

Thank you.

Sue

In article <1eX35.2540$lE26.8...@news.xtra.co.nz>,

"Zekun Zou" <z....@paradise.net.nz> wrote:
> Try:
>
> scott/ti...@test.world
> If that working, you should modify/create the file:
> \orant\net80\admin\sqlnet.ora
> add line:
> NAMES.DEFAULT_DOMAIN = world
>
> good luck
> Quinn
>