| Local connection of Forms client to Oracle 9i server [message #66921] |
Sat, 15 March 2003 05:33  |
Phil Hartley
Messages: 5
Registered: March 2003
|
Junior Member |
|
|
Oracle Network Gurus,
I’m an Oracle newbie trying to get Forms Builder working on my Win XP Pro box for a Database Systems assignment.
I did some tinkering so I have just done a fresh install of Oracle 9i and Forms Builder 6 on my XP box. I can connect to the server fine using sqlplus from the Oracle 9i install by omitting the connect_string. As shown here:
I:oracleora92bin>sqlplus hartley_p/*******
SQL*Plus: Release 9.2.0.1.0 - Production on Sat Mar 15 11:58:22 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>
But the sqlplus client from the Forms install gives me the below error:
SQL*Plus: Release 8.0.6.0.0 - Production on Sat Mar 15 12:03:01 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter user-name: hartley_p
ERROR:
ORA-12203: TNS:unable to connect to destination
Enter user-name:
And with Forms Builder, the client I really want to use, I get the same error with an empty ‘Database’ field. Where as starting Forms Builder with my 'sid.domain' in the database field I get an 'ORA-12154:TNS:Could not resolve service name' error.
There is obviously some configuration needed for local communication between the Forms client and the Oracle server, but being an Oracle newbie I’m floundering.
I’m sure this has been asked before but any help will be greatly appreciated.
Regards,
Phil Hartley.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
