リスナーログの切り替え

lsnrctl set log_status off rename [logファイル名] [toLogファイル名] lsnrctl set log_status on select * from gv$session a, gv$sqlarea b where a.inst_id = b.inst_id and a.sqlid = b.sql_id baskup database section size [size] format 'ファイル…

vbaでoracle接続のクラス

vbaでOracle接続のクラスを作成してみた。 Option Explicit Const PROVIDER = "OraOLEDB.Oracle" Const DATA_SOURCE = "XEPDB1" Const USER_ID = "OT" Const PASSWORD = "OT" Private conn As ADODB.Connection Public Sub dbOpen() conn.Open End Sub Publi…

vbaでOracleに接続

Const PROVIDER = "OraOLEDB.Oracle" Const DATA_SOURCE = "XEPDB1" Const USER_ID = "USER" Const PASSWORD = "PASS" Sub Test() Dim sql As String sql = "select sysdate from dual" Dim conn As New ADODB.Connection conn.ConnectionString = "Provider…

アーカイブログモードに変更

sqlplus / as sysdbashutdown immidiate; startup mount; alter database archivelog; alter database noarchivelog; alter database open;

テスト

select sysdate from dual; archive log list