Creating a Password File and Adding New Users to It (47)
Use the following procedure to create a password and add new users to it:
1. Follow the instructions for creating a password file as explained in "Using
ORAPWD"
2. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.
(This is the default.)
3. Connect with SYSDBA privileges as shown in the following example:
CONNECT SYS/password AS SYSDBA
4. Start up the instance and create the database if necessary, or mount and open an
existing database.
5. Create users as necessary. Grant SYSDBA or SYSOPER privileges to yourself and
other users as appropriate.
建立密碼檔案並新增使用者
1. 使用orapwd
2. 將REMOTE_LOGIN_PASSWORDFILE引數化引數設定為EXCLUSIVE
3. 以sysdba連線
4. 啟動例項,建立資料庫. 或者裝載開啟已有的資料庫
5. 建立使用者 , 賦予sysdba許可權
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995390/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Password File 理解Oracle
- Python internals: adding a new statement to PythonPython
- Eclipse Creating a New Runnable JAR File 清理工作空間下的配置檔案EclipseJAR
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- Viewing Password File Members (49)View
- Generating a new SSH key and adding it to the SSH-agent
- Microsoft may be creating entirely new browser with Windows 10ROSWindows
- OBIEE 11g users still able to login even with invalid password
- 【BO-SDK】-(RAS) Adding a new parameter_@old_devlib_04dev
- Oracle中password file的作用及說明Oracle
- Manage ASM instance-creating diskgroup,adding/dropping/resizing disks_270066.1ASM
- 【JAVA】Java中 File f=new File(String parent ,String child)Java
- grid control Error in getting data for creating new listenerError
- (zt)Oracle中password file orapwd的作用及說明Oracle
- Oracel 12c Alert日誌中的Creating new log segment
- Types of Oracle Database Users : Database Users (6)OracleDatabase
- 【oracle】ORA-01580 error creating control backup fileOracleError
- no- valid devices were found on which to create new file systemsdev
- Adding a Wordfile in Ultraedit
- 新手必看!使用New File Menu常見問題集錦
- Oracle default usersOracle
- oracle12.2 adg ORA-46952: standby database format mismatch for password fileOracleDatabaseORM
- 請問File--New---Enterprise中的JMS如何啟用
- Oracle WebLogic Default Password & Change PasswordOracleWeb
- oracle users 表空間Oracle
- Move users between domainsAI
- Oracle Created (Default) Database UsersOracleDatabase
- 修改sys密碼報錯:ORA-01994: Password file missing or disabled密碼
- Easy New File|讓Mac像Windows一樣可以右鍵新建檔案MacWindows
- How To Restore 12cR1DB to New Host File System using RMAN(一)REST
- jQuery :passwordjQuery
- Django中的函式make_password、set_password和check_passwordDjango函式
- vue47Vue
- lsnrctl中,SET PASSWORD和CHANGE_PASSWORD命令
- Automatically Map Network Drives on Domain Login for All Users, Certain Users, or Certain GroupsAI
- Creating the Database (58)Database
- 262-Trips and Users
- How Users Read on the Web (轉)Web