Profile cover photo
Profile photo
Shishir Tekade
54 followers
54 followers
About
Posts

Post has attachment
Setting server system variable 'old_alter_table' back to '0'.
Error : -- MySQL Enterprise Backup version 4.1.0 Linux-2.6.39-400.215.10.el5uek-x86_64 [2017/03/01] Copyright (c) 2003, 2017, Oracle and/or its affiliates. All Rights Reserved. 170705 03:00:01 MAIN    INFO: A thread created with Id '140533386585920' 170705 ...

Post has attachment
ALTERNATE archival destination in Oracle
Understanding Archive
Destination Status Each archive destination has the following variable characteristics that
determine its status: ·          Valid/Invalid : indicates whether the disk location or service name information is
specified and valid ·      ...

Post has attachment
doubt transactions in oracle
Query to check in doubt transactions... ===================================== SQL> SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID,to_char(FAIL_TIME,'dd-mon-yyyy HH24:MI:SS'), STATE, MIXED FROM DBA_2PC_PENDING; LOCAL_TRAN_ID          GLOBAL_TRAN_ID                    ...

Post has attachment
Oracle External Table Error ORA-12801 ORA-29913
Error: SQL> select * from abc.EXT_TAB_BILLRUN; select * from abc.EXT_TAB_BILLRUN * ERROR at line 1: ORA-12801: error signaled in parallel query server P000 ORA-29913: error in executing ODCIEXTTABLEFETCH callout Cause: External Table loading rejecting the B...

Post has attachment
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)
Issue:- ERROR 2049
(HY000): Connection using old (pre-4.1.1) authentication protocol ref used
(client option 'secure_auth' enabled).. Solution:- On the command
line, use below .... mysql
-uUSERNAME -pPASSWD DbName -h HostName --skip-secure-auth OR Login to ...

Post has attachment
mysqlbackup: WARNING: binlog file 'mysql-bin.000161' does not exist. It could have been purged. PITR will not be possible from this backup.
Issue:-      Tape mysqlbackup failed because of below
WARNING msg.      mysqlbackup: WARNING: binlog file
'mysql-bin.000161' does not exist. It could have been purged. PITR will not be
possible from this backup.         Solution:-     login to mysqlDB & che...

Post has attachment
send-mail: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol
Issue :-- send-mail: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol send-mail: warning: inet_protocols: configuring for IPv4 support only postdrop: warning: inet_protocols: IPv6 support is disabled: Address famil...

Post has attachment
1129 error connecting to master
mysql> show slave status \G; ************************* 1. row *************************                Slave_IO_State: Connecting to master                   Master_Host: 000.000.000.100                   Master_User: rep_user                   Master_P...

Post has attachment
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Today, I face below error while converting database into archive log mode.  ORA-00265: instance recovery required, cannot set ARCHIVELOG mode This error usually come when database crashed unfortunately or we shutdown database with the help of database shutd...

Post has attachment
MySQL Documentation: MySQL Reference Manuals
MySQL Documentation: MySQL Reference Manuals :- Please use below link for MySQL details. http://dev.mysql.com/doc/ 
Wait while more posts are being loaded