????Oracle???????????????bug
???????????? ???????[ 2015/11/27 11:14:18 ] ?????????????
????????drop database??oracle??????????????????????????????????????????????????????????????????????????е????????????????????????????????????????????е???????????е?????????????????Щ??????????
???????????open??????????????????????
????SQL> drop database TEST;
????drop database TEST
????*
????ERROR at line 1:
????ORA-00933: SQL command not properly ended
????????????mount??Ρ?
????SQL> alter database mount exclusive;
????Database altered.
????SQL> drop database TEST;
????drop database TEST
????*
????ERROR at line 1:
????ORA-00933: SQL command not properly ended
????????????????exclustrict????
????SQL> drop database;--???л??????????
????drop database
????*
????ERROR at line 1:
????ORA-12719: operation requires database is in RESTRICTED mode
????SQL> alter system enable restricted session;
????System altered.
????SQL> drop database;
????Database dropped.
?????????????????????????????????????Mount??????restrict mode??drop database????趼??????
????????????????????????????£???????????????restrict????.????????е?????????ORA??????????
????idle> startup force mount restrict;
????ORA-00000: normal?? successful completion
??????????????????oerr?????о???Щ??????????????????????????
????$ oerr ora 00000
????00000?? 00000?? "normal?? successful completion"
????// *Cause: Normal exit.
????// *Action: None.
????????????????metalink????????????????????????????????????????????????á?
??????????????????????ο????????MySQL??Oracle???????????????http://blog.itpub.net/23718752/viewspace-1659551/
????metalink????????????Bug 11706168 - ORA-00000 during STARTUP with SQLNET.WALLET_OVERRIDE=TRUE (Doc ID 11706168.8)
???????????????????????????bug.
????????????????????????
???????????????????override???????????????
????sys@TEST11G> startup force
????ORA-00000: normal?? successful completion
????sys@TEST11G> !cat sqlnet.ora|grep SQLNET
????SQLNET.WALLET_OVERRIDE=true
??????????????????????????????
????idle> startup force
????ORACLE instance started.
????Total System Global Area 435224576 bytes
????Fixed Size 1337044 bytes
????Variable Size 272632108 bytes
????Database Buffers 155189248 bytes
????Redo Buffers 6066176 bytes
????Database mounted.
????Database opened.
????idle> !cat sqlnet.ora|grep SQLNET
????#SQLNET.WALLET_OVERRIDE=true
????????????????????????????????????£?????????????????????????
?????????????session?н?????????????????????????
??????????????session??????????
????idle> startup
????ORACLE instance started.
????Total System Global Area 435224576 bytes
????Fixed Size 1337044 bytes
????Variable Size 272632108 bytes
????Database Buffers 155189248 bytes
????Redo Buffers 6066176 bytes
????Database mounted.
????Database opened.
????idle> shutdown immediate
????Database closed.
????Database dismounted.
????ORACLE instance shut down.
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11