Hi All How Can I Shutting Down Oracle 9i DataBase.
Go to command prompt C:\>Set_oracle_sid= c:\> Sqlplus Login with sys as sysdba sql> shutdown immediate this shutsdown the database
Success Consists of Getting Up Just One More Time Than You've Fallen Down Be Blessed
Sorry its C:\> set oracle_sid= sidname no underscore between set and oracle. other solution is log into the console or instance manager and can shutdown the database
if you are on unix... export ORACLE_SID= sqlplus '/as sysbda' shutdown immediate (not everyone works on windows)
Originally posted by Rohit Sorry its C:\> set oracle_sid= sidname no underscore between set and oracle. And no space between = and sidname :-)
Oracle Certified Master Oracle Certified Professional 6i,8i,9i,10g,11g,12c email: ocp_9i@yahoo.com
Forum Rules