I upgraded MsSQL database version from MsSQL Server 2008 Express Edition to MsSQL Server 2008 Enterprise Edition. After upgrade operation, Agent XPs was disabled and MsSQL Server Agent servis could not start. I reconfigured Agent XPs configuration. The problem resolved. Management Studio Object Explorer does not display the contents of the SQL Server Agent node…
Tag: Database Administration
What is Lightweight Job in Oracle
Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. Lightweight jobs have the following characteristics: Unlike regular jobs, they are not schema objects. They have a significant improvement in create and drop time over regular jobs because they do not…
CRS-0184 Cannot Communicate With The Crs Daemon in Oracle
I got an error like CRS-0184 on Oracle 11g RAC system, because of interconnect network is down. After network was up, CRS Daemon did not start. You can take these errors like CRS-0184, CRS-2674, CRS-4534, CRS-4530.. I resolved that problem with below operations. CRS Stop and Start [root@node2 ~] cd $GRID_HOME/bin [root@node2 bin] ./crsctl stop…
Error : Cannot Open User Default Database in MsSQL Server
If you delete default database of user, users of default database can not connect to database. You have to connect with sqlcmd on master database. After you have to change default database of user. Error Cannot open user default database. Login failed. Solution Open CMD prompt C:\>sqlcmd -E -d master 1> alter login [domain\LoginUser] with…
Restore And Recover Oracle 11g R2 Database on Windows 2008 R2 Server
You can restore and recover Oracle 11g R2 Database from RMAN backup on Windows 2008 R2 Server with below operations. You have to execute Command Prompt as Administrator for all operations. Restore and Recover Database Install Oracle software Install Patch Create ORACLE_HOME and ORACLE_SID in Server Environment Path. Copy backup files to C:\orabackup Create Oracle…
ORA-03113: end-of-file on communication channel when startup
If your fra disk or archivelog directory full, your db can not process any transaction. When you increase disk size, database does not recover itself. You have to do some process. Error Solution
Oracle Control Files Content
A control file contains information about the associated database that is required for access by an instance, both at startup and during normal operation. Control file information can be modified only by Oracle Database; no database administrator or user can edit a control file. A control file contains The database name The timestamp of database…
Oracle Flashback Technology
When authorized people make mistakes, you need the tools to correct these errors. Oracle Database provides a family of human error correction technology called Flashback. Flashback revolutionizes data recovery. In the past, it might take minutes to damage a database but hours to recover it. With Flashback technology, the time to correct errors equals the…
Oracle Cold-Offline Backup And Restore
You have to shutdown database to take offline backup. After shutdown database, you can take backup with two way that are rman backup database or copy Data Directory that is include datafiles, redo log files and control files. Offline-Cold Backup Database 1- Take Offline Backup With Rman SQL> shutdown immediate; SQL> startup mount; RMAN> backup…
Create Linked Server for Oracle in SQL Server 2008 R2
If you want to fetch data from Oracle to SQL Server, you can use Linked Servers features in SQL Server Database. Linked Server is like a database link (Dblink). Installation steps Install Oracle Client on SQL Server database server Restart SQL Server database service Configure OraOLEDB.Oracle provider in SQL Server database Create user for remote…