At first log in the server where oracle is installed using administrative account of the OS. Then set the ORACLE_SID user variable to the name of database service. So, if your database service name is orcl, then set the variable ORACLE_SID to value orcl. Then -
Log in sqlplus from command prompt of the server using the following command-
sqlplus "/as sysdba"
now you are connected.
Then you can change sys password by the following command-
alter user sys identified by *******;
Thus your password is reset. Now you can connect by any client s/w of oracle.
Saturday, September 12, 2009
Subscribe to:
Posts (Atom)