Daily Archives: February 4, 2025

Create the OEM Repository Database 

Notes:  Database oemdb is created via dbca  Non-CDB database is created (PDB is also supported for repository database)  Redo Log file size should be minimum 300 MB  After database is…

Read More

Blob File Move From DB to Directory

Introduction/ Issue:   CSV blob file to raw file move from database table blob column to database directory. Why we need to do / Cause of the issue:  We can move from blob to raw CSV file from database table blob column to database directory. How do we solve:  Step 1: Create one database procedure PROCEDURE P_FILE_TO_DBSER (p_blob      IN  BLOB, p_dir       IN  VARCHAR2, p_filename  IN  VARCHAR2) AS l_file      UTL_FILE.FILE_TYPE; l_buffer    RAW(32767); l_amount    BINARY_INTEGER := 32767; l_pos       INTEGER := 1; l_blob_len  INTEGER; BEGIN l_blob_len := DBMS_LOB.getlength(p_blob);   — Open the destination file. l_file := UTL_FILE.fopen(p_dir, p_filename,’wb’, 32767); — Read chunks of the BLOB and write them to the file until complete. WHILE l_pos <= l_blob_len LOOP DBMS_LOB.read(p_blob, l_amount, l_pos, l_buffer); UTL_FILE.put_raw(l_file, l_buffer, TRUE); l_pos := l_pos + l_amount; END LOOP;   — Close the file. UTL_FILE.fclose(l_file);  …

Read More

File Store From Client to DB

Introduction/ Issue:   CSV file move from client local machine to database table blob column. Why we need to do / Cause of the issue:  We can store the CSV file from client local machine to database table blob column. How do we solve:  Step 1: Create new table in database CREATE TABLE TB_FILE_UPLOAD (ID NUMBER, FILE_DATA BLOB); Step 2: Create new sequence in database CREATE SEQUENCE FILE_UPLOAD_SEQ START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 INCREMENT BY 1 NOCYCLE CACHE 20 NOORDER NOKEEP GLOBAL; Step 3: In oracle form builder create on button and write the below code in WHEN-BUTTON-PRESSED trigger. DECLARE v_seq       number; v_file_path varchar2(500) := ‘C:\test_file.csv’; v_bool          boolean; BEGIN SELECT FILE_UPLOAD_SEQ .NEXTVAL INTO v_seq FROM DUAL; INSERT INTO TB_FILE_UPLOAD (ID, file_data)              VALUES (v_seq, NULL); IF v_file_path IS NOT NULL THEN…

Read More

Deploy OEM Agents 

Notes:  1.Deployment of agent from within OEM failed with SSH check.2.Manually deploy the agent by downloading the agent image from OMS and then perform a silent installation using a response…

Read More