How to Move Datafiles in Oracle Database 12c (12.1 & 12.2) Online

Prior to Oracle 12c, moving datafiles has always been an offline task. There were certain techniques you could employ to minimize that downtime, but you couldn’t remove it completely. Oracle 12c includes an enhancement to the ALTER DATABASE command to allow datafiles to be moved online. This is one of feature which i liked inContinue reading “How to Move Datafiles in Oracle Database 12c (12.1 & 12.2) Online”

How to install Container Only 12c Database on Solaris

Hello Guys, in this blog i will be installing Oracle 12c Container only Database, why i am doing this to understand the whole architecture easily. As we know in Oracle 12c architecture we usually have 3 containers: CDB (root) SEED (template) PDB ( based on template) We can have maximum of 253 PDBs in 1Continue reading “How to install Container Only 12c Database on Solaris”

How to get SSH Login in Solaris 10

By default Solaris 10 will not give you access to root access unless you don’t do modification as per below recommendations: At first check out the ssh configuration file and find out what is the value for PermitRootLogin in this file and make it yes if its no. to Restart the ssh service by belowContinue reading “How to get SSH Login in Solaris 10”

How to configure IP Address in Solaris 10 Manually

Hello Guys, I also faced the same problem where i did not configure the IP while installing the OS and decided to configure it later on and i did not know how to do that either. Finally I searched on google and, i hope the below way will help many who is trying to achieveContinue reading “How to configure IP Address in Solaris 10 Manually”

UX: useradd: ERROR: Inconsistent password files. See pwconv(1M).

Recently I was trying to create an Oracle user on Solaris 10 and i got this error while giving useradd command. bash-3.2# useradd -g oinstall -G dba -d /export/home/oracle -s /usr/bin/bash oracle UX: useradd: ERROR: Inconsistent password files. See pwconv(1M). bash-3.2# To resolve this error i did some search and find out to verify contentContinue reading “UX: useradd: ERROR: Inconsistent password files. See pwconv(1M).”