How to drop oracle 12c instance on linux

oracleoracle-12c

I have created an Oracle 12c container db instance. I need to drop the instance. What's the most effective way to drop instance?

Best Answer

$ sqlplus / as sysdba
SQL> startup force mount exclusive restrict
SQL> drop database;

Related Solutions

12c Shell to Linux

If you're on at least 11g, the method is deprecated, as DBMS_SCHEDULER functionality is capable of calling a shell script or C program.

However, if you really want to do it this way, you can set ENVS in the definition of the SID_LIST_your_external_proc_listener_name.

See MOS Doc ID 99136.1 for more details.

Hope that helps.

Oracle – Password of the Oracle User in Oracle Linux

The oracle-rdbms-server-12cR1-preinstall package includes a bash script that creates the oracle user, if not already existing, using the useradd command.

In this case in log file /var/log/oracle-rdbms-server-12cR1-preinstall/results/orakernel.log you should see this entry:

Please set password for oracle user

You can run the following command as root to assign a password:

# passwd oracle

Best Answer

Related Solutions

12c Shell to Linux

Oracle – Password of the Oracle User in Oracle Linux

Related Question