Oracle OEM database creation instances and oracleoem database creation

Oracle OEM database creation instances and oracleoem database creation

OEM is a graphical database administrator tool. It provides a centralized system management tool for database administrators. It is also a tool for managing, diagnosing, and debugging multiple databases, A tool used to manage multiple network nodes and services from multiple locations. This tool allows different database administrators to share some work. In addition, it provides some tools for managing parallel servers and distributed databases. In short, OEM is a powerful and easy-to-use Graphical Database Administrator tool.

 

1. Access https: // localhost: 1158/em/console/logon

Enter logon Password

 

2. Create a tablespace

Tablespace is the largest logical Storage Structure in Oracle and corresponds to physical data files.

Table space helps DBA users to do the following:. determines the space allocation of database entities. B. set the Space share of database users. c. controls the availability of some data in the database. d. data is distributed between different devices to improve performance. e. back up and restore data.

 

 

3. Create/modify a role

4. Configure tnsnames. ora

Find tnsnames in the path oracle \ product \ 11.1.0 \ db_1 \ NETWORK \ ADMIN. ora, (if not, create a new one and add it to the header: # tnsnames. ora Network Configuration File: 'fill in your tnsnames. the absolute path of the ora file, for example, E: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora '# Generated by Oracle configuration tools .) open with UE and add the string: sinosoft =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.5.31) (PORT = 1521) (CONNECT_DATA = (SID = sinosoft)
(SERVICE_NAME = sinosoft )))
Save and open PL/SQL

 

 

5. Import the dmp File

The following example shows how to import loyds_new_arch.dmp to the sinosoft database. After logging on to PL/SQL, authorize yltest
Run the "create user yltest identified by yltest" command to create a temporary tablespace on the console.
Default tablespace SINOSOFT_TABLESPACE2 temporary tablespace sinosoft_temp profile DEFAULT;
-- Grant/Revoke role privileges grant connect to yltest; grant dba to yltest; grant resource to yltest;
-- Grant/Revoke system privileges grant create any table to yltest; grant create procedure to yltest; grant create session to yltest; grant debug connect session to yltest; grant select any table to yltest;
Grant unlimited tablespace to yltest; after execution, run the dos window and start-run-cmd. Assume that the path of the dmp file is D: \ dmp \ loyds_new_arch.dmp.
Run the command: imp yltest/yltest @ sinosoft file = D: \ dmp \ loyds_new_arch.dmp log = yltest full = y ignore = y
Paste in command line

 

 

Attached Basic Oracle commands:

[Root @ oracledb ~] # Su-oracle

[Oracle @ oracledb ~] # Sqlplus/as sysdba

SQL> startup # Start a database instance

SQL> shutdown immediate # Shut down the database instance

SQL> show parameter db_name; # list databases

SQL> show parameter service; # view the service name

SQL> select * from tab; # view all tables

SQL> select name from v $ datafile # view the database storage directory

SQL> select * from v $ instance; # view instance name

SQL> select name from v $ database; # view database name

SQL> select * from dba_users; # view all user information

SQL> select username, password from dba_users; # query only the user and password

SQL> select * from v $ pwfile_users; # view users with sysdba Permissions

SQL> select * from dba_ustats; # view current user information

SQL> select * from user_sys_privs # view the current user's system Permissions

SQL> select * from user_role_privs # view the current user role

SQL> select * from dba_sys_privs # view the system permissions of a specified user

SQL> select * from v $ version # view the oracle version

SQL> select * from user_views # view information

SQL> alter system set processes = 1000 scope = spfile; # modify the maximum number of oracle connections and restart the database

 

 

Recommended:

Http://www.cnblogs.com/damonlan/category/394305.html

Http://www.cnblogs.com/coffeeliu/archive/2007/01/07/461130.html