如题所述
sqlplus "/ as sysdba" è¿ä¸ä¸ï¼æ¥ora-01031:insufficient privileges解å³æ¹æ³
注æå¤ä¸ªæ°æ®åºå®ä¾æ¶åï¼setãORACLE_SID='',
1ãæ£æ¥sqlnet.oraï¼WINDOWSä¸ä½äº%ORACLE_HOME%NETWORKADMINç®å½ï¼æ¯å¦å å«è¿å¥ï¼SQLNET.AUTHENTICATION_SERVICES=(NTS)ï¼æ²¡æçè¯å ä¸
2ãæ£æ¥ç»éwindowsçç¨æ·(administratoræå®è£ oracleæ¶å使ç¨çç¨æ·)æ¯ä¸æ¯å¨å å«å¨ORA_DBAç»ä¸ï¼åç¨æ·æ²¡æè¿ä¸åæå¡å¨æ¶å°±å¯è½åºç°è¿ç§ç°è±¡ã
3. è¦ä¿è¯ remote_login_passwordfile åæ° = EXCLUSIVE .
4. ççæ¯å¦éè¦ä½¿ç¨orapasswçæå£ä»¤æ件 .
ä¸ç§è§£å³æ¹æ³æ¡ä¾ï¼
1ãæ£æ¥ç³»ç»åæ°ï¼SQL> show parameter password
NAME TYPE VALUE------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
2ã
select * from v$pwfile_users;
SQL>
为空
3ãSQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
4ã建ç«passwordæ件
D:/>orapwd file="D:/oracle/product/10g/db_1/database/PWDoratest.ora" password=gp
oswong entries=10
5ã
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP------------------------------ ----- -----
SYS TRUE TRUE
SYSæ£å¸¸æ¾ç¤ºåºæ¥ã
6ãéæ°å¨è¿ç¨ä»¥SYSDBAç»å½ï¼å¯æ£å¸¸ä½¿ç¨ã
å¦æå£ä»¤æ件å建çæé®é¢ï¼ä¹æ¯ä¼æ¥å¦ä¸çé误ï¼
ora-01031:insufficient privileges
å£ä»¤æ件çå½åæ ¼å¼åºä¸ºorapwsidï¼å¹¶ä¸sidæ¯åºå大å°åçãç±äºTarget Databaseè¿æ¥Auxiliary Databaseæ¶éè¦éªè¯å£ä»¤ï¼å¦æè¿åäºä»¥ä¸è§åï¼å°ä¼æ示ORA-01031: insufficient privilegesã
æå¨ç¨linuxå建duplicateæ°æ®åºçæ¶å å°±æ¯å 为å£ä»¤æ件å建çè·¯å¾åå称ä¸å¯¹æéå°è¿ä¸ªé误
-----end-------
注æå¤ä¸ªæ°æ®åºå®ä¾æ¶åï¼setãORACLE_SID='',
1ãæ£æ¥sqlnet.oraï¼WINDOWSä¸ä½äº%ORACLE_HOME%NETWORKADMINç®å½ï¼æ¯å¦å å«è¿å¥ï¼SQLNET.AUTHENTICATION_SERVICES=(NTS)ï¼æ²¡æçè¯å ä¸
2ãæ£æ¥ç»éwindowsçç¨æ·(administratoræå®è£ oracleæ¶å使ç¨çç¨æ·)æ¯ä¸æ¯å¨å å«å¨ORA_DBAç»ä¸ï¼åç¨æ·æ²¡æè¿ä¸åæå¡å¨æ¶å°±å¯è½åºç°è¿ç§ç°è±¡ã
3. è¦ä¿è¯ remote_login_passwordfile åæ° = EXCLUSIVE .
4. ççæ¯å¦éè¦ä½¿ç¨orapasswçæå£ä»¤æ件 .
ä¸ç§è§£å³æ¹æ³æ¡ä¾ï¼
1ãæ£æ¥ç³»ç»åæ°ï¼SQL> show parameter password
NAME TYPE VALUE------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
2ã
select * from v$pwfile_users;
SQL>
为空
3ãSQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
4ã建ç«passwordæ件
D:/>orapwd file="D:/oracle/product/10g/db_1/database/PWDoratest.ora" password=gp
oswong entries=10
5ã
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP------------------------------ ----- -----
SYS TRUE TRUE
SYSæ£å¸¸æ¾ç¤ºåºæ¥ã
6ãéæ°å¨è¿ç¨ä»¥SYSDBAç»å½ï¼å¯æ£å¸¸ä½¿ç¨ã
å¦æå£ä»¤æ件å建çæé®é¢ï¼ä¹æ¯ä¼æ¥å¦ä¸çé误ï¼
ora-01031:insufficient privileges
å£ä»¤æ件çå½åæ ¼å¼åºä¸ºorapwsidï¼å¹¶ä¸sidæ¯åºå大å°åçãç±äºTarget Databaseè¿æ¥Auxiliary Databaseæ¶éè¦éªè¯å£ä»¤ï¼å¦æè¿åäºä»¥ä¸è§åï¼å°ä¼æ示ORA-01031: insufficient privilegesã
æå¨ç¨linuxå建duplicateæ°æ®åºçæ¶å å°±æ¯å 为å£ä»¤æ件å建çè·¯å¾åå称ä¸å¯¹æéå°è¿ä¸ªé误
-----end-------
温馨提示:答案为网友推荐,仅供参考