AD

Personal summary of oracle technology (change password)

Change oracle password:

(1) The premise: the relevant environmental variables has been configured

1.ORACLE_HOME = B: \ oracle \ product \ 10.2.0 \ db_1

2.path add% ORACLE_HOME% \ bin;

3. New variable TNS_ADMIN =% ORACLE_HOME% \ NETWORK \ ADMIN

4. Add the character set variable NLS_LANG = AMERICAN_AMERICA.AL32UTF8

(2) modify the B: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ sqlnet.ora

Add SQLNET.AUTHENTICATION_SERVICES = (NTS), said that when you log on users can access the database server

(3) Log in cmd command window

sqlplus / as sysdba
alter user system identified by manager;
alter user sys identified by change_on_install;

(4) in the Pl / SQL using system users can log in; sys can not log on solutions are as follows:

****yuloo**/news/104346.html

**bbs.chinaunix**/thread-1798475-1-1.html
标签: oracle, oracle home, premise, database server, oracle product, system users, environmental variables, personal summary, pl sql, sys, tns, authentication services, network admin, oracle password, technology change, sqlnet, oracle technology
分类: Database
时间: 2010-12-23

相关文章

  1. ajax using dwr tools to pass the value from the front page to back Java objects inside, and then according to the results of the object to return to the page up (back Qinbo personal summary)

    ajax using dwr tools, from the front page the value passed to the Java objects back inside, then according to ...
  2. Summary chrome plug-in technology development

    This is a summary posted on the last month to take advantage of spare time to write the chrome plug-in all its ...
  3. mysql change password

    Reprinted from http://jansener.javaeye.com/blog/237538 First, may I ask win2K/WIN2003/WINXP mysql command prom ...
  4. Oracle sqlplus login password using a password with special character '@' to escape landing

    I believe most of the friends set the oracle database login password will be set when the more complex, today ...
  5. By the ACOUG. En Mexico hosted the cloud and the "Oracle technology Carnival (OTN China Tour 2011)" activity has been officially opened.

    By the ACOUG, ink cloud and ex-hosted the "Oracle technology Carnival (OTN China Tour 2011)" activit ...
  6. oracle technical personal summary (change password)

    Modify the oracle password: (1) The premise: the relevant environmental variables has been configured 1.ORACLE ...
  7. Oracle 11g exist password expiration problem (100 with Braun Oh, do not forget to change Well, after a message oh!)

    【Description】 problem Oracle database using sqlplus login prompt "ORA-28002: 7 days after the password wi ...
  8. Oracle in the Change Password

    Using oracle user login, connect to the database [Oracle @ wuzj ~] $ sqlplus / nolog SQL * Plus: Release 10.2. ...
  9. Change the oracle user's password (Reprinted)

    Change the oracle user password czmmiao 2011-02-24 The first is sqlplus / as sysdba; not plsql / as sysdba; [i ...
  10. Oracle to change the system and sys user name and password [back Qinbo resolution]

    When the original installation oracle oracle is no set up and manage the default user dba and scott so, how go ...
  11. Change Password in Oracle

    , The oracle user login, connect to the database [Oracle @ wuzj ~] $ sqlplus / nolog SQL * Plus: Release 10.2. ...
  12. Log in with the Oracle DBA user password change

    How to log in oracle DBA 1, first run cmd to open a DOS window, type sqlplus. 2, but first you have to start t ...
  13. Change the oracle user's password (reproduced)

    Change the oracle user password czmmiao 2011-02-24 First sqlplus / as sysdba; not plsql / as sysdba; [img] / i ...
  14. Oracle on the password and password file

    To install the Oracle user into the system: Forgot your password: 1. At the command line, type sqlplus / nolog ...
  15. Latest Oracle Technology Salon (3.20)

    PSC dedicated special round table Chen Weixing - Oracle Performance Tuning Oracle WDP Certification Center Bei ...
  16. Summary of Oracle occupy port 8080 (reprint)

    Source (http://topic.csdn.net/ ...) After full installation of Oracle on the 8080 will be occupied on the caus ...
  17. Personal summary of the domestic free network hard disk

    Original Source: http://hi.baidu.com/203x/blog/item/3130c8dd7517b0e176c6387e.html Recent home network hard dri ...
  18. IO Java in a summary of the flow (change)

    Summary 1: Java IO principles of general use: 1, according to the data source (destination) Category: 1, is th ...
  19. DB2 Change Password issue

    DB2 system is installed, the automatic loading of a db2admin the admin account and password is 123456. This is ...