Sep 18 2014

Error: Cluster Disk 1 Does Not Support Persistent Reservations.

Category: VMware,WindowsFatih Acar @ 15:21

While I installing Windows Failover Cluster system, I get 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.”

72 total views, 18 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”

3,672 total views, 54 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)”

39,897 total views, 162 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”

3,695 total views, 18 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.

2,869 total views, 18 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”

18,567 total views, 72 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.


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

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

23,269 total views, 135 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,097 total views, no views today

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

Feb 25 2014

Error : Cannot Open User Default Database in MsSQL Server

Category: Administration,Errors and SolutionsFatih Acar @ 17:21

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.


Cannot open user default database. Login failed.


Open CMD prompt
C:\>sqlcmd -E -d master
1> alter login [domain\LoginUser] with default_database = master
2> go
3> quit

2,468 total views, no views today

Tags: Database Administration, MsSQL Server, SQL Server Administration

Feb 12 2014

Create DB Connection From SAP to External Databases

Category: SAP BasisFatih Acar @ 15:16

That scenario is required that we need to fetch data from the customer’s existing third party application. For example the customer is having some websites where the enquiries are being stored. Or The company employees who are on tour log their requests for leave in the portal. In such case we may have to provide an interface between their existing application to the upcoming SAP system. It is possible that the system is using a different database altogather. So in that situation how a connectivity is established between the SAP database and External Application database.

You can create connection to external database with below processes.

1 – Connection check from SAP to External Database

You have to access external database from SAP network. You can check firewall, telnet configuration.

Continue reading “Create DB Connection From SAP to External Databases”

10,062 total views, 72 views today

Tags: SAP Basis, SAP DBCO Connection, Sap System Administration, System Administration

Next Page »