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”

2,367 total views, 36 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)”

13,878 total views, 1,404 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”

2,993 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.

2,419 total views, no 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”

15,417 total views, 45 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”

16,987 total views, 171 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

962 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,126 total views, 9 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”

8,334 total views, 27 views today

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

Feb 04 2014

SAP Security Audit Log Activation

Category: SAP Basis,System SecurityFatih Acar @ 14:52

As of Release 4.0, you can use the Security Audit Log to record security-related system information such as changes to user master records or unsuccessful logon attempts. This log is a tool designed for auditors who need to take a detailed look at what occurs in the SAP System. By activating the audit log, you keep a record of those activities that you specify for your audit. You can then access this information for evaluation in the form of an audit analysis report.
The Security Audit Log provides for long-term data access. The audit files are retained until you explicitly delete them. Currently, the Security Audit Log does not support the automatic archiving of the log files; however, you can manually archive them at any time.

SAP Security Audit Log

You can record the following information in the Security Audit Log

  • Successful and unsuccessful dialog logon attempts
  • Successful and unsuccessful RFC logon attempts
  • RFC calls to function modules
  • Changes to user master records
  • Successful and unsuccessful transaction starts
  • Changes to the audit configuration

SAP Security Audit Log Activation Steps

1 – Create Profile

Tcode > SM19

SAP Security Audit Log 1

SAP Security Audit Log 1

SAP Security Audit Log 2

SAP Security Audit Log 2

Continue reading “SAP Security Audit Log Activation”

7,470 total views, 54 views today

Tags: SAP Basis, SAP Security Audit Log, Sap System Administration, System Administration, System Security

Next Page »