Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Database Administration for Microsoft SQL Server DBAs part 10

Oracle Database Administration for Microsoft SQL Server DBAs part 10 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 72 Oracle Database Administration for Microsoft SQL Server DBAs There are some shared areas such as tmp that will cause issues to running or installing Oracle software if they fill up. So carefully place files here or be sure to purge out old installation logs that are placed here. There are also system areas which can normally be viewed but not modified. If sharing the server it would be important to make sure that changes to these system areas are communicated or discussed first. The Oracle user does not need full permissions or root access to view the configuration information but being able to view the information is useful to verify the configurations. CHAPTER 4 Database Definitions and Setup 74 Oracle Database Administration for Microsoft SQL Server DBAs Î -j HT n the previous chapter we walked through installing the Oracle software. The server should now be configured for Oracle and H the required components installed. The advantage of installing the software by itself first is that if there are any issues with the configuration the database doesn t need to be dropped and recreated each time. It is very easy to launch the Oracle configuration assistants after the installation. This chapter covers the next steps after the software is installed. The Database Configuration Assistant will guide you through the creation of the database. We will look at some of the configuration options as well as how to use templates and scripts. Security is a big part of database setup. We already talked about security at the operating system level and there will be more at the application level. Here we will look at server and schema security. These various levels of security will help you to achieve a more secure system. Before we get into the details of database setup let s clarify some of the terminology which also will reveal some of the differences between the SQL Server and Oracle platforms. Servers Databases Instances and Schemas As a DBA you are certainly familiar with