Manage Oracle with Mobile Admin

This document provides information about how to use the Mobile Admin Client to manage Oracle servers.

The procedures in this chapter assume that:

• You are logged in to Mobile Admin;
• You have selected a server that hosts Oracle from your Manage Hosts list, or selected the Oracle service from the Manage Services list.
• You selected the Oracle Enterprise Manager icon to open the Oracle Enterprise Manager screen.

Detection

Oracle is been detected if a successful TCP connection can be made to port 1521 or other user configured ports.

Authentication

Mobile Admin will prompt you for Oracle credentials.

Communication method

The .NET OracleClient library is used for management.

Manage the databases

You can manage Oracle databases with Mobile Admin.

Add and remove a database

1. From the Oracle Enterprise Manager screen, select the Add Database option on the menu.
2. In the Database SID field, type the name of the system identifier (SID) for the database.
3. On the menu or the Add Database screen, click Add.

To remove a database:

1. Select the the database you with to remove.
2. Click Remove on the menu.

Manage instances and sessions

You can manage Oracle server instances and sessions with Mobile Admin.

View instance configurations

1. From the Oracle Enterprise Manager screen, select the database you want to use.
2. Select the Instance icon.
3. Select the Configuration icon.

View session information

1. From the Oracle Enterprise Manager screen, select the database for which you wish to view session information.
2. Select Instance.
3. Select Sessions.
4. Select the session that you want to view.

Kill a session

Follow the procedure for viewing session information to select the session that you want to kill.

On the menu, click Kill Session.

Manage schemas

You can manage Oracle server schemas with Mobile Admin, including tables, views, sequences and procedures.

View schema information

1. From the Oracle Enterprise Manager screen, select database that you want to use.
2. Select Schema.

View columns and statistics for a table

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Tables.
3. Do one of the following:
   1. To view column information, select Columns.
   2. To view table statistics, select Statistics.

Remove a table

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Tables.
3. On the menu, click Remove.

View a view

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Views.

Create a view

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Views.
3. On the menu, click Create.
4. Complete the following fields:
   • Name – Enter a name for the view.
   • Schema – Displays the name of the schema.
   • Query Text – Type the SQL query text that defines the view.
   • Aliases – Type any synonyms for the view. [optional]
   • Replace if Exists – Select this check box to indicate that a trigger is to be recreated (if it already exists) without dropping, recreating and regenerating object privileges previously granted.
5. On the menu, click Create.

Edit a view

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Views.
3. Select the view you want to edit.
4. Edit the fields as required.
5. Save your changes by selecting Apply on the menu.

Remove a view

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Views.
3. Select the view you want to remove.
4. On the menu, click Remove.

View and edit a sequence

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Sequences.
3. Select the sequence you want to view.
4. To edit a sequence, make the desired changes and select Apply on the menu.

Create a sequence

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Sequences.
3. On the menu, click Create.
4. Complete the following fields:
   • Name – Type a name for the sequence.
   • Schema – Displays the name of the schema.
   • Type – Select Ascending to create a sequence where values increase from the initial value towards the maximum value. Select Descending to create a sequence where values decrease from the initial value towards the minimum value.
   • Minimum – Type the minimum allowed value of the sequence.
   • Maximum – Type the maximum value of the sequence.
   • Interval – Type the interval by which the sequence increases or decreases.
   • Initial – Type the starting value of the sequence.
   • Cycle Values – When selected, the sequence will continue to generate values after reaching its minimum or maximum value.
   • Order Values – When selected, the sequence numbers will be generated in order of request.
   • Cache – Select Default to use the default value of 20. Select No Cache to specify that the values of the sequence not be pre-allocated. Select Size to enter a cache size value. For sequences that cycle, this value must be less than the number of values in the cycle. If the maximum number of values the sequence can generate is less than the cache size, the cache size will be automatically changed to the maximum number of possible values.
   • Cache Size – Type the number of values to be pre-allocated and stored by the database.
5. On the menu, click Create.

Remove a sequence

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Sequences.
3. Select the sequence you want to remove.
4. Click Remove on the menu.

Access and editing a stored procedure

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Source Types.
3. Select Procedures and then select the procedure that you want to view.
4. To edit a procedure, select the procedure that you want to make changes to, make the desired changes, and then select Apply from the menu.

Create a stored procedure

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Source Types.
3. Select Procedures.
4. On the menu, click Create.
5. Complete the fields as desired.
6. Click Create on the menu.

Remove a stored procedure

1. Follow the procedure for viewing schema information to select the schema you want to use.
2. Select Source Types.
3. Select Procedures.
4. Select the procedure you want to remove.
5. Click Remove.

Manage security

You can manage Oracle server security with Mobile Admin, including users, roles, and profiles.

View and edit users

1. From the Oracle Enterprise Manager screen, select the database that you wish to use.
2. Select Security.
3. Select Users.

To edit a user:

1. Make the desired changes in the Profile and Status fields.
2. Select Apply from the menu.

Create a user

1. Follow the procedure to view users and select Create from the menu.
2. Complete the following fields:
   • Username – Enter the username that the new user will use to access the Oracle database.
   • Password – Enter a password for the user.
   • Confirm Password – Re-enter the password.
   • Expire Password Now – Select this check box to force the user to change their password upon login.
   • Profile – Choose from the existing profiles.
   • Default Tablespace – Choose from the existing tablespaces.
   • Temporary Tablespace – Choose from the existing tablespaces.
3. On the menu, click Create.

Remove a user

1. Follow the procedure to view users and select the user that you want to remove.
2. On the menu, click Remove User.

Reset a password

1. Follow the procedure to view users and select the user whose password you wish to reset.
2. On the menu, click Reset Password.
3. Complete the following fields:
   • Password – enter a new password for the user.
   • Confirm Password – re-enter the new password.
   • Expire Password Now – select this check box to force the user to change their password upon login.
4. On the menu, click Apply.

View the roles granted to a user and add a new role

1. Follow the procedure to view users and select the user whose roles you wish to view or add to.

   To view the roles granted to the user, click Role on the menu.

   To add a new role, click Add on the menu, and select the role that you wish to add for the user.

2. Select the preferred settings for the role selected.
3. Click Apply on the menu or on the Add a New Role screen.

Revoke a role granted to a user

1. Follow the procedure to view users and select the user whose profile you wish to edit.
2. On the menu, click Role.
3. Select the role that you want to revoke.
4. On the menu click Revoke.

View and add system privileges granted to a user

1. Follow the procedure to view users and select the user whose privileges you wish to view.

   To view system privileges for the user, click System on the menu.

   To add system privileges for the user, click Add from the menu.

2. Select the privilege you want to grant to the user and click Grant from the menu.

Revoke system privileges from a user

1. Follow the procedure to view users and select the user for whom you wish to revoke a system privilege.
2. On the menu, click System.
3. Select the system privilege that you want to revoke.
4. On the menu, click Revoke.

View a list of available roles

1. From the Oracle Enterprise Manager screen, select the database that you wish to view roles for.
2. Select Security.
3. Select Roles.

Create, editing, and remove a role

Follow the procedure to view a list of available roles.

To create a role:

1. Click Create on the menu.
2. Complete the required fields and select Create.

To edit a role:

1. Navigate to the role you wish to edit, make the desired modifications.
2. Select Apply.

To remove a role:

1. Navigate to the role you wish to remove.
2. Select Remove Role from the menu.

View system privileges granted to a role

1. Follow the procedure to view a list of available roles and select the role for which you wish to view associated privileges.
2. On the menu, click System.

Add and revoke privileges to and from a role

Follow the procedure to view a list of system privileges for the role whose priveleges you wish to revise.

To add system privileges:

1. Click Add on the menu.
2. Scroll to the system privilege that you want to grant to the role.
3. On the menu, click Grant.

To revoke system privileges:

1. Select the privileges you wish to revoke.
2. Click Revoke on the menu.

Add and revoke roles to and from an existing role

1. Follow the procedure to view a list of available roles and select the role that you want to add additional roles to or revoke roles from.
2. On the menu, click Roles.

To add a role:

1. Click Add on the menu.
2. Select the role you would like to add to the current role.

To revoke a role:

1. Select the role you wish to revoke.
2. Click Revoke on the menu.

View a list of profiles

1. From the Oracle Enterprise Manager screen, select the database that you want to view profiles for.
2. Select Security.
3. Select Profiles.

Create a profile

Follow the procedure to view a list of profiles.

1. On the menu, click Create.
2. Complete the following fields:
   • Name – Type a name for the profile.
   • CPU/Session (Sec./100) – Type a limit for the CPU time for a session, in hundredths of a second.
   • CPU/Call (Sec./100) – Type a limit for the CPU time for a call, in hundredths of a second.
   • Connect Time (Minutes) – Type a limit for the total elapsed time for a session, in minutes.
   • Idle Time (Minutes) – Type a limit for a period of inactive time during a session, in minutes.
   • Concurrent Sessions (Per User) – Type a limit to the number of concurrent sessions allowed for a user with this profile.
   • Reads/Session (Blocks) – Type a limit for the number of data blocks read in a session, including blocks read from memory and disk.
   • Reads/Call (Blocks) – Type a limit for the number of data blocks read for a call to process a SQL statement.
   • Private SGA (Kbytes) – Type a limit for the amount of private space a session can allocate in the shared pool of the System Global Area (SGA) to integer bytes.
   • Composite Limit (Service Units) – Type a limit for the total resource cost for a session.
3. On the menu, click Apply.

Remove a profile

1. Follow the procedure to view a list of profiles and select the profile you wish to remove.
2. Click Remove on the menu.

View and edit a profile

1. Follow the procedure to view a list of profiles and select the profile you wish to view or edit.
2. Edit the fields as required.
3. On the menu, click Apply.

Edit the password policies of a profile

1. Follow the procedure to view a list of profiles and select the profile whose password policies you wish to edit.
2. On the menu, click Password.
3. Edit the fields as desired, using the valid values of Unlimited, Default, or any numeric value:
4. On the menu, click Apply.

Manage storage

You can manage Oracle server storage with Mobile Admin, including tablespaces and datafiles.

View and editing tablespaces

1. From the Oracle Enterprise Manager screen, select the database that you wish to view tablespaces for.
2. Select Storage.
3. Select Tablespaces.

To edit a tablespace:

1. Select the tablespace you wish to edit.
2. Make the desired modifications.
3. Click Apply on the menu.

Create and remove a tablespace

1. Follow the procedure to view a list of tablespaces.
2. To create a tablespace, click Create on the menu.
3. Complete the fields as desired and click Create from the menu.

To remove a tablespace:

1. Select the tablespace you wish to remove.
2. Select Remove from the menu.

View and editing datafiles

1. From the Oracle Enterprise Manager screen, select the database that you want to view datafiles for.
2. Select Storage.
3. Select Tablespaces.
4. On the menu, click Datafiles.

To edit datafiles:

1. Select the datafile that you wish to modify.
2. Make the desired changes, and select Apply on the menu.

Create a datafile

1. Follow the procedure to view a list of datafiles and click Create on the menu.
2. Complete the fields as desired and click Create on the menu.

Run SQL queries

1. From the Oracle Enterprise Manager screen, select that database that you wish to run an SQL query on.
2. Select SQL Prompt.
3. Type the SQL query that you want to run.
4. On the menu, click Send.