- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 10
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
тАО10-08-2007 01:22 AM
тАО10-08-2007 01:22 AM
Oracle 10
Getting the following error message when setting up backup config for DP & SAP R/3 integration.
"ORA-12154" - SP2_0640 & that the TNS Lstner is not running.
The errors details says to run a tnsping of SID.
I run that and it connect.
I've noticed that Data Protector is using server.host.com & that the tnsnames.ora files have the the host listed as just server.
Should these two match and is this is what is causing the error?
Cheers
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 01:49 AM
тАО10-08-2007 01:49 AM
Re: Oracle 10
so adapt your tnsnames.ora (http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/tnsnames.htm#NETRF007) with server.host.com.
and have a look at the sqlnet.ora (http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#NETRF006) file for this line.
NAMES.DEFAULT_DOMAIN = host.com
hope this helps
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 01:55 AM
тАО10-08-2007 01:55 AM
Re: Oracle 10
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 03:30 AM
тАО10-08-2007 03:30 AM
Re: Oracle 10
ORA-12154: TNS:could not resolve service name
Cause: Oracle Net could not locate the net service name specified in the
tnsnames.ora configuration file.
Action: Perform these steps:
1)Verify that a tnsnames.ora file exists.
2) Verify that there are not multiple copies of the tnsnames.ora file.
3) In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor.
4) Verify that there are no duplicate copies of the sqlnet.ora file.
5) If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain name in your connect string.
6)If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out.
7)If you are connecting from a login dialog box, verify that you are not placing an "@" symbol before your connect net service name.
8)Activate client tracing and repeat the operation.
WK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-08-2007 07:38 AM
тАО10-08-2007 07:38 AM
Re: Oracle 10
Check how you resolve in both HPUX and DNS (if it's on another platform)
Do full dns resolve lookups.
nslookup server.host.com
nslookup IP
nslookup server
Repeat above and add for DNS:
nslookup server.host.com
If your 'server' was set up as the alias in DNS then you should be able to resolve using just the server.
...very possible if DNS is run from somewhere else than HPUX, then you may find when they never bothered to put in the alias (server name).
A habit they forget here, till they are reminded..
Just a thought,
Rita