Home » RDBMS Server » Server Administration » ORA-12505 (Window Server 2008 R2 Enterprise)
ORA-12505 [message #590986] Wed, 24 July 2013 07:23 Go to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Hi , I need help!!

I am using oracle 11g in window server 2008 R2 enterprise under WORKGROUP. And it was working fine.
But after changing it from WORKGROUP to DOMAIN not able to connect it.

Its comes as
ORA-12505:TNS:listener does not currently know of SID given in connect description


Please help!!

Many Thanks..
Re: ORA-12505 [message #590998 is a reply to message #590986] Wed, 24 July 2013 07:34 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
WORKGROUP and DOMAIN are what exactly?
Re: ORA-12505 [message #591002 is a reply to message #590986] Wed, 24 July 2013 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: ORA-12505 [message #591008 is a reply to message #590998] Wed, 24 July 2013 07:44 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

before it was WORKGROUP , now it is DOMAIN

THANKS>
Re: ORA-12505 [message #591010 is a reply to message #591008] Wed, 24 July 2013 07:45 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
what was WORKGROUP?

We are not psychic, we don't know what you have, what you've done or what you've changed.
Re: ORA-12505 [message #591013 is a reply to message #591002] Wed, 24 July 2013 07:45 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Thanks!!
can please provide the location below :

Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.


Re: ORA-12505 [message #591015 is a reply to message #591010] Wed, 24 July 2013 07:47 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

i have upgraded it to DNS server from Workgroup.

Thanks
Re: ORA-12505 [message #591022 is a reply to message #591015] Wed, 24 July 2013 07:53 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

I have test tnsping ahpl and got below details
C:\Users\Administrator.tiger>

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 24-JUL-2
013 18:32:49

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
E:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Users\Administrator.tiger>


Many thanks..
Re: ORA-12505 [message #591026 is a reply to message #591015] Wed, 24 July 2013 08:08 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Please HELP!!!!!!
Re: ORA-12505 [message #591027 is a reply to message #591015] Wed, 24 July 2013 08:09 Go to previous messageGo to next message
joy_division
Messages: 4527
Registered: February 2005
Location: East Coast USA
Senior Member
oracle@learner wrote on Wed, 24 July 2013 08:47
i have upgraded it to DNS server from Workgroup.


Upgraded what, your shoe, your car? What is it as you have been asked before. Do you not understand? Maybe you don't because we do not.
Re: ORA-12505 [message #591029 is a reply to message #591027] Wed, 24 July 2013 08:16 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

migrate from Workgroup network model to Domain based model.

After migration , its not working.

Thanks
Re: ORA-12505 [message #591035 is a reply to message #591029] Wed, 24 July 2013 08:29 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

When I tried below this
C:\Users\Administrator.tiger>oradim -delete -sid ahpl
The Oracle ahpl VSS Writer Service service is stopping.
The Oracle ahpl VSS Writer Service service was stopped successfully.

Instance deleted.

C:\Users\Administrator.tiger>oradim -new -sid ahpl -startupmode manual
DIM-00040: Invalid option for the -NEW command.

C:\Users\Administrator.tiger>oradim -new -sid ahpl -startmode manual
Instance created.
The Oracle ahpl VSS Writer Service service is starting.
The Oracle ahpl VSS Writer Service service was started successfully.

this error has pop up
DIM-00019: create service error
O/S-Error: (OS 1388) A new member could not be added to a local group because th
e member has the wrong account type.

C:\Users\Administrator.tiger>

Re: ORA-12505 [message #591038 is a reply to message #591022] Wed, 24 July 2013 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-03505: Failed to resolve name
 *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
          an Oracle Names server, or a native naming service.
 *Action: Verify that you entered the service name correctly.  You may need
          to ensure that the name was entered correctly into the network
          configuration.

Regards
Michel
Re: ORA-12505 [message #591040 is a reply to message #591035] Wed, 24 July 2013 08:32 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

if i am not wrong the error is due to the domain controller is installed on the windows server 2008 ?

Many thanks
Re: ORA-12505 [message #591041 is a reply to message #591035] Wed, 24 July 2013 08:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
O/S-Error: (OS 1388) A new member could not be added to a local group because the member has the wrong account type.


Search on the web for this, this is NOT Oracle, this is OS.

Regards
Michel
Re: ORA-12505 [message #591044 is a reply to message #591041] Wed, 24 July 2013 09:03 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

i have received below error
ORA-01031:Insufficient Privileges
Re: ORA-12505 [message #591045 is a reply to message #591044] Wed, 24 July 2013 09:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Doing what?

ALWAYS copy and paste ALL what you do and get.
Copy and paste in TEXT mode, INLINE (no image, no attachment), and FORMATTED.

Regards
Michel
Re: ORA-12505 [message #591047 is a reply to message #591045] Wed, 24 July 2013 09:11 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

When i try to connect DBA from DCA this error has comes up..

ORA-01031:Insufficient Privileges


Thanks
Re: ORA-12505 [message #591048 is a reply to message #591047] Wed, 24 July 2013 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>When i try to connect DBA from DCA this error has comes up..

what is "DCA"?
Re: ORA-12505 [message #591049 is a reply to message #591048] Wed, 24 July 2013 09:36 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Database Configuration Assistant.
I have tied below command also..
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator.tiger>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 24-JUL-2013 19:59
:05

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=AYURTRAINING)(PORT=1521)
))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date                24-JUL-2013 19:33:22
Uptime                    0 days 0 hr. 26 min. 5 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\AYURTRAINING\listene
r\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tiger)(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

C:\Users\Administrator.tiger>sqlplus user/password@192.168.0.100:
1521/ahpl

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 24 19:59:58 2013

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

ERROR:
ORA-12518: TNS:listener could not hand off client connection


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\Administrator.tiger>net start OracleServiceAHPL
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.


C:\Users\Administrator.tiger>where oradim.exe
d:\app\Administrator\product\11.1.0\db_1\BIN\oradim.exe

C:\Users\Administrator.tiger>sqlplus user/password@ahpl

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 24 20:05:13 2013

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

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name: user
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\Administrator.tiger>oradim -delete -sid ahpl
The Oracle ahpl VSS Writer Service service is stopping.
The Oracle ahpl VSS Writer Service service was stopped successfully.

Instance deleted.

C:\Users\Administrator.tiger>oradim -new -sid ahpl -startmode manual
Instance created.
The Oracle ahpl VSS Writer Service service is starting.
The Oracle ahpl VSS Writer Service service was started successfully.


C:\Users\Administrator.tiger>net start oracleserviceahpl
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.


C:\Users\Administrator.tiger>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 24 20:10:36 2013

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

Enter user-name: user
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:

[Updated on: Wed, 24 July 2013 09:43]

Report message to a moderator

Re: ORA-12505 [message #591051 is a reply to message #591049] Wed, 24 July 2013 09:47 Go to previous messageGo to next message
John Watson
Messages: 4672
Registered: January 2010
Location: Global Village
Senior Member
I'll try. I'm not any sort of Windows expert, but I have hit similar issues. I think you have changed your Windows security model from local authentication by your server, as part of a workgroup, to authentication against a Windows domain controler. That means all your user ids have changed. That, in turn, means that you may have broken all the Oracle services in that machine and certainly the operating system authentication method that Oracle uses is broken.
Probably the easiest way out is to remove all the Oracle services, de-install your Oracle home, install another Oracle Home which will pick up the current security characteristics, create a new listener off the new home, and run oradim from the new home to re-create the database service pointing to the existing spfile. This doesn't take long (half an hour max).
Re: ORA-12505 [message #591061 is a reply to message #591049] Wed, 24 July 2013 10:31 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

This problem is second time. Last time it was happen same. And solve with forum team..


Please suggest what step to follow next.

Many thanks...
Re: ORA-12505 [message #591125 is a reply to message #591061] Wed, 24 July 2013 23:37 Go to previous messageGo to next message
oracle@learner
Messages: 67
Registered: October 2011
Member

Thank you forum for support..

Thanks again Michel and Blackswan!!!!!

Finally i am able to connected to DB. by below step.

open DBCA > SELECT Configure Database option > then it will show you Database name AHPL . Just put user sys and <password>. After that its working fine.

THANKS AGAIN!!!!!!!

[Updated on: Wed, 24 July 2013 23:42]

Report message to a moderator

Re: ORA-12505 [message #591126 is a reply to message #591125] Thu, 25 July 2013 00:11 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: Installation Oracle Grid Infrastructure 11gR2 when Oracle Enterprise finished
Next Topic: Increase RAM for Oracle 9i
Goto Forum:
  


Current Time: Mon Oct 20 23:34:56 CDT 2014

Total time taken to generate the page: 0.10122 seconds