Ameer Khan

How to reset Mysql Root password:- [root@server1 ~]# mysql -u root -predhat To change root password.mysql> update user set Password=PASSWORD(‘newpassword’) WHERE User=’root’;Query OK, 4 rows affected (0.02 sec)Rows matched: 4  Changed: 4  Warnings: 0 mysql> flush privileges;Query OK, 0 rows affected (0.00 sec) If root password is not available or its lost but we need… Continue Reading

Scenario:- So this scenario shows how to open your standby database in read/write mode when you dont have any access(Lost) on primary database.Here i’m trying to make a test case to demonstrate the following scenario.Currenly both primary and standby database are in sync. Oracle version :-  11.2.0.1.0Primary Database : primStandby Database : stand At primary… Continue Reading

Oracle Version: oracle 11gOracle SID: orclOS Version:- RHEL 6Hostname:- server1.example.comServer IP: 192.168.72.120 $ vi /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools. SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = orcl)      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)      (SID_NAME = orcl)    )  ) LISTENER =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = server1.example.com)(PORT =… Continue Reading

Oracle Version: oracle 11gOracle SID: orclOS Version:- RHEL 6Hostname:- server1.example.comServer IP: 192.168.72.120 $ vi $ORACLE_HOME/network/admin/tnsnames.ora# tnsnames.ora Network Configuration File: /i01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.orcl =  (DESCRIPTION =         (ADDRESS = (PROTOCOL = TCP)(HOST = server1.example.com)(PORT = 1521))         (CONNECT_DATA =           (SERVER = DEDICATED)    (SERVICE_NAME =… Continue Reading

How to findout characterset in Oracle 11g ? SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ; VALUE$——————————————————————————–WE8MSWIN1252 SQL> SELECT * FROM NLS_DATABASE_PARAMETERS; PARAMETER                      VALUE—————————— —————————————-NLS_LANGUAGE                   AMERICANNLS_TERRITORY                … Continue Reading

SQL> COL “USER,HIS ROLES AND PRIVILEGES” FORMAT a100set linesize 300 pages 1000SELECTLPAD(‘ ‘, 5*level) || granted_role “USER,HIS ROLES AND PRIVILEGES”FROM(  SELECT NULL grantee, username granted_role  FROM dba_users  WHERE username LIKE UPPER(‘SOUMYA’)  UNION  SELECT grantee,granted_role  FROM dba_role_privs  UNION  SELECT grantee,privilege  FROM dba_sys_privs)START WITH grantee IS NULLCONNECT BY grantee = PRIOR granted_role; USER,HIS ROLES AND PRIVILEGES—————————————————————————————————-   … Continue Reading

Oracle version :-  11.2.0.1.0Database Sid : prim While we clone the database, the DB ID remains same as like the source database, so if we need to change it to the different DB ID, then use the follwingmethod.Also when we change DBID of the database all previous backups will become unusable and we must open… Continue Reading

Oracle version :-  11.2.0.1.0Database Sid : prim Step 1.Find out current dbname:-[oracle@server1 ~]$ sqlplus  / as sysdba SQL> show parameter db_name NAME                                 TYPE        VALUE———————————— ———– ——————————db_name                    … Continue Reading

FLASHBACK TABLE statement is used to restore an earlier state of a table in the  event of human or application error.Though It entirely depends  on the amount of undo data that ispresent in the system.Also we cant flashback a table to earlier stage in case of any ddl operation that changes the table structure.flashback on… Continue Reading

Microsoft Windows Server R2 with Update 64bit  download link with  cd key:- Continue Reading