Install Oracle database 11g on Windows server 2008 r2 x64

Add privilege administrator to ' ORACLE user '

Fix IP address

set c:\windows\system32\drivers\etc\host
127.0.0.1     localhost
192.168.1.10    hostname ;ex

set all Everonment Variable in 'System variables'

ORACLE_BASE
ORACLE_HOME
ORACLE_UNQNAME

set region in control panel (system locale)

Administrative-> Langauge for non-Unicode Program -> English

OracleMTS Recovery Service error

OracleMTS Recovery Service error

"Windows could not start the OracleMTSRecoverService service on Local Computer. Error 1: Incorrect function.

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0

set key  host to-->  localhost

DUPLICATE Oracle database and set new SID from RMAN Full backup

@target

- full backup rman (controlfile,datafile,archivelog)

- create pfile='initNEW_SID.ora' from spfile;
- change current_instance_name to new_instance_name in pfile
- add *.LOG_FILE_NAME_CONVERT and *.DB_FILE_NAME_CONVERT to last line in pfile

exp:
*.LOG_FILE_NAME_CONVERT='/u01/old_log_file_path','/u02/new_log_file_path'
*.DB_FILE_NAME_CONVERT='/u01/old_data_file_path','/u02/new_data_file_path'


**** for Multiple path Oracle datafile
*.LOG_FILE_NAME_CONVERT='/data1/oradata/ORCLG','/data1/oradata/DUPDB',
                    '/data2/oradata/ORCL','/data2/oradata/DUPDB',
                    '/data3/oradata/ORCL','/data3/oradata/DUPDB'



*.DB_FILE_NAME_CONVERT='/data1/oradata/ORCL','/data1/oradata/DUPDB',
                    '/data2/oradata/ORCL','/data2/oradata/DUPDB',
                    '/data3/oradata/ORCL','/data3/oradata/DUPDB',
                    '/data4/oradata/ORCL','/data4/oradata/DUPDB',
                    '/data5/oradata/ORCL','/data5/oradata/DUPDB',
                    '/data6/oradata/ORCL','/data6/oradata/DUPDB'

- create folder datafile and logfile for new_instance_name

@auxiliary

- startup pfile='initNEW_SID.ora' nomount;
- connect to RMAN by command 'rman auxiliary /'



duplicate database to "newSID" backup location '/backup_rman/oldSID';


trick-2:
create auxiliary by dbca and set new datafile + log file path for newSID

- connect rman as auxiliary  using command

duplicate database to "newSID" nofilenamecheck  backup location '/backup_rman/oldSID';

Enabling Oracle HTTP Server to Run as Root for Ports Set to Less Than 1024 (UNIX Only)

Go to $ORACLE_HOME/ohs/bin
chown root .apachectl
chmod 6750 .apachectl

check $ORACLE_INSTANCE/config/OHS/ohs1/httpd.conf
section:
User oracle
Group group_to_start_apache

set port 
section:
Listen < 1024

SSH Login without Password : Solaris 10, Linux

:ON Solaris 10

ssh-keygen -t rsa
- id_rsa
- id_rsa.pub
@ ~/.ssh
copy id_rsa.pub to remoteHost

scp /export/home/test/.ssh/id_rsa.pub testuser@remotehost:/home/testuser/.ssh

login to remotehost
cat ~/.ssh/id_rsa.pub >> authorized_keys


@server

ssh testuser@remotehost
scp xxx.file testuser@remotehost

:ON LINUX Server

ssh-keygen

ssh-copy-id user@remotehost

ssh user@remotehost

Step by step to add disk to LVM and resize lv

ADD Disk to OS (Linux)

- fdisk -l /dev/sdx and create new partition

- pvcreate /dev/sdx1

- vgdisplay ; list volume group name

CREATE VOLUME

- vgcreate volumn_name /dev/sdd


EXTEND VOLUME

- vgextend vol_group_name /dev/sdx1

CREATE LOGICAL VOLUME

- lvcreate -l 20m -n logical_vol vol_group

- lvcreate -l 100%FREE -n logical_vol vol_group

- lvdisplay ; list logcal volume group name

EXTEND LOGICAL VOLUME

- lvextend -l +100%FREE /dev/vol_group_name/logical_volume
 or
- lvextend /dev/vol_group_name  /dev/sdx1

RESIZE LVM

EXT:

- resize2fs /dev/log_vol_group_name

XFS:

- xfs_growfs /MOUNT_POINT

EXT4:
- resize4fs /dev/log_vol_group_name

NFS Server

create same userID ad groupID between NFS-Server and NFS-Client
for manage Permission