Sysdbaonline - sysdbaonline.com
General Information:
Latest News:
Oracle – Indirect Restore using Netbackup 10 May 2013 | 03:00 am
Problem : I was needed to do the production database restore in order to recover the lost data from production database. The data was lost from few tables only so I decided to restore production datab...
Create a read only user in Oracle 9 May 2013 | 06:38 pm
Problem: I was asked to create a read only user account in Oracle. Solution: In Oracle, There is not straight forward way to create a user and grant db_datareader role like SQL server, so you will hav...
EM12C – 12.1.0.1.0 – How to Deploy Agent silently/remotely 28 Jun 2012 | 01:26 am
Question : How do I deploy the EM12C agent silently and remotely. Answer: With 12C you can use emcli to download and deploy agent silently. Please follow the following steps. To perform installat...
Grid Control 10.2.0.5 – Agent issue 22 Feb 2012 | 04:25 am
Problem: I was not able to see few databases on my grid control portal though the agent was installed on the box where the databases were running. When I looked at the OMS trace file under $OMS_HOME...
Oracle – Restrict User login from particular IP Address 1 Feb 2012 | 05:19 am
Problem : I was asked to load new data into the database and I didn’t want users/applications to connect when I am loading the data. Solution : I had the following solutions in my mind. Solution 1...
Oracle – Restrict User login from particular IP Address 31 Jan 2012 | 08:19 pm
Problem : I was asked to load new data into the database and I didn’t want users/applications to connect when I am loading the data. Solution : I had the following solutions in my mind. Solution 1:Onl...
MySQL 5.5 – ROOT Password issue 18 Jan 2012 | 03:52 am
Problem: I tried to upgrade the MySQL 5.1 to MySQL 5.5 and messed up the installation somehow ,so I deleted the data directory for mysql (/var/lib/mysql) and installed the MySQL 5.5 fresh using the R...
MySQL 5.5 – ROOT Password issue 17 Jan 2012 | 06:52 pm
Problem: I tried to upgrade the MySQL 5.1 to MySQL 5.5 and messed up the installation somehow ,so I deleted the data directory for mysql (/var/lib/mysql) and installed the MySQL 5.5 fresh using the RP...
Oracle 11G – Active Duplicate Database 15 Dec 2011 | 01:08 am
Problem : I was asked to duplicate the production database (11.2.0.2) on the same machine which will be used as a test instance. Solution: With 11G there are many ways to duplicate the database. M...
Oracle 11G – Active Duplicate Database 14 Dec 2011 | 04:08 pm
Problem : I was asked to duplicate the production database (11.2.0.2) on the same machine which will be used as a test instance. Solution: With 11G there are many ways to duplicate the database. Manua...
