- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Microsoft
- >
- Re: Failed to connect to Oracle DB.
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-21-2004 04:50 PM
тАО10-21-2004 04:50 PM
Failed to connect to Oracle DB.
I had a problem with the connections to Oracle DBs. The Oracle DB is installed in NT 4.0 server. The workstations (Win 98/Win 95) can login to the NT server and have read/write access to the directories contain the DB. Some workstations in the same network can login to the Oracle DBs but some can't. It prompted "Failed to connect to DB" while login. As checked, there is no Oracle client installed on the workstations. Only a shortcut to run the login from the folders which mapped from the server. Do you have any ideas how to solve this problem?
Thanks very much in advance.
Kenny.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2004 02:34 AM
тАО10-22-2004 02:34 AM
Re: Failed to connect to Oracle DB.
is the users asked a loginid & pwd and then it fails or once they open the shortcut which is mapped from teh server gives the error??
Ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2004 01:19 PM
тАО10-22-2004 01:19 PM
Re: Failed to connect to Oracle DB.
The users can open the shortcut and prompt for login. But when we type the the ID and pwd, it promted that error message. Do you have any ideas about this?
Thanks for your help.
Kenny.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2004 08:40 AM
тАО10-24-2004 08:40 AM
Re: Failed to connect to Oracle DB.
Usually oracle client will have a file named init.ora which has the information about the server name / ip address & the port to connect..
so check whether that file is there in the server share / in the client machine itself(may be u can check how it is there in the clients which are able to connect also..)
if both the client who is able to connect & not able to connect have the file in the same location..
then try ping from client to the server using the machine name & once again using the ip address..
then try telnet
by doing this test u should be able to figure out where is the issue..
Ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2004 04:33 AM
тАО10-25-2004 04:33 AM
Re: Failed to connect to Oracle DB.
Do they all have the same software installed?
What is the exact error message when they fail to connect?
Server error message/workstation error message from Event Viewer.
Jon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2004 03:45 PM
тАО10-25-2004 03:45 PM
Re: Failed to connect to Oracle DB.
What is the Oracle error message :-
Like ORA-12154: TNS:could not resolve service name OR something like that.
From your workstation can you ping to the server/workstation where the database is runing. If so can you tnsping as well.
This will work if the tnsnames.ora file located at $TNS_ADMIN directory will have the hostname, database name (SID_NAME)and the port number. If this is configured fien you should successfully tnsping with the name that you specified in the tnsnames.ora file.
Otherwise the error could be something to do with the wrong username or password.
if you provide the correct ORA error message then we can follow form there.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2004 02:26 PM
тАО10-26-2004 02:26 PM
Re: Failed to connect to Oracle DB.
All the workstations are running Win 95 with the same "Oracle for windows" running.
Do you have any idea how to solve the problem?
Thanks.
Kenny.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2004 09:28 AM
тАО10-27-2004 09:28 AM
Re: Failed to connect to Oracle DB.
That sounds like a client install was done on each workstation.
Also... What does "create the DB Alias to the DB." mean? Where are you creating this alias?
If you can use tnsping to ping the Oracle instance from each workstation, then you should be able to connect.
Jon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-31-2004 04:54 PM
тАО10-31-2004 04:54 PM
Re: Failed to connect to Oracle DB.
Thanks very much for your kindness help.
Kenny.