How to reset change SYS user password in Oracle Database

-

How to reset/change SYS user password in Oracle Database

Applies to:
            Oracle Enterprise Linux – Version: 7
            Oracle Database 11g

Description:
            I want to reset/change SYS user password in Oracle Database 11gR2.

Solution:
            You can reset/change SYS password by following simple steps:

Open a terminal and type the command
Sqlplus /nolog
SQL> connect / as sysdba

Once connected to the Database you can reset/change the SYS user password:

SQL> alter user sys identified by <new_password>;



Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ



Comments

Post a Comment

Popular posts from this blog

APPS Login Failed with error HTTP 404

-
APPS Login Failed with error HTTP 404             Applies to:             Oracle Enterprise Linux – Version: 7             Oracle EBS R12.1             Description: Oracle EBS Login page going to fail with error “The webpage cannot be found HTTP 404”. I have restart the services but the problem is same. All services started successfully. Error Log shows the following: $ LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/log.xml which reports: Internal error raised trying to instantiate web-application: html defined in web site OC4J 10g (10.1.3) Default Web Site. Error compiling :$COMMON_TOP/webapps/oacore/html: Error instantiating compiler: Web service artifact generation failed:java.lang.InstantiationException: IO Error reading WEB-INF/wsdl/wsr...
Read more

REP-0501 ORA-01017 unable to connect to the specified database

-
REP-0501 ORA-01017 unable to connect to the specified database Applies to:             Enterprise Linux Version 5.7             Database 11gR2             Oracle Forms/Reports 6i Description:             We have an in-house developed application on Oracle Form/Reports 6i with Oracle Database 9.2 32bit on Windows Server 2008 32bit. Application is working fine. I have assigned a task from my manager to upgrade the database and also migrate the database server on Linux. I have done all the activities successfully. After that, Application is working fine except reports. When I run any report from application the report engine log give me the following error: REP-0501: Unable to connect to the specified database. ORA-01017: invalid username/password...
Read more

How to Rebuild/Recreate Concurrent Manager

-
How to Rebuild/Recreate Concurrent Manager Applies to:             Oracle Applications – Version: 11.5.10.2 and above Description:             After cloning, concurrent manager unable to start successfully at 0 status. Solution:             Check the following solution on test environment before implement on production environment, rebuild concurrent manager using following steps: ·          Stop concurrent manager and wait to clear all processes of FNDLIBR or kill the processes ·          select * from fnd_concurrent_processes where process_status_code='A'; ·          update fnd_concurrent_processes set process_status_code='K' where process_status_code='A'; ·  ...
Read more