Collections:
Start the Default Instance in Oracle
How To Use "startup" Command to Start Default Instance in Oracle?
✍: FYIcenter.com
If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode:
>.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SYSDBA Connected to an idle instance SQL> show instance instance "local" SQL> startup ORA-00821: Specified value of sga_target 16M is too small, needs to be at least 20M
Now the server is telling you more details about the memory problem on your default instance: your SGA setting of 16MB is too small. It must be increased to at least 20MB.
⇒ Instance Settings Stored in SPFile in Oracle
⇐ Login to Server without an Instance in Oracle
2020-09-15, 1553👍, 0💬
Popular Posts:
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...