Running the set_system_parameter_oracle_pnet.sql script

Before you create a new Oracle user, ensure that you copy the Oracle folder that contains the set_system_parameter_oracle_pnet.sql script to the Oracle server.

Notes

You must be a SYS user or a user with SYSDBA privileges to run this script.
You must run this script on the Oracle server.
You must use the Auto Memory Management (AMM) option for setting the memory_max_target and memory_target parameters.

Navigate to the Utilities\oracle\11G folder (for Oracle 11.x) or the Utilities\oracle\12C\CDB folder (for Oracle 12c).

Note

Ensure that you navigate to the directory and run the script from the directory.

For example, cd Utilities\Oracle\11G
Run the following command:

(For Oracle 11.x) sqlplus SYS/<password>@ <SID>/<service_name> as sysdba
(For Oracle 12c) sqlplus SYS/<password>@ <CDB>/<service_name> as sysdba
Run the set_system_parameter_oracle_pnet.sql script on the Oracle server.

SQL> @set_system_parameter_oracle_pnet.sql
Restart the Oracle database. The script verifies whether the set parameters appears in the Oracle database.
If you have already created users in Oracle, create user accounts and tablespaces for these users. You can do this by any one of the following methods:
- Manual method: To create tablespaces and users manually, see Creating tablespaces and user accounts
- Through the run_oracle_db_scripts.sql script. For more information, see Running the run_oracle_db_scripts.sql script in a standalone Oracle environment and Running the run_oracle_db_scripts.sql script in an Oracle RAC environment.

Note

You can also create new users using the Infrastructure Management installer. For more information, see Installing BMC TrueSight Infrastructure Management Server with Oracle as the database.

Running the set_system_parameter_oracle_pnet.sql script

Comments