- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle upgrade from 8.1.5 to 8.1.7 caused connecti...
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
тАО03-11-2003 04:26 PM
тАО03-11-2003 04:26 PM
Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
Has any experienced this similar type of errors or does anyone have any suggestions for debugging?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 04:30 PM
тАО03-11-2003 04:30 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 04:33 PM
тАО03-11-2003 04:33 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
Are you running BOTH Oracle versions on the system simultaneously?
The standard listener port is 1521. Is the second instance using *another* listener port & that one's not defined in the firewall ruleset?
Check the tnsnames.ora file for the SID definitions to determine whether this might be the case.
HTH,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 04:35 PM
тАО03-11-2003 04:35 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 05:01 PM
тАО03-11-2003 05:01 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
I'm not a DBA, but I know that only the initial connection occurs on the 152x port & then client/server negotiate what higher port to conduct the rest of the session on.
You should have your DBA verify just *what* set of higher ports 8.1.7 is configured to use. It's also possible that you have a higher number of connections now & your firewall ruleset for these higher ports needs to be expanded to accomodate the higher connection count.
HTH,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 05:43 PM
тАО03-11-2003 05:43 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
Just to confirm its a firewall compatibility issue, were you able to connect the database from outside firewall, when the listener runs from 8.1.5 instead of 8.1.7 OH ? Does your firewall support sql*net ? if it doesn't then look at metalink post 125021.1 for further information as how to resolve this issue. Connection manager is what you need to look at.
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 07:46 PM
тАО03-11-2003 07:46 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
If I understand you correctly, this is an internal HP server that you are trying to connect to an external HP server through the firewall. If so, go ahead and contact me via email, or call me via telnet, and I will try to walk you through the most likely scenerio.
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 08:29 PM
тАО03-11-2003 08:29 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
"connect to our external boxes using 8.1.7"
From the above statement I assume that you are using HPUX as client.
Are you connecting to a database on Windows.
If that is the case then do u have the registry entries
USE_SHARED_SOCKET = TRUE
in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Else what is the value of the parameter CONNECT_TIMEOUT in the listener.ora file.
you should enable the tracing
Enable the listener tracing on the server
using
LSNRCTL> SET TRC_LEVEL 16
Also HPUX side in the sqlnet.ora enable the client level tracing using
TRACE_LEVEL_CLIENT=16
TRACE_DIRECTORY_CLIENT=
Also check the attachment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2003 08:40 PM
тАО03-11-2003 08:40 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
I think you'll find it doesn't.
You should be able to have multiple database instances with different ORACLE_HOME and ORACLE_SID listening on the same port.
I would suggest you post up your tnsnames.ora file and the results of tnsping with the two instances set in the ORACLE var's noted above.
I think you might find tnsping doesn't work and returns an error that will lead you to a solution.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-12-2003 09:14 PM
тАО03-12-2003 09:14 PM
Re: Oracle upgrade from 8.1.5 to 8.1.7 caused connectivity issues with Firewall
When ever you make change in the registry, config files, all running Oracle instances should be restarted and you need to restart the listener. Once you have started the instance, stop the listener and start the listener.
And one more thing after upgrdae did you update your listener.ora file with the new oracle_home for the SID upgraded.