Oct 20 2014

Background Job Not Released as Periodic in SAP PI RWB Errors

Category: Errors and Solutions,SAP BasisFatih Acar @ 17:03

I got errors about of background jobs not scheduled in SAP PI rwb interface. I resolved this problems with create background jobs with SM36 TCode.

Error

SAP_PI_13

Solution
Continue reading “Background Job Not Released as Periodic in SAP PI RWB Errors”

297 total views, 27 views today

Tags: SAP Background Jobs, SAP Basis, Sap Errors and Solutions, SAP Periodic Tasks, Sap System Administration


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

1

2
Continue reading “How to Install Oracle Enterprise Linux 7″

369 total views, 9 views today

Tags: Oracle Linux, System Administration


Oct 10 2014

SAP PI rwb (runtime work bench) Authorization Error

Category: Errors and SolutionsFatih Acar @ 16:13

I got an error when connect to rwb (run time workbanch) in SAP PI. I could resolve after SAP PI role groups added to user in NWA > Configuration > Identity Management > Select User and Modify.

Error

You are not authorized to view the requested resource.

Details: No details available

Solution

You have to assign groups to user.

SAP PI NWA > Configuration > Identity Management > Select User and Modify.

Groups:

SAP_XI_MONITOR
SAP_SLD_GUEST
SAP_XI_BPE_MONITOR_ABAP
SAP_XI_DEMOAPP
SAP_XI_MONITOR_ABAP
SAP_XI_MONITOR_J2EE

252 total views, no views today

Tags: SAP Basis, Sap Errors and Solutions


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.

RMAN> STARTUP MOUNT;
RMAN> SQL ‘ALTER SYSTEM ENABLE RESTRICTED SESSION';
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;

Continue reading “How to Drop Oracle Database With RMAN”

936 total views, no 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.”

1,143 total views, no 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.

Error

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

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

6,165 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

EXEC SP_CONFIGURE ‘Agent XPs’

Reconfigure Agent XPs

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

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,937 total views, 9 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,559 total views, no 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,454 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.
Error

ora-01031 insufficient privileges 1

ora-01031 insufficient privileges 1

Solution
Continue reading “ORA-01031 Insufficient Privileges”

26,847 total views, 189 views today


Next Page »