Feb 18 2015

Linux Logical Volume Manager Configuration And Extend Disk Operation

Category: Linux & UnixFatih Acar @ 11:38

Logical Volume Manager is a disk partitioning solution on linux systems. This architecture provides advantages. You can extend disk size easyly with lvm without losing exist data. But, If you use fdisk that is classical method for partition, you can not resize this partitions without losing data.

You can follow below steps to configure lvm.

LVM Creation Steps

1- Disk partition “cfdisk”
2- Create physical volume “pvcreate”
3- Create virtual group “vgcreate”
4- Create logical volume “lvcreate”
5- Format logical volume “mkfs.ext4″
6- Add Fstab “vi /etc/fstab”

LVM Architecture

Logical Volume Manager Architecture

Logical Volume Manager Architecture

Configure LVM Disks
Continue reading “Linux Logical Volume Manager Configuration And Extend Disk Operation”

355 total views, 5 views today


Feb 12 2015

Fstab Cannot Writable

Category: Linux & UnixFatih Acar @ 09:41

If you mount disk with wrong uuid or wrong text in fstab file, you get an error when system restart. Your system can not open. If you want to change fstab, you can not change this file because of read only. You can change this status with “mount -o remount,rw /” command. This command provides that system takes maintenance mode. /etc/ directory’s below files will be writable.

Error

fstab1

Solution
Continue reading “Fstab Cannot Writable”

190 total views, 5 views today

Tags: fstab, Linux Administration, Linux Error and Solution, Oracle Linux, System Administration


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”

495 total views, 5 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,675 total views, 15 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”

1,165 total views, 10 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”

1,585 total views, 30 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”

2,155 total views, 15 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,600 total views, 10 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”

2,480 total views, 15 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”

2,495 total views, 25 views today

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


Next Page »