- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Have a question
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
тАО06-26-2003 06:45 AM
тАО06-26-2003 06:45 AM
Have a question
I have the following question: I am trying to connect to an Oracle database via ODBC and I get the following error message:
"internal error hostdef extension doesn't exist"
What do I have to do?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 06:49 AM
тАО06-26-2003 06:49 AM
Re: Have a question
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 06:49 AM
тАО06-26-2003 06:49 AM
Re: Have a question
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 06:56 AM
тАО06-26-2003 06:56 AM
Re: Have a question
Its actually not a default, out of the box configuration for oracle databases.
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
тАО06-26-2003 07:20 AM
тАО06-26-2003 07:20 AM
Re: Have a question
in order to access an Oracle RDBMS instance using ODBC you will usually have to go through the following steps:
- install/configure "SQL*Net" ("Net8" / "Net9") on the server to grant access over the network (the config file is "$ORACLE_HOME/network/admin/listener.ora")
- install/configure "SQL*Net" ("Net8" / "Net9") on the client station (the one where you want to use it over ODBC) (the config file is "$ORACLE_HOME/network/admin/tnsnames.ora")
- test wether the connectivity really works - from the client (e.g. "tnsping CONNECTSTRING" or "sqlplus USER/PASSWORD@CONNECTSTRING" where CONNECTSTRING is what you have defined in "tnsnames.ora")
- configure your ODBC using the Control Panel->ODBC Admin. Go for "System DSN", select the "Oracle" driver, and fill in the CONNECTSTRING and such)
- test it with the Oracle-supplied tool "odbctest"
FWIW,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 07:36 AM
тАО06-26-2003 07:36 AM
Re: Have a question
The hostdef extension refers to the structures used to maintain the client/server communication channel. The ORA-1401 is usually reported when a connection has broken for some reason. Check for any additional errors in the database alert log.
If you do not find a server-side error logged in the database alert log and/or no associated trace file in the user_dump_dest, this is most likely a network connectivity issue. In this case it would be best to check your network logs.
Post them if possible.
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 07:50 AM
тАО06-26-2003 07:50 AM
Re: Have a question
database which is usually preceeded by ORA-3113: End of file on communications channel. These errors are after effects of the original problem which terminated the connection. This is often caused by an unhandled exception (ORA-7445 - core dump) in the server process or by networking problems. There can be other causes, however which would be specific to the application.
Are there errors in the alert.log or trace files in the user_dump_dest directory? You should check the networking logs for any information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 03:24 PM
тАО06-26-2003 03:24 PM
Re: Have a question
Looks like some connection problem or some
permission, check with your DBA about maybe
he know the reason for this.
Caesar