Newbie: Forms Installation/Configuration problem
14/01/2018 11:47
Hi, I can successfully build a test form - it links to the database fine, so Ican create a single base table default form under scott/tiger.

It compiles succesfully. However, when I try to run I get: TNS-12560: TNS:protocol adapter error I have seen references to this error but with many causes, so I'm not surewhich configuration step I'm missing.

Perhaps if I describe what I did, the ommision may be obvious.

I'm working on a single stand-alone Windows XP pro machine running thelatest versions 10g of the database and developer.

I installed the enterprise database successfully to c:oracle with orahome =c:oracleproduct10.1.0Db_1, orahnam = OraDb10g_home1.

Sqlplus etc work fine.

I install developer to another directory c:oracleOraDS10g_home1 andorahome equals this with orahnam = OraDS10g_home1.

I installed jinit.exe.

I then start OC4J instance from the windows start menu under <FormsDeveloper> It states it is initialized.

I have done no other configuration at all.

I can build and compile the form as I described above using <Forms Builder>but when I try and run it I get the 12560 error.

When I start Oracle Net Manager and look at: <Listener><Other Services> I see Program name = extprog,SID=PLSExtProc,Oracle Home Directory = c:oracleOraDS10g_home1<Listener><Listening Locations> Host = localhost, Port=1521.

Scouring the web I have seen mention of tnsnames.ora so I include both thedatabase and developer directory versions below.

If any other info is required just let me know.

TIA for any help.

# tnsnames.ora Network Configuration File: C:oracleproduct10.1.0Db_1 etworkadmin nsnames.ora# Generated by Oracle configuration tools.

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) # TNSNAMES.ORA Network Configuration File: c:OracleOraDS10g_home1 etworkadmin nsnames.ora# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521)) ) (CONNECT_DATA = (SID = PLSExtProc) ) )

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
14/01/2018 11:47 - Could you expand, pehaps with the code? I'm sorry if I need spoon feedingbut I'm not confidentabout what changes to make.

I copied the database version of tnsnames.ora to overwrite the forms versionbut I still get the same 12560 error.

Thanks Daniel Morgan <damorgan@x.washington.edu> wrote in messagenews:1082645329.527167@yasure...

I

Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
14/01/2018 11:47 - Nowhere in this TNSNAMES is there a pointer to your database.


Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

Answer score: 5
14/01/2018 11:47 - The above TNSNAMES points to EXTPROC ... with SID PLSExtProc. Thatis not the connection alias or the SID for your database. So fireup the Net Configuration Assistant and fix it.


Source is Usenet: comp.databases.oracle.misc
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below