Friday, December 24, 2010

Configuration of the Repository OracleDesigner

1 preface for attempted to contact OracleDesigner colleagues, the most painful thing start OracleDesigner, prompted "logged-on user does not install the Repository", because I do not know what is a Repository, I do not know where to install the Repository, and finally trying to learn OracleDesigner's decision is wiped away.

I remember I had a few times (probably 10 times more), trying to learn, but ultimately OracleDesigner to Repository does not know how to configure and give up. Recent attempts to learn again, and finally configure OracleDesigner Reposotory successfully, the configuration method for everybody, hope you can help people who are interested in learning to use OracleDesigner colleagues exclude some obstacles. Note: OracleDesigner and other database modeling tools compared to most major characteristic is ready for programming team collaboration, i.e. at the same time programming team members to different partitions on the system design, system will automatically synchronize the partition's data object. 2 techniques 2.1Repository knowledge Repository can be thought of as a basis for modeling environment, it includes a range of packages, database, view ... And other database objects, it enables different users, in collaboration with job control ... And other functions. Before using OracleDesigner Oracle will ask us first configured the environment to achieve the modeling capabilities of Oracle. 2.2Repository configuration process seemingly complex things, from the simplest method to implement. Repository configuration by 2 steps: (1) checks whether the current user has sufficient permissions, if not then append permissions. Authorized users suggestions for Sysxxx @ DBName asSysDba (2) click on install Repository button, Oracle will automatically install the Repository-related database objects. 3Repository creation 3.1 creates an Oracle user and the user is logged on to system 3.2 click CheckRequirement 3.3 view left list item for each option, confirm that the Privilege is the right. Note: If the user has been granted permission to DBA, there will be 6-7 Privilege needed by the Sys user authorization. 3.4 Privilege for insufficient permissions, use the Sys user authorization 3.5 click on Install button to install the Repository system 3.6 interface, click the Start button. If you still have insufficient permissions (in CheckRequirement omitted), the installer will prompt error 3.7 still in SQLPLUS, will slip through the permissions configuration items all make up 3.8 back Repository installation interface, click on Start button, the system will automatically begin the installation. The installation process requires approximately 20-30 minutes, sufficiently hard disc to of course. 3.9 at this point, the Repository is installed, and then try to enter OracleDesigner, discovery can properly entered. Regarding the use, OracleDesigner to other article further introduction.

No comments:

Post a Comment