How to set up the Oracle Wallets in Oracle Database Brief about the Oracle Wallets The Oracle Wallet is a container or we can called it as repository that stores authentication and credentials such as certificates, certificate requests, and private keys., By using this we can connect to db without providing the schema name & Read More

How to Install Docker on UBUNTU Server Check the IP address to assign into the resolv.conf file nameserver 178.22.***.*** ubuntu@mir-docker-test:~$ sudo cat /etc/resolv.conf nameserver 178.22.***.***— this file is added nameserver 127.0.0.53 options edns0 search openstacklocal This command will remove if any Docker is… Read more..

Installation of Ansible Packages in Oracle Linux Download the below require Packages to configure ansible. [root@ansible-test]# cd /u02/SOURCE/RPM_PKG/ansible/ [root@ansible-test]# ll total 17808 -rwxrwxrwx. 1 root root 17832207 Oct 29 15:26 ansible-2.9.27-1.el7.noarch (2).rpm -rwxrwxrwx. 1 root root 42303 Oct 29 15:26 python2-jmespath-0.9.4-2.el7.noarch… Read more..

Cannot open the Pluggable DB due to ORA-65086: cannot open/close the pluggable database Check the status of database SQL> select instance_name, open_mode, version from V$database, v$instance; INSTANCE_NAME OPEN_MODE VERSION —————————————– ORA19c READ WRITE 19.0.0.0.0 Perform the Unplug… Read more..

Error occur while dropping tablespace as ORA-23515: materialized views and/or their indices exist in the tablespace Drop the tablespace SQL> drop tablespace MGMT_TABLESPACE including contents and datafiles; drop tablespace MGMT_TABLESPACE including contents and datafiles * ERROR at line 1: ORA-23515: materialized views and/or… Read more..

How to login the user schema without knowing the password in Oracle Database 19c Note: – This scenario is to login to the user without knowing the password & perform some test operation purpose only. – You can change/re-set the user password with new password but inconvenience to the end user. – Therefore the Oracle… Read More