Change the SYS, SYSTEM password
The password can be specify when in the create database syntax, if not specify, the below default password would be given.
- system: manager
We have to change it to something else.
alter user USERID identified by PASSWORD;
Create the oracle password file to enable the remote login as sysdba
Create Data Dictionary and Build-in Package
Run as sys
Create SQL PLUS related tables
If pupbld.sql has not been run, when connect to the database with SQL PLUS, we would get the below error.
Run as system
Migrate the SYSTEM tablespace to local management
Please see here