Jan 27 2015

How to Change Oracle Enterprise Manager Port Number

Category: Administration,Database SecurityFatih Acar @ 17:29

If you want to change Oracle Enterprise Manager port number, you can use “emca -reconfig ports -DBCONTROL_HTTP_PORT ” command, this is simple. You can use to take security measure for Oracle EM. I will give 1820 as port for Oracle EM as example.

Change Oracle Enterprise Manager Port

change-oracle-enterprise-manager-port

Continue reading “How to Change Oracle Enterprise Manager Port Number”

110 total views, 15 views today

Tags: Database Administration, Database Security, Oracle Administration, Oracle Security


Dec 23 2014

RMAN Encrypt Backup in Oracle

Category: Backup And Recovery,Database SecurityFatih Acar @ 09:04

You can protect your backups with rman encryption. You have three ways to rman backup encryption. You can use wallet, password or dual mode. I will tell you password protection.

Configure RMAN Backups With Password Protection

rman target /
RMAN> set encryption on identified by ‘yourpassword’ only;

You can backup with backup database command. Do not need to change any backup script.

You can change encryption algorithm on RMAN Configuration.

Show Encryption Algorithm

SQL> select algorithm_id, algorithm_name, algorithm_description, is_default from v$rman_encryption_algorithms;

Change Encryption Algorithm
Continue reading “RMAN Encrypt Backup in Oracle”

1,075 total views, no views today

Tags: Database Administration, Database Security, Oracle Administration, Oracle Backup and Restore, RMAN Encrypt Backup


Dec 22 2014

How to Create Oracle Wallet for Encrpytion

Category: Administration,Database SecurityFatih Acar @ 14:35

Oracle Wallet Manager is a password protected stand-alone Java application tool used to maintain security credentials and store SSL related information such as authentication and signing credentials, private keys, certificates, and trusted certificates.

1- Create Wallet Directory

[oracle@testdb ~] cd $ORACLE_HOME
[oracle@testdb db_home] mkdir -p ORA_WALLETS

2- Write Wallet Location Information in sqlnet.ora File

[oracle@testdb ~] cd $ORACLE_HOME/network/admin
[oracle@testdb db_home] vi sqlnet.ora

oracle_wallet_sqlnetora

3- Configure Wallet in Oracle Database
Continue reading “How to Create Oracle Wallet for Encrpytion”

795 total views, no views today

Tags: Database Administration, Database Security, Oracle Administration, Oracle Security, Oracle Wallet


Dec 20 2014

How to Move Datafile to Different Directory in Oracle

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

You can move datafiles to different directory. You have to make offline tablespace or take mount mode database to change datafiles location. System, temporary and rollback tablespace can move only when database is mount mode.

Show Tablespaces And Datafiles With Locations

SQL> select tablespace_name, file_name from dba_data_files;

Change Location Of Normal Datafile

SQL> alter tablespace TS_TEST offline;
[oracle@testdb oradata] mv /oradata/ts_test01.dbf to /oradata2/
SQL> alter tablespace TS_TEST rename datafile ‘/oradata/ts_test01.dbf’ to ‘/oradata2/ts_test01.dbf';
SQL> alter tablespace online;

Task complated.

Change Location Of System, Temporary or Rollback Tablespace’s Datafiles
Continue reading “How to Move Datafile to Different Directory in Oracle”

990 total views, 5 views today

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


Dec 15 2014

Create DDL Views (RUTDDLSCREATE) Error While Restoring SAP PI

Category: Errors and SolutionsFatih Acar @ 19:52

I got an error while I was restoring SAP PI system. I solved this problem by applying kernel patch.

Error

rutddlscreate_error

Solution
Continue reading “Create DDL Views (RUTDDLSCREATE) Error While Restoring SAP PI”

1,385 total views, no views today

Tags: Create DDL Views Error, SAP Basis, Sap Errors and Solutions, Sap System Administration


Nov 18 2014

How to Copy Only New Files and Changed Files With XCopy on Windows

Category: WindowsFatih Acar @ 17:42

If you want to copy only new files or changed files, you can use xcopy command in batch script file on Windows system.

Copy Only New Files and Changed Files With XCopy

set SourceDir=D:\Source
set TargetDir=F:\Target
xcopy %SourceDir% %TargetDir% /i /d /y

/i /d /y parameters provide that copy only new files and changed files. These detect file modify time changes , but do not notice size changes.

1,335 total views, 15 views today

Tags: System Administration, Windows Batch Script, Windows Server


Nov 14 2014

How to Change Disk Status From Reserved to Online on Windows

Category: VMware,WindowsFatih Acar @ 18:02

I took a clone backup for windows failover cluster system from vmware system which used raw disks. Raw disks automatically converted to vmdk disk via vmware. I restored this clone backup as new standalone server. I started system but my disks were reserved status and I could not use these. I implemented below steps to convert disk status from reserved to online.

Error

diskpart_0

Solution
Continue reading “How to Change Disk Status From Reserved to Online on Windows”

1,795 total views, 10 views today

Tags: Cluster Systems, Disk Status Convert, Reserved Disk to Online Disk, System Administration, Windows Cluster Disks


Nov 13 2014

Add New Datafile to Tablespace With Brtools for Sap System

Category: SAP BasisFatih Acar @ 11:38

If you want to extend tablespace size when using sap system, you should use brtools to add datafile. You can add new datafiles with below brtools operation.

Show All Tablespaces

brtools_1

Add New Datafile With Brtools

Continue reading “Add New Datafile to Tablespace With Brtools for Sap System”

1,800 total views, 25 views today

Tags: Add New Datafile With Brtools, SAP Basis, Sap System Administration


Nov 12 2014

Configure DNS Alias For Network Share Drive on Windows

Category: WindowsFatih Acar @ 11:34

I did not find network share drives after vmware clone operation from windows cluster fail safe SAP CRM to standalone server. \\fcrmsap drive not found. fcrm1 was my hostname.

On Windows machines, file sharing can work via the computer name, with or without full qualification, or by the IP Address. By default, however, filesharing will not work with arbitrary DNS aliases. To enable filesharing and other Windows services to work with DNS aliases, you must make registry changes as detailed below and reboot the machine.

Solution
Continue reading “Configure DNS Alias For Network Share Drive on Windows”

1,880 total views, no views today

Tags: Custom Shared Network Drive, DNS Alias Configure For Network Drive, DNS Name Network Drive, System Administration


Nov 11 2014

How to Add or Remove Java Server Process to SAP Java Instance

Category: SAP BasisFatih Acar @ 11:45

The server processes of the J2EE Engine actually execute the J2EE application. Each server process is multi-threaded, and can therefore process a large number of requests simultaneously. The Java Dispatcher assigns requests to the server processes. You can want to increase java server processes.

Component of Server Process

  • Communication handler
  • Session level services
  • Application-level services or the actual application program.

sap_java_server_process_architecture

If you need to add more server processes to an existing Java instance, you can do that manually using the Config Tool.
Continue reading “How to Add or Remove Java Server Process to SAP Java Instance”

15,700 total views, 50 views today

Tags: SAP Basis, SAP Java ConfigTool, SAP Java Server Process, Sap System Administration


Next Page »