Oct 18 2014

How to Install Oracle Enterprise Linux 7

Category: Linux & UnixFatih Acar @ 13:57

Oracle company released Oracle Enterprise Linux 7 version. OEL7 has new features. You can install OEL7 like below.

Installation OEL7


Continue reading “How to Install Oracle Enterprise Linux 7″

153 total views, 18 views today

Tags: Oracle Linux, System Administration

Sep 25 2014

How to Drop Oracle Database With RMAN

Category: Administration,Backup And RecoveryFatih Acar @ 15:25

You can run the following commands to delete the target database files, as well as all backups, copies, and archived logs associated with the database.

Drop Oracle Database

oracle@oratest~ ]$ rman target /

Note : If database is not started, you have to start database with mount mode. If database is started, you have to do shutdown and you have to do startup mount.


Continue reading “How to Drop Oracle Database With RMAN”

765 total views, 9 views today

Tags: Database Administration, Oracle Administration, Oracle Backup and Restore

Sep 18 2014

Error: Cluster Disk 1 Does Not Support Persistent Reservations.

Category: VMware,WindowsFatih Acar @ 15:21

While I was installing Windows Failover Cluster system, I got an error like “Cluster Disk 1 does not support persistent reservations.”. If you are attempting to set up a Cluster in a Single Host, and the shared disk (or disks) for the cluster is RDM (Raw Device Mapping, or Raw Disk Mapping), in Physical Compatibility Mode. If this is the case, you can either change the disks to Virtual Compatibility mode, or if you wish to use Physical Compatibility Mode, the cluster nodes must be on different hosts. My case was that.

Other Cause For This Error

  • If the storage array is not configured correctly to support SCSI-3 compliant commands.
  • A third-party plug-in is interfering with the SCSI reservation process (such as the PowerPath/VE PSA).
  • If virtual machines are running under the MSCS configuration on two separate ESX/ESXi hosts, and the .vmdk files are on a VMFS datastore which is configured as physical bus sharing mode.

Continue reading “Error: Cluster Disk 1 Does Not Support Persistent Reservations.”

927 total views, 9 views today

Tags: Cluster Systems, System Administration, VMware, VMware Administration

Jun 25 2014

HTTP Status 500 Error in SAP BusinessObjects System

Category: Errors and SolutionsFatih Acar @ 10:30

I got an error after BO Explorer installation. I could resolve this problem with below operation.


HTTP Status 500 – while trying to invoke the method java.util.Properties.entrySet() of an object loaded from local variable ‘globalProperties’

SAP BO HTTP Status 500 Error

SAP BO HTTP Status 500 Error

Continue reading “HTTP Status 500 Error in SAP BusinessObjects System”

5,634 total views, 27 views today

Tags: SAP Basis, Sap Errors and Solutions, Sap System Administration

Jun 05 2014

How to Enable Agent XPs in MsSQL Server 2008 (Agent Xps Disabled)

Category: Administration,Errors and SolutionsFatih Acar @ 09:28

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 unless these extended stored procedures are enabled regardless of the SQL Server Agent service state.

Agent XPs Possible Values

0, indicating that SQL Server Agent extended stored procedures are not available (the default).
1, indicating that SQL Server Agent extended stored procedures are available.

Show Current Value


Reconfigure Agent XPs

EXEC SP_CONFIGURE ‘show advanced options’, 1;
SP_CONFIGURE ‘Agent XPs’, 1;

After these parameter change operations you can restart agent service or sql server service to show Agent XPs enabled.

Continue reading “How to Enable Agent XPs in MsSQL Server 2008 (Agent Xps Disabled)”

53,703 total views, 45 views today

Tags: Agent XPs Disabled, Database Administration, MsSQL Server, SQL Server Administration

Apr 17 2014

What is Lightweight Job in Oracle

Category: Administration,ProcedureFatih Acar @ 14:46

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 have the overhead of creating a schema object.
  • They have lower average session creation time than regular jobs.
  • They have a small footprint on disk for job metadata and runtime data.

You designate a lightweight job by setting the job_style job attribute to LIGHTWEIGHT. The other job style is REGULAR, which is the default.

Like programs and schedules, regular jobs are schema objects. In releases before Oracle Database 11g Release 1, regular jobs were the only job style supported by the Scheduler.

A regular job offers the maximum flexibility but does entail some overhead when it is created or dropped. The user has fine-grained control of the privileges on the job, and the job can have as its action a program or a stored procedure owned by another user.

Continue reading “What is Lightweight Job in Oracle”

4,451 total views, 9 views today

Tags: Database Administration, Oracle, Oracle Administration

Apr 06 2014

Schedule Reboot Linux System With Crontab

Category: Linux & UnixFatih Acar @ 12:34

You can reboot linux system with crontab. You can use below command for schedule reboot operation.

Schedule Reboot With Crontab

[root@server ~]# crontab -e

10 4 * * * /sbin/shutdown -r now

The system will be reboot every day at 04:10 AM with above schedule.

3,328 total views, 9 views today

Tags: Linux Administration, System Administration

Mar 25 2014

ORA-01031 Insufficient Privileges

Category: Errors and SolutionsFatih Acar @ 09:58

If you want to add new dba user as domain user, you have to add ora_dba group on Windows Systems. If you do not add to this group, you get an error like ORA-01031 insufficient privileges.

ora-01031 insufficient privileges 1

ora-01031 insufficient privileges 1

Continue reading “ORA-01031 Insufficient Privileges”

25,011 total views, 117 views today

Mar 17 2014

CRS-0184 Cannot Communicate With The Crs Daemon in Oracle

Category: Errors and SolutionsFatih Acar @ 17:04

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 cluster -all
[root@node2 bin] ./crsctl start cluster -all

Check CRS

[root@node2 bin] ./crsctl check crs
[root@node2 bin] ./crsctl check cluster -all
Note : All services have to be up.

Run root.sh

Note : If Cluster Virtual IPS not received, You can run root.sh
[root@node2 ~] cd $GRID_HOME
[root@node2 ~] ./root.sh
[root@node2 ~] cd $ORACLE_HOME
[root@node2 ~] ./root.sh

Continue reading “CRS-0184 Cannot Communicate With The Crs Daemon in Oracle”

39,775 total views, 198 views today

Tags: CRS-0184, CRS-2674, CRS-4530, CRS-4534, CRS-4535, Database Administration, Oracle Administration, Oracle Error Solutions

Mar 13 2014

User Types in SAP

Category: SAP BasisFatih Acar @ 10:37

The SAP system categorizes users into several types for different purposes as shown in the table below:

Type Purpose
Dialog Individual, interactive system access.
System Background processing and communication within a system (such as RFC users for ALE, Workflow, TMS, and CUA).
Communication Dialog-free communication for external RFC calls.
Service Dialog user available to a larger, anonymous group of users.
Reference General, non-person related users that allows the assignment of additional identical authorizations, such as for Internet users created with transaction SU01. No logon is possible.

Source : SAP Offical Documents

1,394 total views, no views today

Tags: SAP Basis, Sap System Administration, SAP User Management

Next Page »