Script File Execution and related configuration after Oracle 11g database is created

Assume that no instance is created, no SCOTT user, and no EMP file are created when you create an Oracle database.

Execute the following script files:

Path: {ORACLE_HOME} \ RDBMS \ ADMIN

1. SQL> @ .. \ utlsampl. SQL (********)
Used to create a SCOTT user and some tables under the user, such as EMP and DEPT.
After execution, the SQL command page is exited and the system returns to cmd. Enter again and use

Select username from dba_users order by username; you can see that the scott user has been created.

SQL> conn scott/tiger;

2. SQL> @ .. \ catalog. SQL (*******)
Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for example of the views. Grants PUBLIC access to the synonyms

3. SQL> @ .. \ catproc. SQL (*******)
Runs all scripts required for or used with PL/SQL.

4. SQL> @ .. \ PUPBLD. SQL :(***)
Required for SQL * Plus. Enables SQL * Plus to disable commands

5. SQL> @ .. \ DBMSSTDX. SQL:
Before a trigger can be created, the user SYS must run this SQL script

6. SQL> @... \ STANDARD. SQL:
Before run PL/SQL, the user SYS must run this SQL script

Check whether the current database version is consistent with the system version, for example, 32-bit/64-bit
Select * from v $ version; (sys)

To prevent slow startup, log on to services. msc to close oracle services and enable oracle services as needed. That is, change to manual instead of starting oracle at startup.

Configure Net Configuration Assistant, including the listener and related service names.