- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle tnsnames.ora
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-2006 02:56 AM
тАО01-24-2006 02:56 AM
Re: Oracle tnsnames.ora
Regard,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2006 08:28 PM
тАО01-24-2006 08:28 PM
Re: Oracle tnsnames.ora
if yes what are the values ?
TNS_ADMIN
and
TWO_TASK
Because if you run sqlplus /nolog
or connect / as sysdba you should
not use NET8 as the / implies
a local connect.
A remote connect would be like this
system/passwd@ORASERV.TEST01
So you get the ORA-12545 on a local
connect implies something else like
TWO_TASK is set wrong or something.
Regards,
Frank
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2006 08:49 PM
тАО01-24-2006 08:49 PM
Re: Oracle tnsnames.ora
Lanch SQL*Net Easy Configuration (it is normally installed with SQL*Plus) to configure the local (in the client) tnsnames.ora.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2006 08:52 PM
тАО01-24-2006 08:52 PM
Re: Oracle tnsnames.ora
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2006 11:50 PM
тАО01-24-2006 11:50 PM
Re: Oracle tnsnames.ora
Please try the following:
tnsping ORASERV.TEST01. Does that work?
Lookup in your sqlnet.ora what the value of your default_domain is (i.e. WORLD) and use that in your Oracle name. Thus, change 'ORASERV.TEST01 =' to TEST01.WORLD.
Check also that you can ping your oracle server (ping oraserv).
If you checked the above, you can also tnsping TEST01 and start an sqlplus session to it.
Please give some feedback, so we can help you out.
Cheers,
Renarios
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-24-2006 11:56 PM
тАО01-24-2006 11:56 PM
Re: Oracle tnsnames.ora
just for a test, can you try to connect as:
sqlplus
scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraserv)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=test01)))
(nb. if you don't have the scott schema, you can always substitute accordinlgy)
thanks
kind regards
yogeeraj
- « Previous
-
- 1
- 2
- Next »