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...
Wednesday, July 29, 2020

ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small

›
ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small Sometimes you get this error if you insert a character/string i...

ORA-00600 internal error code, arguments [qkebCreateConstantOpn1]

›
Query UPDATE TBLNONPOASTOCKS SET NQUANTITY=0,NUSABLEPLEDGESTOCK=0 WHERE TBLNONPOASTOCKS.CFIRMNUMBER=ICFIRMNUMBER AND TBLNONPOASTOCKS.CPERSON...
Saturday, July 25, 2020

ORA-22992 cannot use LOB locators selected from remote tables

›
SELECT * FROM TBLHTMLSCANNEDIMAGE@LNK_PREVIOUSYEARBALANCE; ORA-22992: cannot use LOB locators selected from remote tables both 1920 and 2021...

ORA-65510: Distributed LOB operations are not supported on pre-12.2 databases.

›
Summary from LD , I m trying to save Blob image in ccm's table with link select * from ldccm.TBLCLREQUESTDESCRIPTION@Lnk_Ccm; Error 01~E...
Thursday, July 23, 2020

ORA-30926 unable to get a stable set of rows in the source tables

›
ORA-30926: unable to get a stable set of rows in the source tables   Cause: A stable set of rows could not be got because of large dml activ...
Monday, July 20, 2020

ORA-00600 internal error code, arguments [13013] [5001]

›
ORA-600 [13013] [a] [b] [c] [d] [e] [f] This format relates to Oracle Server 8.0.3 to 10.1 Arg [a] Passcount Arg [b] Data Object number Arg ...

Disable trigger based on some condition

›
/* following command will disable the RK Trigger at NON RK Client only */ declare lchost varchar2(100);  begin select host into lchost from ...

Merge is not using Parallel hint

›
if you are using table alias then use parallel(alias) not parallel(table_name) also if query is using index in plan then it will not use par...
Friday, July 17, 2020

DBCA Ora-03113

›
Check OS level Resource RAM

copy column from same table

›
Table 1 Col1 Col2 Col3 New column Col4 added Col4 has same data col2 Method Update table1 set Col4=col2 Create table as  Insert into table2(...

oracle communication: failed to connect to server or failed to parse connect string

›
Tnsping Antivirus and firewall exclusion Oracle database and application driver version compatibility ODAC ODP.NET oracle client oracle.mana...
Thursday, July 16, 2020

Update millions of rows in very huge table Performance

›
/*Use set value also in where clause. Eg. Set nUsablePledgestock=1 Where nUsablePledgestock !=0 "/ Update PowerofAttorneystocks set nUs...

select max from large table performance

›
Select max(ddate) from transactions where code='KSH'; Change to  Select ddate from ( select ddate from transactions where code='...

ORA-22816: unsupported feature with RETURNING clause in trigger

›
Restrictions The following restrictions apply to the RETURNING clause: The expr is restricted as follows: Each expr must be a simple express...

ora-02055 ora-02069 ora-06512 ora-04088 select Sequence Remote table

›
Error in executing Trigger  /* problem */ can not use Sq_Rakshakfreshpledge.nextval direct in remote table Insert into tblRkfreshpledge@lnk_...