Login failed in Oracle 11g [message #517222] |
Sun, 24 July 2011 23:39 |
|
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 #518520 is a reply to message #517264] |
Thu, 04 August 2011 06:08 |
prejib
Messages: 126 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 #518588 is a reply to message #518533] |
Thu, 04 August 2011 23:22 |
prejib
Messages: 126 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 #518591 is a reply to message #518590] |
Thu, 04 August 2011 23:59 |
prejib
Messages: 126 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
|
|
|
|
|