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

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

APP-FND-01630, APP-FND-01662, cannot open .dbc file

-
Image
APP-FND-01630, APP-FND-01662, cannot open .dbc file Applies to: I am using:  Oracle Enterprise Linux 5.5 Oracle Application Install - Version: 11.5.10.0 and later Database 11gR1 Description: I recently came across a problem after creating repository for Enterprise Manager of 11g, and unable to login the oracle application, facing the following errors: Solution: Locate the .dbc file and issue read/write permissions on it: cd $FND_SECURE chmod 777 TEST.dbc Your comments, especially which will help us improve the functionality, will be greatly appreciated :)
Read more