Home » Other » General » login and password forgotten in oracle 10g
login and password forgotten in oracle 10g [message #605331] Wed, 08 January 2014 13:59 Go to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
Hi,

I forgot my parameters (login and password) that I had created during the installation of Oracle 10g.
Is it possible to find my parameters?


Cordially.
Re: login and password forgotten in oracle 10g [message #605336 is a reply to message #605331] Wed, 08 January 2014 14:06 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
Registered: May 2013
Location: World Wide on the Web
Senior Member
Not necessarily this would work, but you can try this :

1. Connect as sysdba
At sqlplus prompt, type : connect / as sysdba

2. Query dba_users.

Let me know what do you find.
Re: login and password forgotten in oracle 10g [message #605341 is a reply to message #605336] Wed, 08 January 2014 14:21 Go to previous messageGo to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
I tried with the command:
sqlplus "/as sysdba"

=> ora 12560 tns protocol adapter error
Re: login and password forgotten in oracle 10g [message #605346 is a reply to message #605341] Wed, 08 January 2014 14:48 Go to previous messageGo to next message
BlackSwan
Messages: 23157
Registered: January 2009
Senior Member
goldray wrote on Wed, 08 January 2014 12:21
I tried with the command:
sqlplus "/as sysdba"

=> ora 12560 tns protocol adapter error


This error occurs more frequently on Windows when compared to *NIX.

If Windows, are both OS Services for the listener & database are started & running?

Getting a TNS error when attempting to access a local database, indicates OS or networking mis-configuration.
Root cause & fix is external to Oracle.
Oracle is the victim; not the culprit.
Re: login and password forgotten in oracle 10g [message #605347 is a reply to message #605341] Wed, 08 January 2014 14:55 Go to previous messageGo to next message
Michel Cadot
Messages: 60010
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 Go to previous messageGo to next message
goldray
Messages: 104
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 #605351 is a reply to message #605346] Wed, 08 January 2014 15:31 Go to previous messageGo to next message
goldray
Messages: 104
Registered: December 2012
Senior Member

Quote:

This error occurs more frequently on Windows when compared to *NIX.

If Windows, are both OS Services for the listener & database are started & running?

Getting a TNS error when attempting to access a local database, indicates OS or networking mis-configuration.
Root cause & fix is external to Oracle.
Oracle is the victim; not the culprit.


Yes ,the Services for the listener & database are started & running
Re: login and password forgotten in oracle 10g [message #605354 is a reply to message #605351] Wed, 08 January 2014 15:42 Go to previous messageGo to next message
BlackSwan
Messages: 23157
Registered: January 2009
Senior Member
ECHO %ORACLE_SID%

above returns what results?
Re: login and password forgotten in oracle 10g [message #605355 is a reply to message #605354] Wed, 08 January 2014 16:02 Go to previous messageGo to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
BlackSwan wrote on Wed, 08 January 2014 15:42
ECHO %ORACLE_SID%

above returns what results?

return: CLRExtProc
Re: login and password forgotten in oracle 10g [message #605359 is a reply to message #605355] Wed, 08 January 2014 17:10 Go to previous messageGo to next message
BlackSwan
Messages: 23157
Registered: January 2009
Senior Member
It might work better after you do as below

SET ORACLE_SID=XE
sqlplus
/ as sysdba

then again, doing so might not change the error.
Re: login and password forgotten in oracle 10g [message #605377 is a reply to message #605349] Thu, 09 January 2014 00:55 Go to previous message
Michel Cadot
Messages: 60010
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.

Previous Topic: Tool for ER-Like Diagram
Next Topic: Error while stating Argus Database
Goto Forum:
  


Current Time: Sun Dec 21 06:37:33 CST 2014

Total time taken to generate the page: 0.09668 seconds