Home » RDBMS Server » Enterprise Manager » NOT ABLE TO CONNECT DATABASE (Oracle,11, window server 2008 R2)
NOT ABLE TO CONNECT DATABASE [message #527009] Fri, 14 October 2011 07:34 Go to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

I am not able to connect database.

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 14-OCT-2011 17:48
:28

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.100)(PORT=1521
)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 14-OCT-2011 17:08:01
Uptime 0 days 0 hr. 40 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File d:\app\Administrator\product\11.1.0\db_1\network\admin
\listener.ora
Listener Log File d:\app\administrator\diag\tnslsnr\abc\listene
r\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.100)(PORT=1521)))
Services Summary...
Service "ahpl" has 1 instance(s).
Instance "ORCLIMPL", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully
---
# listener.ora Network Configuration File: d:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ahpl)
(SID_NAME = ORCLIMPL)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
)

---
# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

AHPL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCLIMPL)
)
)

----

When try to connect Oracle Net manager
Servicing name
not able to connect.
Please help.
Re: NOT ABLE TO CONNECT DATABASE [message #527020 is a reply to message #527009] Fri, 14 October 2011 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: NOT ABLE TO CONNECT DATABASE [message #527022 is a reply to message #527009] Fri, 14 October 2011 08:45 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Try this, from a CMD prompt:
sqlplus username/password@192.168.0.100:1521/ahpl

substituting any username/password you want to use.

[Updated on: Fri, 14 October 2011 08:46]

Report message to a moderator

Re: NOT ABLE TO CONNECT DATABASE [message #527028 is a reply to message #527022] Fri, 14 October 2011 09:41 Go to previous messageGo to next message
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 #527029 is a reply to message #527028] Fri, 14 October 2011 09:46 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

Please find the attached listener,tnsnames,sqlnet ora.
Before it was working fine. But few days back its showing this error.
  • Attachment: tnsnames.ora
    (Size: 0.35KB, Downloaded 1681 times)
Re: NOT ABLE TO CONNECT DATABASE [message #527030 is a reply to message #527029] Fri, 14 October 2011 09:47 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

please check it also
  • Attachment: listener.ora
    (Size: 0.38KB, Downloaded 1570 times)
Re: NOT ABLE TO CONNECT DATABASE [message #527031 is a reply to message #527029] Fri, 14 October 2011 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Before it was working fine. But few days back its showing this error.

What changed?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: NOT ABLE TO CONNECT DATABASE [message #527032 is a reply to message #527030] Fri, 14 October 2011 09:47 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

please check sqlnet
  • Attachment: sqlnet.ora
    (Size: 0.45KB, Downloaded 1608 times)
Re: NOT ABLE TO CONNECT DATABASE [message #527033 is a reply to message #527031] Fri, 14 October 2011 09:52 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

Nothing is change. Not able to connect the database. net Manager also not able to connect the service naming ora:12514 :TNS is not working.
Re: NOT ABLE TO CONNECT DATABASE [message #527034 is a reply to message #527033] Fri, 14 October 2011 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Nothing is change. Not able to connect the database. net Manager also not able to connect the service naming ora:12514 :TNS is not working.
Statement above is obviously WRONG since before it worked & now throwing errors.
Software does NOT spontaneously break.

Since Networking is involved, the basic assumption is that two distinct systems are involved.

For System1 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
For System2 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
Clarify which hostname is associated with DataBase (DB) Server system & which hostname with SQL Client.

From DB Server post content of listener.ora & sqlnet.ora (if either exist)
From DB Server post results from following commands
lsnrtcl status
lsnrctl service
sqlplus scott/tiger
Re: NOT ABLE TO CONNECT DATABASE [message #527037 is a reply to message #527033] Fri, 14 October 2011 10:19 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #527067 is a reply to message #527037] Fri, 14 October 2011 22:21 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

thanks a lots for your support. I always thanking you. I have change the server from workgroup to domain, again then domain to work-group. After that database was not able to connect.
Thanking you in advance.
Re: NOT ABLE TO CONNECT DATABASE [message #527069 is a reply to message #527067] Fri, 14 October 2011 22:25 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

Also oracle services is not able to start in services.msc
Re: NOT ABLE TO CONNECT DATABASE [message #527070 is a reply to message #527069] Fri, 14 October 2011 22:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
vbintel wrote on Fri, 14 October 2011 07:52

Nothing is change.


vbintel wrote on Fri, 14 October 2011 20:21
thanks a lots for your support. I always thanking you. I have change the server from workgroup to domain, again then domain to work-group. After that database was not able to connect.
Thanking you in advance.


vbintel wrote on Fri, 14 October 2011 20:25
Also oracle services is not able to start in services.msc


I can not believe anything more you post.
I won't waste my time trying to separate fact from fiction.
You're On Your Own (YOYO)!
Re: NOT ABLE TO CONNECT DATABASE [message #527072 is a reply to message #527037] Fri, 14 October 2011 22:55 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

What step I can follow now to correct it. It also not able to connect on Database Configuration Assistant. Configure Database option Database Name: AHPL
after enter username password
ORA-12560: TNS: Protocol adapter error


Thanks
VBINTEL

[Updated on: Fri, 14 October 2011 23:02]

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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #527103 is a reply to message #527102] Sat, 15 October 2011 02:24 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

Thanks for the reply.
yes , I have changed according to your suggestion.But still not working.
I want to add one point in previous message "
I am new in oracle I have installed Oracle in workgroup, while i workgroup it is working fine. But latter I have change the server from workgroup to domain. At that time Oracle was not working , not able to connect. After that I change the Domain to workgroup again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc "

Re: NOT ABLE TO CONNECT DATABASE [message #527105 is a reply to message #527103] Sat, 15 October 2011 02:31 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #527106 is a reply to message #527105] Sat, 15 October 2011 02:36 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

sir, I am not able to login sqlplus. Sorry for making you ill, I am brand-new here at orafaq.com first time for in oracle forum, if any mistake from my end I apologized for that.
I will follow the orafag procedure.
Re: NOT ABLE TO CONNECT DATABASE [message #527107 is a reply to message #527106] Sat, 15 October 2011 02:39 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #527108 is a reply to message #527107] Sat, 15 October 2011 02:42 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

I did nothing with Oracle. Only i have make change the server from workgroup to domain then domain to workgroup. After that all this was happen.

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:
Re: NOT ABLE TO CONNECT DATABASE [message #527111 is a reply to message #527108] Sat, 15 October 2011 02:56 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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
this shows that I am running the utility from my 11.2.0 home. Then remove, recreate, and try to start the service with
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 #527115 is a reply to message #527114] Sat, 15 October 2011 03:47 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

Thanks its working now for oracleserviceahpl. But still facing problem to connect the database.
Re: NOT ABLE TO CONNECT DATABASE [message #527117 is a reply to message #527115] Sat, 15 October 2011 04:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
But still facing problem to connect the database.
This is not an Oracle error message.
Re: NOT ABLE TO CONNECT DATABASE [message #527118 is a reply to message #527117] Sat, 15 October 2011 04:59 Go to previous messageGo to next message
oracle@learner
Messages: 73
Registered: October 2011
Member

What I have to do now. where the problem could be locate?
Re: NOT ABLE TO CONNECT DATABASE [message #527120 is a reply to message #527118] Sat, 15 October 2011 05:06 Go to previous messageGo to next message
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

Re: NOT ABLE TO CONNECT DATABASE [message #527126 is a reply to message #527120] Sat, 15 October 2011 06:22 Go to previous message
oracle@learner
Messages: 73
Registered: October 2011
Member


Thanks lots for your support , now it is working fine

SQL*Plus: Release 11.1.0.6.0 - Production on Sat Oct 15 16:46:47 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: tiger
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


Thanks a lots sir for precious time taken for me.
I will resume when there is problem arise.
Please closed the thread..
Previous Topic: OC4J Configuration issue. OC4J_DBConsole_ip_sid not found
Next Topic: Complete newbie question
Goto Forum:
  


Current Time: Thu Mar 28 15:34:07 CDT 2024