|
|
|
|
Re: ORA-12505 [message #591010 is a reply to message #591008] |
Wed, 24 July 2013 07:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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 #591027 is a reply to message #591015] |
Wed, 24 July 2013 08:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
oracle@learner wrote on Wed, 24 July 2013 08:47i 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 #591049 is a reply to message #591048] |
Wed, 24 July 2013 09:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d841a5eba6f2e3f45dd881ce160f0c9?s=64&d=mm&r=g) |
oracle@learner
Messages: 73 Registered: October 2011
|
Member |
![vbintel%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 #591125 is a reply to message #591061] |
Wed, 24 July 2013 23:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d841a5eba6f2e3f45dd881ce160f0c9?s=64&d=mm&r=g) |
oracle@learner
Messages: 73 Registered: October 2011
|
Member |
![vbintel%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|
|