OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Erroor (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Erroor [message #376363]

Wed, 17 December 2008 02:08

jaccyboy
Messages: 19
Registered: December 2008

Junior Member

I've looked at older answers to this but wondered if anyone had any new answers as none of the previous ones seemes to work for me.

When i make my form and try to run it i get errors and i can't connect.
tns protocol, adaptor errors etc.

what do i need to do to the tns files to get the form showing on the web?

thanks in advance,

Jack

Report message to a moderator

Re: Erroor [message #376593 is a reply to message #376363]

Wed, 17 December 2008 23:59

Supernova11
Messages: 12
Registered: December 2008
Location: Indonesia

Junior Member

hi,

Maybe you can change the host configuration in tnsnanmes.ora
try change it into IP address of the db host server.

any way, can you give me examples your tnsnames configuration.

Report message to a moderator

Re: Erroor [message #376634 is a reply to message #376593]

Thu, 18 December 2008 02:22

jaccyboy
Messages: 19
Registered: December 2008

Junior Member

Hi,

This is my database tsnnames:

# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 146.191.195.86)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

And this is my developers suite tnsnames:

# tnsnames.ora Network Configuration File: F:\DevSuiteHome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 146.191.192.157)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

I've tried many things but nothing works. This is them back to their original states.

Thank you in advance,

Jack

Report message to a moderator