Oracle OMS – Please Help

580 pts.
Tags:
OMS (Oracle Management Server)
Oracle 9i
Oracle Management Server
SQL Server
SYSMAN
Windows Server 2000
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
UPDATED: May 12, 2009  2:31 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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;
}

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following