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

iSCSI on Solaris 10 x86

-Check iSCSI Service

svcs -a | grep iscsi
svcadm enable svc:/network/iscsi_initiator

-iSCSI setup initiator

iscsiadm add discovery-address 192.168.1.10:3260
iscsiadm modify initiator-node -a CHAP
iscsiadm modify initiator-node -H username
iscsiadm modify initiator-node -C
(specify CHAP password)

-iSCSI send target for Enable

iscsiadm modify discovery --sendtargets enable <--- for enable target
iscsiadm modify discovery --sendtargets disable <--- for disable target

iscsiadm list target
iscsiadm add static-config iqn.2015-11.com.wdc:wdsentinel-01-oracle-rman,192.168.1.10:3260
devfsadm -c iscsi

remote orphaned user from office365

Power shell
-logon to office365

$credential = Get-Credential
Import-Module MsOnline
Connect-MsolService -Credential $credential
Get-MsolAccountSku

-remove command   

Remove-MsolUser -UserPrincipalName <account id>
Remove-MsolUser -UserPrincipalName <account id> -RemoveFromRecycleBin