- Feb 08 Thu 2018 17:00
Oracle 12c orapwd 建立密碼檔 錯誤 OPW-00029
- Feb 05 Mon 2018 16:00
drop database by rman
今天要在 docker 上刪除資料庫,但是使用 dbca 這個需要 gui 畫面,所以想到改用 rman 來操作,以下為官方指令
RMAN> CONNECT TARGET / RMAN> STARTUP FORCE MOUNT RMAN> ALTER SYSTEM ENABLE RESTRICTED SESSION; RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
database name is "ORCLCDB" and DBID is 2738330970
- Feb 01 Thu 2018 15:00
Oracle OPatch Upgrade Version (Doc ID 274526.1)
要使用 OPatch 時,發現有提示訊息說明版本過舊,無法使用,因此呼叫出 Oracle Support 來找怎麼升級
How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)
- Feb 01 Thu 2018 14:10
OPatch failed with error code 73
今天對 Docker 內的 Oracle Database 12c 上 Patch,下 $ORACLE_HOME/OPatch/opatch Apply 時出錯,
[oracle@be7dad568792 27105253]$ /opt/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch apply
- Jan 29 Mon 2018 12:00
SQLServer 查詢使用者權限 view
SELECT A.class_desc AS 等級
,OBJECT_NAME(major_id) AS 物件名
- Jan 29 Mon 2018 11:00
無法連接到 SQL Server Named Pipes Provider, error: 40
- Dec 05 Tue 2017 12:00
ORA-38500 USING CURRENT LOGFILE option not available without standby redo logs
在進行資料庫還原後,要將資訊庫轉為 standby 模式時,出現 ORA-38500
SQL> alter database recover managed standby database using current logfile disconnect from session;
- Dec 05 Tue 2017 11:00
CentOS Linux SSH 連線慢