Oracle   Home  

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI

Oracle Applications EBS 11i, R12

 Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Database Administration (DBA)  >  Maintenance  >  SYSTEM can change SYS password

 

Oracle Database 10g Administration (DBA): Maintenance

SYSTEM can change SYS password

 

 

Here is a demonstration how system can change the sys password :

 

 

 

 

Note: This may not work on some environments: that depends on the DB configuration.

 

 

SQL> conn system/sys123
Connected.
SQL> col name format a30
SQL> col value format a20
SQL> select name, value from v$parameter where name='remote_login_passwordfile';

NAME VALUE
------------------------------ --------------------
remote_login_passwordfile EXCLUSIVE

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> show user
USER is "SYSTEM"
SQL> conn sys/xx as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


More information about  this subject ( SYSTEM can change SYS password ) you can get from  www.in-oracle.com

 

 

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI Oracle Applications EBS 11i, R12  Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Database Administration (DBA)  >  Maintenance  >  SYSTEM can change SYS password

 

 

Different Romanian Links/ Linkuri romanesti diferite

  1. Exercitii de gramatica limbii engleze (English Grammar Exercises )

  Doresti un proiect de arhitectura ieftin (pentru zonele Buzau, Bucuresti sau Prahova) ?

Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk. Copyright (c) 2009-2011 Paul Catalin Tomoiu. All rights reserved.