- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: connecting to ORACLE
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
тАО09-01-2001 05:21 AM
тАО09-01-2001 05:21 AM
connecting to ORACLE
When I try to connect to the ORACLE 7.3 database through SQLPLUS or through a PRO*C program it takes a long time, approx 15-20 seconds.
The OS is HPUX 11.0.
What could be the possible reasons?
Kapil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2001 12:04 PM
тАО09-01-2001 12:04 PM
Re: connecting to ORACLE
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x40865220af9bd5118ff10090279cd0f9,00.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2001 04:51 PM
тАО09-01-2001 04:51 PM
Re: connecting to ORACLE
This is almost certainly due to hostname resolution problems. The server must be able to resolve the client and vice versa. I would try to ping the server from the client by hostname and then repeat the process from the server to the client. I'll bet that there is a DNS lookup failure on one end or the other and it is then failing over to the hosts file or NIS.
Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2001 10:36 PM
тАО09-01-2001 10:36 PM
Re: connecting to ORACLE
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2001 12:03 PM
тАО09-03-2001 12:03 PM
Re: connecting to ORACLE
this could be name resolution problem on one or even
both boxes: client and/or server.
So, check the "tnsnames.ora" on the client, and the
"listener.ora" on the server, and "sqlnet.ora" on both
of them. If possible, you could change all hostnames
in there to plain ip-addresses, getting rid of name
resolution...
Be careful: if the files mentioned do exist in "/etc" and
in "$ORACLE_HOME/network/admin/" then only those
in "/etc" will be used!
HTH,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-04-2001 02:35 AM
тАО09-04-2001 02:35 AM
Re: connecting to ORACLE
did you try to set up
..../network/admin/protocol.ora
with
tcp.nodelay=true
????
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2001 04:28 AM
тАО09-05-2001 04:28 AM
Re: connecting to ORACLE
My client & server are running on the same UNIX m/c.
ie the PRO*C program which is trying to connect to ORACLE is running on the same UNIX m/c where ORACLE is running.
When I try to do a telnet connection from my local machine, there is no problem.
Also on the UNIX server /etc/hosts is getting used to find out the IP address from the hostname and it happens fast.
Any other checks I need to perform?
Kapil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2001 06:14 AM
тАО09-06-2001 06:14 AM
Re: connecting to ORACLE
There is no such file as "protocol.ora" at the moment in $ORACLE_HOME/network/admin.
How exactly do we set it up?
What is its purpose?
Kapil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2001 06:18 AM
тАО09-07-2001 06:18 AM
Re: connecting to ORACLE
I changed all hostnames to IP addresses but the situation is still the same.
What other checks do you recommend?
Kapil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-07-2001 07:06 AM
тАО09-07-2001 07:06 AM
Re: connecting to ORACLE
I think my wordings were technically incorrect.
Basically I am not using the Oracle client package to connect to the Oracle server.
I am already logged on to UNIX M/C through telnet and then I try to connect to the database through sqlplus or a PRO*C program.
What other checks do you recommend?
Kapil