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, 1701🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...