The following describes means to create a OEM V1.x (very
old!!!) repository on WindowsNT:

1 Answer

Answer :

Create a tablespace that would hold the repository data. A size
between 200- 250 MB would be ideal. Let us call it Dummy_Space.
. Create an Oracle user who would own this repository. Assign DBA,
SNMPAgent, Exp_Full_database, Imp_Full_database roles to this user.
Lets call this user Dummy_user. Assign Dummy_Space as the default
tablespace.
. Create an operating system user with the same name as the Oracle
username. I.e. Dummy_User. Add 'Log on as a batch job' under
advanced rights in User manager.
. Fire up Enterprise manager and log in as Dummy_User and enter the
password. This would trigger the creation of the repository. From now
on, Enterprise manager is ready to accept jobs.

Related questions

Description : How does one create a repository? (for DBA

Last Answer : For OEM v2 and above, start the Oracle Enterprise Manager Configuration Assistant (emca on Unix) to create and configure the management server and repository. Remember to setup a backup for the repository database after creating it.

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Description : How does one list one's databases in the OEM Console? (for DBA

Last Answer : Follow these steps to discover databases and other services from the OEM Console: 1. Ensure the GLOBAL_DBNAME parameter is set for all databases in your LISTENER.ORA file (optional). ... OEM Discovery Wizard will guide you through the process of discovering your databases and other services.

Description : What are the components of OEM? (for DBA

Last Answer : Oracle Enterprise Manager (OEM) has the following components: . Management Server (OMS): Middle tier server that handles communication with the intelligent agents. The OEM Console connects to the ... database and takes care of the execution of jobs and events scheduled through the Console.

Description : What is OEM (Oracle Enterprise Manager)? (for DBA

Last Answer : OEM is a set of systems management tools provided by Oracle Corporation for managing the Oracle environment. It provides tools to monitor the Oracle environment and automate tasks (both one-time and repetitive in nature) to take database administration a step closer to "Lights Out" management.

Description : Define what is Object Repository? Explain How can we create Object Repository in Selenium?

Last Answer : Object Repository is a term used to refer to the collection of web elements belonging to Application Under Test (AUT) along with their locator values. Thus, whenever the element is required within ... objects can be stored in an excel sheet which can be populated inside the script whenever required.

Description : How does one create a standby database? (for DBA)

Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

Description : A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Last Answer : Disable the foreign key constraint to the parent, drop the table, re- create the table, enable the foreign key constraint.

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Description : How does one create and drop database users?

Last Answer : Look at these examples: CREATE USER scott IDENTIFIED BY tiger -- Assign password DEFAULT TABLESACE tools -- Assign space for table and index segments TEMPORARY TABLESPACE temp; -- Assign sort space ... give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools;

Description : What utility is used to create a physical backup?

Last Answer : Either rman or alter tablespace begin backup will do..

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Description : Can we create two blocks with the same name in form 3.0 ?

Last Answer : No

Description : How will you create multiple rollback segments in a database ?

Last Answer : Create a database which implicitly creates a SYSTEM Rollback Segment in a SYSTEM tablespace. Create a Second Rollback Segment name R0 in the SYSTEM tablespace. Make new rollback segment ... ) for rollback segments. Deactivate Rollback Segment R0 and activate the newly created rollback segments.

Description : How does one create a RMAN recovery catalog? (for DBA

Last Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user ... . Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;

Description : Why is it preferable to create a fewer no. of queries in the data model?

Last Answer : Because for each query, report has to open a separate cursor and has to rebind, execute and fetch data.

Description : How does one create a password file? (for DBA

Last Answer : The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be ... visible in the process table of many systems. Administrators needs to be aware of this!

Description : How do you create a new session while open a new form?

Last Answer : Using open_form built-in setting the session option Ex. Open_form('Stocks ',active,session). when invoke the mulitiple forms with open form and call_form in the same application, state whether the following are true/False

Description : How does one create a new database? (for DBA)

Last Answer : One can create and modify Oracle databases using the Oracle "dbca" (Database Configuration Assistant) utility. The dbca utility is located in the $ORACLE_HOME/bin directory. The Oracle Universal ... ='/u02/oradata/'; ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2='/u03/oradata/'; CREATE DATABASE;

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

Description : A table is having few rows, should you create indexes on this table

Last Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. You can create an index on any column; however, if the ... , creating an index on the column does not increase performance and the index takes up resources unnecessarily.

Description : On which columns you should create Indexes?

Last Answer : In general, you should create an index on a column in any of the following situations: ▪ The column is queried frequently ▪ A referential integrity constraint exists on the column ▪ A UNIQUE key ... ORDER BY clauses ▪ On columns that have few of the same values or unique values in the table

Description : Which default Database roles are created when you create a Database?

Last Answer : CONNECT , RESOURCE and DBA are three default roles. The DBA_ROLES data dictionary view can be used to list all roles of a database and the authentication used for each role. The following query lists all the roles in ... ------------ -------- CONNECT NO RESOURCE NO DBA NO SECURITY_ADMIN YES

Description : What is the minimum number of instances you need to have in order to create a RAC?

Last Answer : 1. You can create a RAC with just one server.

Description : What insurance company covers OEM parts?

Last Answer : I don't know if there are any insurance companies that will do OEM only. Since 1970 most insurance companies can insist the will only pay for aftermarket parts, OEM differences are paid for by the ... importing parts for VW, Toyota, Datsun and others; we were making a killing at the body shops.

Description : What are the downsides to buying the OEM version of an operating system?

Last Answer : answer:Microsoft do allow consumers to install OEM versions on machine they built themselves so legally you should be OK. The OEM versions are either 64bit or 32bit (the retail key will activate either ... interface once). After that it's pretty similar to 7 and probably worth at least considering.

Description : Is there a top quality replacement for the OEM inkjet cartridges for the Canon PIXMA MP640 printer?

Last Answer : answer:Using generic brand names will reduce the life of the printer, you might find that you will have to replace the printer within a year if you do not use Printer Brand cartridges. Perhaps it ... The combo model still needs the cartridges inserted to operate but they don't need to be full.

Description : Why doesn't Apple come out with an OEM indestructible case for the Iphone?

Last Answer : They want you to break the phone and buy another one.

Last Answer : Original Equipment Manufacturer

Description : should i buy oem or aftermarket clutch for my 04 mustang 3.9

Last Answer : Need Answer

Description : Does OEM stand for Original Equipment Manufacturer?

Last Answer : The abbreviation OEM does indeed stand for original equipment manufacturer. The term is used to commonly describe parts and accessories within the automotive field. Often vehicle parts and ... only OEM replacements not after market versions or consumers risk voiding their vehicles warranties.

Description : Does the Nextel Motorola OEM Auto Car Cell Phone Charger work only on Motorola phones?

Last Answer : Along with Nextel Motorola phones, this charger is also compatible with Boost Mobile i875 phones.

Description : OEM Software stands for: a) Open - Source Entertainment Software b) Other Equivalent Manufacturer Software c)Operating Engine Manufacturer Software d) Original Equipment Manufacturer Software e) None of These

Last Answer : d) Original Equipment Manufacturer Software

Description : Smart link to your app should auto-redirect based on which of the following parameters? A. Device type & OS B. Screen size C. OEM Brand D. All of the above

Last Answer : A. Device type & OS

Description : What is Support Repository in Android Studio settings?

Last Answer : Need Answer

Description : Do you know of any online file system or repository where I can save all the URLs ?

Last Answer : How about trying the most simple method of bookmarking the websites you come across first? Just one button on the browser and you are done. Or you can even save the webpages. Just click Flie -> Save page as…

Description : How could we go about designing an interconnected global software repository?

Last Answer : Decentralized concepts keep the overhead low. The Internet already offers software repositories for example for Java class libraries.

Description : Repository of Short Interesting Articles for Casual Reading?

Last Answer : All that comes to mind right now are sites like American Thinker, Pajamasmedia, and Zombietime. Good stuff, mostly, but it’s quite political, and odds are good that it’s not your kind of political. Also, it looks like somebody et your site and put up a dummy. If so, my condolences.

Description : Can I import my Git repository into Subversion?

Last Answer : I would think so… You might try using tailor to convert… Or, convert your repo to bazaar which can seamlessly commit to/from svn.

Description : What is an enormous repository of information stored on millions of computers?

Last Answer : Feel Free to Answer

Description : Which of the following protocols is used by email server to maintain a central repository that can be accessed from any machine ? a. POP3 b. IMAP c. SMTP d. DMSP

Last Answer : b. IMAP

Description : In ________ is a repository of information linked together from points all over the world. A. The WWW B. HTTP C. HTML D. none of the above

Last Answer : A. The WWW

Description : SERP stand for  Search Engine Result Page  Search Engine Rating Page  Search Engine Result Programme  Search Engine Repository Page

Last Answer :  Search Engine Result Page

Description : Define what is Object Repository?

Last Answer : An object repository is an essential entity in any UI automation which allows a tester to store all object that will be used in the scripts in one or more centralized locations rather than scattered all over the test scripts.

Description : What is a Business Objects Repository?

Last Answer : The Business Objects repository is a centralized set of relational data structures stored on a database. This relational device enables BUSINESSOBJECTS and WEBINTELLIGENCE users to share resources in a ... of three domains: the security domain, the unive rse domain, and the document domain.

Description : Data cannot flow between two data stores because A) it is not allowed in DFD B) a data store is a passive repository of data C) data can get corrupted D) they will get merged

Last Answer : D) they will get merged