|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527028 is a reply to message #527022] |
Fri, 14 October 2011 09:41   |
 |
oracle@learner
Messages: 73
Registered: October 2011
|
Member |
|
|
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>sqlplus tiger/tiger@192.168.0.100:1521/ahpl
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 14 20:07:41 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12518: TNS:listener could not hand off client connection
Enter user-name: tiger
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
still not working. I am using window server 2008 R2 with oracle 11g. I am using oracle in server base to connect it.
[edit: I've added the [code] tags to make this readable, please do it yourself in future. JW]
[Updated on: Fri, 14 October 2011 10:08] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527037 is a reply to message #527033] |
Fri, 14 October 2011 10:19 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
First, vbintel, I notice that you have not yet said "thank you" to me or BS for assisting you. Please remember that we do not get paid for this.
It should now be clear to you that your problem is name resolution: your tnsnames file is wrong. We proved that, because when you used my syntax, you got a lot further. Having looked at your files, the problem is obvious, and it is NOT a problem that occured without you (or someone else) changing something.
In your first post, the output of your "lsnrctl status" command shows that the listener is listening for a database service called "ahppl". But your tnsnames alias is asking for a service called ORCLIMPL.
So you need to edit your tnsnames.ora file to specify
SERVICE_NAME=ahpl
and then you will get a bit further.
[Updated on: Fri, 14 October 2011 10:24] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527102 is a reply to message #527072] |
Sat, 15 October 2011 02:17 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
OK, I'll have one more go.
First: I told you exactly what was wrong with your tnsnames.ora file, did you make the change abd try again?
Second: I see that you are running lsnrctl from a 11.1.0.6 Oracle home, but then running SQL*Plus from a 10.2.0.1 Oracle home. This will complicate things, because SQL*Plus may well be using a different tnsnames.ora than the one you think you are using.
|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527105 is a reply to message #527103] |
Sat, 15 October 2011 02:31 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:But still not working. This is not an Oracle error message. You might as well say "I am ill. Please make me better". If you want help, you will need to read the Forum Guidelines (BS gave you the link in the first reply) and provide the necessary information. And please use the [code] tags when you copy/paste your SQL*Plus session.
And by the way, is the alert log exerpt you posted in your other topic correct? The entries date from three days ago.
|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527107 is a reply to message #527106] |
Sat, 15 October 2011 02:39 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote: I am not able to login sqlplus. This is not an Oracle error message. Think about it, man! How can anyone assist with this sort of information? You need to copy/paste what happened. You can do it, you did it before. And when you do, do not forget to format it with the [code] tags.
|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527111 is a reply to message #527108] |
Sat, 15 October 2011 02:56 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
OK, we have established a few things.
First, that you didn't use the [code] tages correctly. You need to place your text between them, not after them. I'll let you off this time, but not again.
Second, your listener is working correctly: the problen is further back.
Third, you have two Oracle homes installed, and you are running SQL*Plus from the wrong one. That isn't critical at the moment, but you need to think about it.
So what is the problem? The first possibility is that the Windows service for the database is not running. From a CMD prompt, try to start it:
net start OracleServiceAHPL
(I am guessing at the name of the Windows service, you can find it if you run the msconfig.exe utility)
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527112 is a reply to message #527111] |
Sat, 15 October 2011 03:02 |
|
oracle@learner
Messages: 73
Registered: October 2011
|
Member |
|
|
Thanks but not working
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Administrator.testing>net start OracleServiceAHPL
The service is not responding to the control function.
More help is available by typing NET HELPMSG 2186.
C:\Users\Administrator.testing>net start
These Windows services are started:
Application Management
Base Filtering Engine
Certificate Propagation
COM+ Event System
Cryptographic Services
DCOM Server Process Launcher
Desktop Window Manager Session Manager
DHCP Client
Diagnostic Policy Service
Distributed Transaction Coordinator
DNS Client
Group Policy Client
IIS Admin Service
IKE and AuthIP IPsec Keying Modules
IP Helper
IPsec Policy Agent
Kaspersky Anti-Virus 6.0
Kaspersky Lab Network Agent
Network Connections
Network List Service
Network Location Awareness
Network Store Interface Service
Oracle AHPL VSS Writer Service
OracleOraDb11g_home1TNSListener
Plug and Play
Pml Driver HPZ12
Power
Print Spooler
Remote Desktop Configuration
Remote Desktop Services
Remote Desktop Services UserMode Port Redirector
Remote Procedure Call (RPC)
Remote Registry
RPC Endpoint Mapper
Security Accounts Manager
Server
Shell Hardware Detection
Software Protection
SPP Notification Service
System Event Notification Service
Task Scheduler
TCP/IP NetBIOS Helper
User Profile Service
Windows Event Log
Windows Firewall
Windows Management Instrumentation
Windows Modules Installer
Windows Remote Management (WS-Management)
Windows Update
Workstation
The command completed successfully.
C:\Users\Administrator.testing>net start OracleServiceAHPL
The service is not responding to the control function.
More help is available by typing NET HELPMSG 2186.
C:\Users\Administrator.testing>
Is there no problem when changing from workgroup to domain and domain to workgroup.? What Step i have to follow now.
[Updated on: Sat, 15 October 2011 03:10] Report message to a moderator |
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527114 is a reply to message #527112] |
Sat, 15 October 2011 03:35 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
There are potentially massive problems with changing between domain/workgroup, because you will have messed up the security. I think you should re-create the Windows service. This is easy with the oradim.exe utility, but you MUST be connected to the correct Oracle home when you do it. To check that:c:\users\john\home>where oradim.exe
c:\app\john\product\11.2.0\dbhome_1\BIN\oradim.exe
oradim -delete -sid ahpl
oradim -new -sid ahpl -startmode manual
net start oracleserviceahpl
(please note that I'm guessing that the service is registered as a SID, not as a SRVC. The oradim utility has help that gives all the syntax.)
|
|
|
|
|
|
|
|
|
|
| Re: NOT ABLE TO CONNECT DATABASE [message #527120 is a reply to message #527118] |
Sat, 15 October 2011 05:06 |
|
oracle@learner
Messages: 73
Registered: October 2011
|
Member |
|
|
Please find the error below while running sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Oct 15 15:33:30 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: tiger
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
C:\Users\Administrator.testing>sqlplus tiger/tiger@ahpl
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 15 15:45:03 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
[Updated on: Sat, 15 October 2011 05:18] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
