Durham Oracle

Oracle PDB cloning in OCI with RAC / TDE and DataGuard enabled

Doc ID 1916648.1

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=339297523964641&id=1916648.1&_afrWindowMode=0&_adf.ctrl-state=5cqsp6ypb_4#aref_section24

Worthwhile as there are lots of pitfalls , basically DG breaks unless handled correctly.

This non oracle guide is useful as well if you find it has broken.

https://database-heartbeat.com/2020/12/31/create-pdbs-in-a-data-guard-environment-with-tde-enabled/

New user - linux password issue

Hit a problem today changing a new user password today in Linux.

[root@prd01oua-dbg2 ~]# passwd emcadm

Changing password for user emcadm.

passwd: Authentication token manipulation error

[root@prd01oua-dbg2 pam.d]# ls -ls system-auth

4 -rw-r--r-- 1 root root 1205 Feb 2 10:51 system-auth

In system.auth

password requisite pam_pwquality.so try_first_pass local_users_only retry=3 authtok_type=

#password sufficient pam_unix.so md5 shadow nullok try_first_pass use_authtok

password required pam_deny.so

change to

password requisite pam_pwquality.so try_first_pass local_users_only retry=3 authtok_type=

password sufficient pam_unix.so md5 shadow nullok try_first_pass use_authtok

password required pam_deny.so

Next we hit a password length problem

[root@prd01oua-dbg2 pam.d]# passwd emcadm

Changing password for user emcadm.

New password:

BAD PASSWORD: The password is shorter than 15 characters

/etc/security/pwquality.conf

# Password Minimum Length should be configured

minlen=8

Changing password for user emcadm.

New password:

Retype new password:

passwd: all authentication tokens updated successfully.

[root@prd01oua-dbg1 security]#

Et voilla.....

Weblogic Version

Needed to quickly check the Weblogic version that I was using - quick notes.

From $WL_HOME/server/lib run this :

[oracle@dev01-wls-1 lib]$ pwd

/u01/app/oracle/products/fmw_12214/wlserver/server/lib

[oracle@dev01-wls-1 lib]$ java -cp weblogic.jar weblogic.version -version -verbose

WebLogic Server 12.2.1.4.0 Thu Sep 12 04:04:29 GMT 2019 1974621 ImplVersion: 12.2.1.4.0

Oracle Security Developer Tools Security Engine ImplVersion: 3.1.0

Oracle Security Developer Tools Crypto ImplVersion: 3.1.0

Oracle Universal Connection Pool ImplVersion: 19.3.0.0.0

etc...

There are other ways to check the version but this seems to the easiest and most comprehensive.

Download :