If database data disk space is full or you have another problem about of disk, you can move datafiles to new disk in MsSQL Server 2008 database.
Show Current Paths and Names
select name,physical_name from sys.master.files where database_id = DB_ID(‘DATABASENAME’)
alter database DATABASENAME modify file(dbf1,filename=’E:\NEWLOCATIOB\disk_1.mdf’);
alter database DATABASENAME modify file(dbf1_log,filename=’E:\NEWLOCATIOB\disk1_log.ldf’);
Move Datafiles to New Disk
Continue reading “How to Move Datafiles to New Disk in MsSQL Server 2008″
320 total views, 15 views today
You can migrate controlfile from file system to asm disk. You have to stop database and you can do that.
SQL> shutdown immediate;
SQL> startup nomount;
RMAN> restore controlfile to ‘+DATA’ from ‘/tmp/controlfile_currentlocation.ctl';
RMAN> restore controlfile to ‘+FRA’ from ‘/tmp/controlfile_currentlocation.ctl';
Continue reading “How to Migrate Controlfile From File System to ASM Disk in Oracle 11g”
850 total views, 20 views today
When you use psql command prompt, system automaticly saves your prompts. If you use password when user creates operation, this situation can occur security risk. Therefore, you can delete this prompts with editing psql_history file like below.
Find And Delete psql Prompts
[root@pg ~]# locate .psql_history
[root@pg ~]# vi /var/lib/pgsql/.psql_history
1,875 total views, 10 views today
SSH service runs on 22 port number. You can change this port number for security. If you use Oracle Linux 7, Centos 7 or Red Hat Linux 7 versions, you can change port number with below operations. If selinux is enabled, you have to add new port number to selinux configuration because of the fact that selinux allows only 22 port number for ssh connections.
Step 1 : Change Port Number
[root #] vi /etc/ssh/sshd_config
Save and Exit
Step 2 : Change Selinux Configuration
[root #] semanage port -a -t ssh_port_t -p tcp 2290
[root #] semanage port -l | grep ssh
Step 3 : Restart SSHD Service to Activate New Confiuration
[root #] systemctl restart sshd.service
1,875 total views, 45 views today
crsctl is Oracle Clusterware management command. You can check, start, stop clusterware with crsctl. crsctl command directory is $GRID_HOME/bin.
You can do below operations with crsctl
- Starting and stopping Oracle Clusterware resources
- Enabling and disabling Oracle Clusterware daemons
- Checking the health of the cluster
- Managing resources that represent third-party applications
- Integrating Intelligent Platform Management Interface (IPMI) with Oracle Clusterware to provide failure isolation support and to ensure cluster integrity
- Debugging Oracle Clusterware components
List Status Of All Crs Services
Continue reading “Oracle Cluster Service Control Commands CRSCTL”
2,455 total views, 5 views today
Logical Volume Manager is a disk partitioning solution on linux systems. This architecture provides advantages. You can extend disk size easily 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”
Logical Volume Manager Architecture
Configure LVM Disks
Continue reading “Linux Logical Volume Manager Configuration And Extend Disk Operation”
10,735 total views, 15 views today
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.
Continue reading “Fstab Cannot Writable”
1,695 total views, 5 views today
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
Continue reading “How to Change Oracle Enterprise Manager Port Number”
2,425 total views, 5 views today
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”
4,800 total views, 10 views today
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
3- Configure Wallet in Oracle Database
Continue reading “How to Create Oracle Wallet for Encrpytion”
2,880 total views, 15 views today