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, 1807🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...