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

How to Configure Tiger VNC Server on Linux 7

-
How to Configure Tiger VNC Server on Linux 7 Applies to:             Oracle Enterprise Linux – Version: 7 Description:             After successful installation of Oracle Linux 7, I need to configure VNC for remote access. Solution:             To configure Tiger VNC server on Oracle Linux 7 follow the simple steps:             To check the required rpm’s: [root@testora ~]# rpm –qa |grep tigervnc Install tigervnc-server [root@testora ~]# yum install tigervnc-server –y               To create a user for VNC: [root@testora ~]# adduser vncuser [root@testora ~]# passwd vncuser   [root@testora ~]# su - vncuser [vncuser@testora ~]$ vncpasswd Password: Verify: [vncuser@tes...
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