Home » RDBMS Server » Server Administration » Login failed in Oracle 11g (11.2.0.2)
Login failed in Oracle 11g [message #517222] Sun, 24 July 2011 23:39 Go to next message
Yograjsharma
Messages: 3
Registered: July 2011
Location: Chandigarh
Junior Member
HI All
I have installed executable only (database option only)
when i have installed oracle11 that time it is not asking any option for password. So is there any option to login in this type of condition?

I am using this on windows server 2003.

Waiting for precious inputs.

Kind regards,

Sharma


[EDITED by LF: fixed topic title typo; was "racle"]

[Updated on: Mon, 25 July 2011 00:09] by Moderator

Report message to a moderator

Re: Login failed in racle 11g [message #517223 is a reply to message #517222] Sun, 24 July 2011 23:50 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

sqlplus
/ as sysdba
select * from v$version;
exit
Re: Login failed in racle 11g [message #517224 is a reply to message #517223] Sun, 24 July 2011 23:55 Go to previous messageGo to next message
Yograjsharma
Messages: 3
Registered: July 2011
Location: Chandigarh
Junior Member
C:\Documents and Settings\server>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Sun Jul 24 21:53:56 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
Re: Login failed in racle 11g [message #517225 is a reply to message #517224] Mon, 25 July 2011 00:13 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
Yograjsharma wrote on Sun, 24 July 2011 21:55
C:\Documents and Settings\server>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Sun Jul 24 21:53:56 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:


You obviously can't/won't/don't follow directions.

Throwing TNS error when not using "@REMOTE" indicates OS/Networking mis-configuration.

Is any type of Operating System Virtualization installed on this system.

Consult Installation Guide for proper instructions for Oracle installation.
Re: Login failed in racle 11g [message #517242 is a reply to message #517224] Mon, 25 July 2011 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you set ORACLE_SID?
Did you start the Oracle service?

Regards
Michel
Re: Login failed in racle 11g [message #517263 is a reply to message #517242] Mon, 25 July 2011 02:28 Go to previous messageGo to next message
Yograjsharma
Messages: 3
Registered: July 2011
Location: Chandigarh
Junior Member
yes both is done earlier.
Re: Login failed in racle 11g [message #517264 is a reply to message #517263] Mon, 25 July 2011 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you set them accordingly?
Do not just answer: "yes I did", SHOW us. Maybe you just think you did but you didn't or didn't do it appropriatly.

Regards
Michel

Re: Login failed in racle 11g [message #518520 is a reply to message #517264] Thu, 04 August 2011 06:08 Go to previous messageGo to next message
prejib
Messages: 121
Registered: March 2009
Location: India
Senior Member
I am also facing the same login problem from the client . I am able to the DB uisng @connectionstring but not able to login without @connectionstring . I have copied the same TNS Entry from the server and pasted in client machine. Please check the below steps
C:\>set ORACLE_SID=PHILIPDV

C:\>tnsping PHILIPDV

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 04-AUG-2011 16:21:25

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

Used parameter files:
E:\tools\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = PHILIPS-DB-STUB.wipro.com)(PORT = 1521))
 (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = philipdv.wipro.com)))
OK (10 msec)

C:\>sqlplus system/admin

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 4 16:21:57 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: system/admin@philipdv

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

SQL>


[Updated on: Thu, 04 August 2011 06:21] by Moderator

Report message to a moderator

Re: Login failed in racle 11g [message #518525 is a reply to message #518520] Thu, 04 August 2011 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't set ORACLE_SID.

Regards
Michel
Re: Login failed in racle 11g [message #518531 is a reply to message #518525] Thu, 04 August 2011 06:59 Go to previous messageGo to next message
prejib
Messages: 121
Registered: March 2009
Location: India
Senior Member
yes, I set ORACLE_SID. Please check the first line of the last posting
Re: Login failed in racle 11g [message #518533 is a reply to message #518531] Thu, 04 August 2011 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And did you set ORACLE_HOME?

Regards
Michel
Re: Login failed in racle 11g [message #518588 is a reply to message #518533] Thu, 04 August 2011 23:22 Go to previous messageGo to next message
prejib
Messages: 121
Registered: March 2009
Location: India
Senior Member
Yes I Set the below variables
C:\>set ORACLE_SID=PHILIPDV

C:\>echo %ORACLE_HOME%
E:\tools\oracle\product\11.2.0\dbhome_1

C:\>echo %TNS_ADMIN%
E:\tools\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

C:\>tnsping PHILIPDV

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 05-AUG-2
011 09:50:42

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

Used parameter files:
E:\tools\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = PHILIPS-
DB-STUB.wipro.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
AME = philipdv.wipro.com)))
OK (10 msec)

C:\>sqlplus system/admin

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 5 09:50:50 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: system/admin@philipdv

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

SQL>

Re: Login failed in racle 11g [message #518590 is a reply to message #518588] Thu, 04 August 2011 23:30 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
OS/Networking mis-configuration

can involve hostname resolution or lack thereof
Re: Login failed in racle 11g [message #518591 is a reply to message #518590] Thu, 04 August 2011 23:59 Go to previous messageGo to next message
prejib
Messages: 121
Registered: March 2009
Location: India
Senior Member
You mean the below one 

C:\>ping  PHILIPS-DB-STUB.wipro.com

Pinging PHILIPS-DB-STUB.wipro.com [10.222.6.138] with 32 bytes of data:

Reply from 10.222.6.138: bytes=32 time<1ms TTL=128
Reply from 10.222.6.138: bytes=32 time<1ms TTL=128
Reply from 10.222.6.138: bytes=32 time<1ms TTL=128
Reply from 10.222.6.138: bytes=32 time<1ms TTL=128

Ping statistics for 10.222.6.138:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms
Re: Login failed in racle 11g [message #518593 is a reply to message #518591] Fri, 05 August 2011 00:15 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
>ORA-12560: TNS:protocol adapter error
Oracle is too dumb to lie.
Such an error results when OS/Networking is mis-configured; regardless of what you post!
No "SQL*Net" error should be thrown when "@REMOTE" is not included.
Does any type of OS virtualization exist?
Re: Login failed in racle 11g [message #518602 is a reply to message #518593] Fri, 05 August 2011 00:52 Go to previous message
prejib
Messages: 121
Registered: March 2009
Location: India
Senior Member

Yes . The server is configured in the VMWARE Machineand

[Updated on: Fri, 05 August 2011 07:31]

Report message to a moderator

Previous Topic: Needs bit Info about RAC
Next Topic: select a table cause the session hang
Goto Forum:
  


Current Time: Sat Dec 20 18:05:07 CST 2014

Total time taken to generate the page: 0.07853 seconds