Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
Using SQL*Plus to create PATROL database user
ORACLE_AUTO_CONFIG requires an OS authenticated account. Use the following procedure to create that user.
To create a PATROL database user by using SQL*Plus
- Open a command line and navigate to the AutoDBConfig directory:
$ cd ${PATROL_HOME}/oracle/AutoDBConfig - Enter the following:
$ sqlplus 'DBA ACCOUNT/DBA PASSWORD AS SYSDBA'
The following text is displayed: SQL> start ORACreateUser.sql - When prompted, enter a user name.
- In Unix: ops$patrol
In windows: if local account is used then OPS$HOSTNAME\PATROL and in case of domain account use OPS$DOMAIN\PATROL
When prompted, enter default, temporary tablespaces, and profile.
The user is created.
Auto configuration supports only a user that is validated by the operating system (OS). Typically, such a user has an Oracle account named after the OS user with ops$ prepended.
For example, to create an OS-validated account (which is an Agent logon account) for John Smith (jsmith), you would create one called ops$ jsmith in UNIX Environment
and in windows it would be OPS$HOSTNAME\JSMITH or OPS$DOMAIN\JSMITH- When John Smith logs into the system at the OS level, he enters jsmith and his OS password to log in. He should then be able to connect to the Oracle database by entering the following:
$ sqlplus /
The following should display: SQL>