- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Forte Application Environment. Oracle 7.3.4 Cl...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 03:15 AM
тАО01-24-2003 03:15 AM
Forte Application Environment. Oracle 7.3.4 Client. ORA-12154
I'm installing "Forte Application Environment 3.0" against Oracle 8.1.7 Database using Oracle 7.3.4 Client (Oracle 7.3.4 Client is in the specifications).
When i connect the engine I have next error "ORA-12154: TNS:could not resolve service name".
tnsping (v.7.3.4) works ok and connect to the database, so tnsnames.ora is ok (i think so)
I've a workarround used in other systems, it's to deinstall PHCO_24148 patch (libc acumulative patch HPUX 11.0).
I'm installing a new system HPUX 11.0 64bits with September 2002 Patch bundle and when I deinstall this patch i can't login with the machine because dependencies, so i have to install the patch again.
Anything about this error?
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 03:56 AM
тАО01-24-2003 03:56 AM
Re: Forte Application Environment. Oracle 7.3.4 Client. ORA-12154
2) TNSPING is one thing , have you tried SQLPLUS ? Are you sure of the location of the tnsnames.ora ?
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 04:01 AM
тАО01-24-2003 04:01 AM
Re: Forte Application Environment. Oracle 7.3.4 Client. ORA-12154
Please post your tnsnames.ora file.
Fast
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 04:05 AM
тАО01-24-2003 04:05 AM
Re: Forte Application Environment. Oracle 7.3.4 Client. ORA-12154
1. check if you can connect using sqlplus
2. Check for the NAMES.DEFAULT_DOMAIN parameter in the SQLNET.ORA file. If one exist, then the service_names entries in your TNSNAMES.ORA file must have the NAMES.DEFAULT_DOMAIN extension.
If problem persists, enable tracing in the SQLNET.ORA file:
trace_level_client=16
Try connecting with tracing enabled to generate a trace file. Review the trace file. Towards the end of the trace file, the service_name is being translated for resolution. See if this is the location and what is expected.
I had a similar problem some times agao. It was a sqlnet.ora setting. I had names.directory_path = (TNSNAMES, HOSTNAME) instead of names.directory_path = (TNSNAMES)
hope this helps!
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 04:09 AM
тАО01-24-2003 04:09 AM
Re: Forte Application Environment. Oracle 7.3.4 Client. ORA-12154
Forte Application is on the same machine, sqlplus runs ok, i can connect with the database using sqlplus included in the Oracle 7.3.4 client.
I send you my tnsnames.ora.
I'm trying to connect to SPS.WORLD database.
I can connect using next command:
sqlplus user/password@SPS.WORLD
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2003 04:31 AM
тАО01-24-2003 04:31 AM
Re: Forte Application Environment. Oracle 7.3.4 Client. ORA-12154
SPS =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL= TCP)
(Host= 172.16.4.24)
(Port= 1521))
(CONNECT_DATA = (SID = SPS))
)
SGG =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL= TCP)
(Host= 172.16.4.24)
(Port= 1521))
(CONNECT_DATA = (SID = SGG))
)
Remove the .WORLD from the tnsnames.ora file and now check connecting it.
Revert!!fast!!!