Users Guide

Installing Oracle | Oracle Database Management
168 OMNM 6.5.3 Installation Guide
2 Increase Oracle's default processes limit:
SQL> alter system set processes=300 scope=spfile;
System altered.
If you do not set this limit to 300, you may get the following error while running the
dbpostinstall command.
ORA-12519, TNS:no appropriate service handler found
3 Set Oracle to use case insensitive passwords:
SQL> alter system set SEC_CASE_SENSITIVE_LOGON = FALSE;
System altered.
4 Change Oracle's default HTTP port:
SQL> call dbms_xdb.sethttpport('8081');
Call completed.
5 Log out of Oracle:
SQL> exit
Disconnected from Oracle Database
6 Restart Oracle database service for changes to take effect.
For example, on Windows:
net stop OracleServiceXE
net start OracleServiceXE
Initial Oracle Installation Testing
Run the following as system before running loaddb, and as the OpenManage Network Manager
user before starting the application server to validate the success of loaddb's user creation:
• Verify your application server can access the Oracle server. Use the following command to do
this:
pingdb -u <username> -p <password>
• Although Oracle's installation offers options to select replication in one of the Oracle trees in
addition to Default, this application's installation supports only Default. Any Oracle
database's high availability feature support is outside this application's JDBC connection to
the database (you must use Oracle's RAC technology or equivalent).
Initial Database Setup
Creating an Oracle user for the application server is unnecessary. OpenManage Network Manager’s
installation scripts create all required schema objects for the application server. Follow these steps
to configure your database for use with OpenManage Network Manager.
1 After the OpenManage Network Manager Installer finishes, source the oware environment
in a shell to execute the following commands.
Windows:
oware
Linux: . /etc/.dsienv