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
RMAN Encrypt Backup in Oracle
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…
How to Create Oracle Wallet for Encrpytion
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…
How to Move Datafile to Different Directory in Oracle
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…
Create DDL Views (RUTDDLSCREATE) Error While Restoring SAP PI
I got an error while I was restoring SAP PI system. I solved this problem by applying kernel patch. Error Solution
How to Copy Only New Files and Changed Files With XCopy on Windows
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….
How to Change Disk Status From Reserved to Online on Windows
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…
PostgreSQL Error : invalid byte sequence for encoding utf8
Error PostgreSQL Error : invalid byte sequence for encoding UTF8 When I try insert a row with Turkish character, I get an error like above. Solution
Add New Datafile to Tablespace With Brtools for Sap System
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 Add New Datafile With Brtools
Configure DNS Alias For Network Share Drive on Windows
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…