Step 6: Connect to the Instance

Start SQL*Plus and connect to your Oracle Database instance with the SYSDBA administrative privilege.

azure training courses malaysia

• To authenticate with a password file, enter the following commands, and then enter the SYS password when prompted: $ sqlplus /nolog SQL> CONNECT SYS AS SYSDBA
• To authenticate with operating system authentication, enter the following commands: $ sqlplus /nolog SQL> CONNECT / AS SYSDBA

aws training courses malaysia

Step 7: Create a Server Parameter File

The server parameter file enables you to change initialization parameters with the ALTER SYSTEM command and persist the changes across a database shutdown and startup. You create the server parameter file from your edited text initialization file.

angular training courses malaysia

This SQL*Plus command reads the text initialization parameter file (PFILE) with the default name from the default location, creates a server parameter file (SPFILE) from the text initialization parameter file, and writes the SPFILE to the default location with the default SPFILE name.

You can also supply the file name and path for both the PFILE and SPFILE if you are not using default names and locations.

ai and machine learning training courses malaysia