Pages

▼
Tuesday, May 25, 2021

Connect from Oracle 10 Client to Oracle19 Server giving "ORA-01017: invalid username/password; logon denied"

›
=================== Issue =================== When connecting from Oracle 10 to Oracle 19, it is giving an error: ORA-01017: invalid usernam...
Wednesday, May 12, 2021

Oracle cannot be started due to error "ORA-07274: spdcr: access error, access to oracle denied."

›
==================== General ==================== Oracle cannot be started. In alert.log, there is this error: alert.log Current log# 3 seq#...
Wednesday, April 28, 2021

LEFT JOIN vs INNER JOIN vs WHERE

›
===================== General ===================== LEFT JOIN vs INNER JOIN vs Regular WHERE   ===================== Example ===============...
Monday, April 19, 2021

Error ORA-01000 Too many open cursors is coming, and it is not clear why.

›
========== General ========== Error ORA-01000 Too many open cursors is coming, and it is not clear why. Code below is logging number of curs...
Tuesday, April 13, 2021

A Function that return a table

›
===================== A Function that return a table ===================== --CREATE OR REPLACE TYPE myTableType   AS TABLE OF myObjectFormat...
Monday, April 12, 2021

cmd bat script to delete files in a directory olden than X days

›
@echo OFF REM cd D:\SfiGen\ArchiveDir SET DEL_DIR=D:\SfiGen\ArchiveDir SET WORK_DIR= D:\SfiGen\scripts SET KEEP_DAYS=30 ECHO start delete fi...
Thursday, April 8, 2021

Golden Gate Extracts are in ABENDED state. Error: Missing Log File WAITING FOR REDO: FILE NA

›
Golden Gate Extracts are in ABENDED state with error: ERROR   OGG-02870  Missing Log File WAITING FOR REDO: FILE NA, THREAD 1, SEQUENCE 0, ...