|
|
|
|
Re: login and password forgotten in oracle 10g [message #605347 is a reply to message #605341] |
Wed, 08 January 2014 14:55 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Be sure that ORACLE_SID is set.
C:\>set ORACLE_SID=''
C:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mer. Janv. 8 21:54:49 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
C:\>set ORACLE_SID=MIKA
C:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mer. Janv. 8 21:56:07 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
***SYS***>
[Updated on: Wed, 08 January 2014 14:56] Report message to a moderator
|
|
|
Re: login and password forgotten in oracle 10g [message #605349 is a reply to message #605347] |
Wed, 08 January 2014 15:18 |
|
goldray
Messages: 108 Registered: December 2012
|
Senior Member |
|
|
I have to check the ORACLE_SID variable has changed in the file tsnnames.ora?
If so, the ORACLE_SID has not changed!
this the file tnsnames.ora:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mba-c1bf40b1cf4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
sqlnet.ora:
# sqlnet.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
[Updated on: Wed, 08 January 2014 15:22] Report message to a moderator
|
|
|
|
|
|
|
Re: login and password forgotten in oracle 10g [message #605377 is a reply to message #605349] |
Thu, 09 January 2014 00:55 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:I have to check the ORACLE_SID variable has changed in the file tsnnames.ora?
tnsnames.ora is not used when you connect "/ as sysdba".
It is your local environment variable like I showed in my previous post.
|
|
|