Online DBA

<<Back to Oracle ASM Main Page ORA-15000: command disallowed by current instance type $ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Mon Jun 18 14:07:01 2018 Copyright (c) 1982, 2016, Oracle.  All rights reserved. SQL> conn ASM_PER1 Enter password: ERROR: ORA-15000: command disallowed by current instance type ASM instance accepts command allowed to ASM and RDBMS accepts command allowed to RDBMS and therefore check and re-issue the command Action Check following  1) Correct ORACLE_SID and ORACLE_HOME is set 2) Correct privileges is granted and is used while connecting (eg username as sysasm) 3) If connecting over listener check tnsentry is correct and tnsping resolves it $ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Mon Jun 18 14:07:29 2018 Copyright (c) 1982, 2016, Oracle.  All rights reserved. SQL> conn ASM_PER1 as sysasm Enter password: Connected. SQL> $ oerr ora 15000 15000, 00000, "command disall...

<<Back to Oracle ASM Main Page How to Clean Shutdown an Oracle ASM Instance It is strongly recommended that you shut down all database instances that use the Oracle ASM instance and dismount all file systems mounted on Oracle ASM Dynamic Volume Manager (Oracle ADVM) volumes before attempting to shut down the Oracle ASM instance. ASM instance can be brought down in NORMAL, IMMEDIATE or TRANSACTIONAL and in ABORT mode similar like DB Instance SHUTDOWN NORMAL: Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Before the instance is shut down, Oracle ASM waits for all of the currently connected users to disconnect from the instance. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. NORMAL is the default shutdown mode. SHUTDOWN IMMEDIATE or TRANSACTIONAL Oracle AS...

<<Back to Oracle ASM Main Page How to Connect to an ASM Instance set ORACLE_SID environment variable to the Oracle ASM system identifier (SID). You can find ASM SID using ps command $ps -ef|grep pmon |grep asm oragrid  30609     1  0 Jun08 ?        00:00:21 asm_pmon_+ASM export ORACLE_SID=+ASM set ORACLE_HOME environment variable to the Grid Infrastructure home where Oracle ASM was installed $ps -ef|grep crs oragrid   5421     1  0 Jun05 ?        00:00:14 /u01/oragrid/12.2.0.1/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit $export ORACLE_HOME=/u01/oragrid/12.2.0.1/grid $export PATH=$PATH:$ORACLE_HOME/bin How to Start ASM Instance logina s sysasm $sqlplus "/as sysasm" S tartup SQL>startup Starting Up an Oracle ASM instance with an Incorrect SPFILE Path locate the spfile  /u01/oragrid/spfile/spfileASM.or...

<<Back to DB Administration Main Page Droping the Database in Silent Mode Using DBCA $ export ORACLE_HOME=/u01/dbatest1/12.2.0.1/dbp1 $ export PATH=$PATH:$ORACLE_HOME/bin $dbca -silent -deleteDatabase -sourceDB TESTDB -forceArchiveLogDeletion -sysDBAPassword xxxxxxx -sysDBAUserName sys Connecting to database 4% complete 9% complete 14% complete 19% complete 23% complete 28% complete 47% complete Updating network configuration files 48% complete 52% complete Deleting instance and datafiles 76% complete 100% complete Look at the log file "/u01/dbatest1/cfgtoollogs/dbca/TESTDB.log" for further details. Note : If you are deleting the database in silent mode, DBCA will not prompt you for any confirmation Lets Check the Log $cat /u01/dbatest1/cfgtoollogs/dbca/TESTDB.log [ 2018-06-18 11:14:01.891 CEST ] The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the database will be destroyed. Do you wa...

<<Back to DB Administration Main Page How to Create Database in Silent Mode Using Response File and Custom Template Related Posts How to Install Oracle 12c Database Software in Silent Mode Installing Grid Infrastructure for a Standalone Server and Configuring ASM Instance in Silent Mode Assumption: The post is based on following assumption DB Software is already Installed ASM is used ASM Instance is up and running Diskgroups are already created and mounted by ASM instance Note:- Visit the related posts in case you need to complete the assumptions in this post Contents of response file and template file used in this post are provided below $ export ORACLE_HOME=/u01/dbatest1/12.2.0.1/dbp1 $ export PATH=$PATH:$ORACLE_HOME/bin $ dbca -silent -createDatabase -responseFile /u01/dbatest1/12.2.0.1/dbp1/dbca_wd.rsp Registering database with Oracle Restart 1% complete Creating and starting Oracle instance 2% complete 3% complete 5% complete Creating database...