Wednesday, March 31, 2021

Create Directory same path as other directory

›
  Begin  For Cur_Rec In (select directory_path from DBA_DIRECTORIES where DIRECTORY_NAME='LDOUTPUT') Loop     Begin       Execute Im...
Tuesday, March 30, 2021

When create index | ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "WMSYS.NO_VM_CREATE_PROC", line 147

›
 SYMPTOMS When attempting to creating a unique index, the following error occurs. Create Index BillVoucher on Faleddrcr(Firmnumber,nFinancia...
Friday, February 26, 2021

Pooled Connection Request timeout

›
There is probably some code that you have  out  there that is not properly disposing of some objects. This will cause Oracle to hold on to  ...
Tuesday, February 23, 2021

request channel timed out while waiting for a reply after

›
Check proxy setting on that machine. Sometimes dns is not able to resolve address so try IP instead of using name in local ldaddonmodules co...
Thursday, February 11, 2021

External Table vs Global Temporary Table GTT

›
You want to read big size text file or any file from OS level in one go then use external table. Global temp tables is used when you want to...
Sunday, February 7, 2021

Web Mobile Login page security | Penetration Testing | VAPT

›
Don't allow special character in user ID box. Never display Ora- or any .net message on error. It should be user defined. Also Sensitive...

JSON format

›
JSON is a format to store and exchange data between client and server. It is very simple,light weight, compatible with all popular programmi...
1 comment:
Friday, February 5, 2021

Change Oracle Profile idle Time | Application Will disconnect if it is IDLE | Sniped Session

›
select * from dba_profiles; select profile, limit from DBA_PROFILES where profile = 'DEFAULT' and resource_name = 'IDLE_TIME...
Tuesday, February 2, 2021

convert date to number

›
select to_number(to_char(sysdate, 'ddmmyyyy')) from dual;
Thursday, January 28, 2021

ora-27452 ora-00972

›
More than 30 character not allowed for job name. So please keep smaller job name.
Thursday, January 14, 2021

ORA-29273 ORA-06512 ORA-29263 HTTP protocol error

›
 ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1722 ORA-29263: HTTP protocol error following run select utl_ht...
Wednesday, September 23, 2020

private dblink

›
DB ldccm User ldccm Private Dblink cmldlink connect to LD database Now how user will access ldfibs table of other database using private lin...
Friday, September 18, 2020

Calculating ages in years

›
Calculating ages in years isn't as easy as ( current date - birth date ) / 365 @connor_mc_d has a solution - convert the dates to number...
Monday, September 14, 2020

Gather Stats of Table Partition Latest/Current Month Partition

›
  BEGIN  FOR CUR_REC IN (select * from (select table_owner,table_name,partition_name,partition_position,last_analyzed from dba_tab_partition...

Kill Third Party Tool Like PLSQL Developer Session

›
BEGIN  FOR CUR_REC IN (select ss.username,ss.terminal,ss.sid,ss.serial#,ss.inst_id from gv$session ss where module='PL/SQL Developer...
Thursday, August 27, 2020

ORA-12018: following error encountered during code generation for ..ORA-00979: not a GROUP BY expression

›
 ORA-12018 ORA-00979 ORA-06512 When we create Materialized report view it is successfully created and reports are coming properly. But when ...
Friday, August 21, 2020

The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/ServiceName' is unavailable for the protocol of the address

›
Getting the error, The message could not be dispatched because the service at the endpoint address 'net.pipe://localhost/ServiceName...
Thursday, August 20, 2020

Oracle 19c Security parameters Cyber security

›
Wednesday, August 12, 2020

IIS Web Security | Cyber Security | VAPT | Best Practices

›
1) Don't use default location c: to host application 2) disable default page 3) disable directory browsing 4) Disable the Http OPTIONS M...
Sunday, August 2, 2020

ora-01843 not valid month

›
ora-01843 not valid month Date which is passing in query has wrong format. Check server date format Or Web.config (.NET application) Add fol...