Oracle OMS - Please Help
580 pts.
0
Q:
Oracle OMS - Please Help
i'm expert on SQL Server, but new to Oracle world.
the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data...)it gives me that i have to use OMS .
i found that OMS needs sysman user,
or after searching i found that this username doesn't exist, maybe someone or the old DBA has deleted it.
i found on google search the below query to re-create the sysman user and i run it on my server, but i don't even have a tablespace called MGMT_TABLESPACE

create user SYSMAN identified by values 'xxxxxxxxxxxx'
default tablespace MGMT_TABLESPACE
temporary tablespace TEMP;

alter user SYSMAN quota unlimited on MGMT_TABLESPACE;

grant DBA to SYSMAN;
grant MGMT_USER to SYSMAN with admin option;
grant ALTER SESSION to SYSMAN;
grant ALTER USER to SYSMAN;
grant CREATE ANY TABLE to SYSMAN;
grant CREATE USER to SYSMAN;
grant DROP USER to SYSMAN;
grant SELECT ANY DICTIONARY to SYSMAN;
grant UNLIMITED TABLESPACE to SYSMAN;
grant READ on SYS.AUDIT_DIR to SYSMAN;
grant WRITE on SYS.AUDIT_DIR to SYSMAN;
grant DELETE on SYS.AUX_STATS$ to SYSMAN;
grant INSERT on SYS.AUX_STATS$ to SYSMAN;
grant SELECT on SYS.AUX_STATS$ to SYSMAN;
grant UPDATE on SYS.AUX_STATS$ to SYSMAN;
grant EXECUTE on SYS.DBMS_AQ to SYSMAN;
grant EXECUTE on SYS.DBMS_AQ_BQVIEW to SYSMAN;
grant EXECUTE on SYS.DBMS_JOB to SYSMAN;
grant EXECUTE on SYS.DBMS_LOB to SYSMAN;
grant EXECUTE on SYS.DBMS_LOCK to SYSMAN;
grant EXECUTE on SYS.DBMS_REDEFINITION to SYSMAN;
grant EXECUTE on SYS.DBMS_RLS to SYSMAN;
grant EXECUTE on SYS.DBMS_SHARED_POOL to SYSMAN;
grant SELECT on SYS.QT16228_BUFFER to SYSMAN;
grant SELECT on SYS.QT9774_BUFFER to SYSMAN;
grant SELECT on SYS.USER_TAB_COLUMNS to SYSMAN;



as a result user created, but many of the privileges that should be granted were ungranted such as MGMT_USER, AUDIT_DIR...

i need to split databse, i need to take backups, i need to be able to act as DBA

what to do? please help!!!
ASKED: May 11 2009  3:18 PM GMT
0
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
What tools were you using when you got the error? The only reason you would get an error is if you were doing (backup, creation of new Shema, importing data...) is that you were using Oracle DBconsole or through the GUI. If you choose not to use the GUI interface and if you dba privs, then you shouldn't get the error.

--Using SQLPLUS(W) to create a new schema

create user <username> identified by <password>
default tablespace <tablespace_name>
temporary tablespace <temp_tablespace_name>;
--grant appropriate quota on tablespace and privs

--Using DataPump or Exp/Imp Utility to import data

Imp <username/password@tns> file=<file_name> owner=<schema_to_import>

--Using Rman for backups

Please read Google backup/recover (RMAN) for prereq

--Basic backup of database

Rman target <username/password@tns>

run
{
backup database;
}
Last Answered: May 12 2009  2:30 PM GMT by BLT   15 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0