ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes I kept getting following error while I was trying to run the Oracle Support suggested script: ERROR at line 1: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes ORA-06512: at "SYS.DBMS_OUTPUT", line 32 ORA-06512: at "SYS.DBMS_OUTPUT", line 97 ORA-06512: at "SYS.DBMS_OUTPUT", line 112 ORA-06512: at line 28  I was suffering from short of time so instead of consulting the Oracle Support I googled it and found the following solution: I opened the...

Read More

Oracle: Auto Backup

Oracle Auto Back up Create ‘filname.sh’ file with following code anywhere in server after amendments. (Possible amendments in RED.) e.g. filename is make_db.sh.  #!/bin/bash  #  #  dy=`date +%a`  hn=`hostname`  bk='/opt/back'  sb=$bk'/'$hn  #  #!/bin/bash  #  #  dy=`date +%a`  hn=`hostname`  bk='/opt/back'  sb=$bk'/'$hn  #  #  cm_d01='tar -Pczf '$sb'/'$hn'_'$dy'_d01.tar.gz /opt/d01'        cm_d02='tar...

Read More

DBLINK : Connect to remote database

Connect to remote database Create database link by executing following command in TOAD. 1.     create database link dblink1 connect to apps identified by apps  using 'TESTUPGRADE';   Where ‘dblink1’ is link alias, first ‘APPS’ is schema name ,second ‘APPS’ is password and    ‘TESTUPGRADE’ is service name. 2.  select * from tablename@dblink1    Before executing query you need to add...

Read More