Understanding the Oracle Network Architecture

"Oracle Net has to be there in both clients and server. Configuration of Oracle Net on server side is actually the development of listener.ora file. Configuration of Oracle Net on the client side is actually the development of tnsnames.ora file. Oracle Net takes care of all different types of Network protocols. Server and clients know how to speak with Oracle Net and Oracle Net knows all different Network languages. tnsnames.ora file contains the resolution of 'Net Service Name' or 'Connect String' that we will use to connect to Oracle Server."

What is the purpose of Oracle Net?

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Oracle Net takes care of all different types of Network protocols. Server and clients know how to speak with Oracle Net and Oracle Net knows all different Network languages. The sole job of the listener process is to bequeath the connection to the dispatcher or dedicated server process."

Oracle Net Manager vs Oracle Network Configuration Assistant

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Oracle Net Manager - Java based program, completely Operating System independent. Oracle Network Manager should be preferred over Oracle Network Configuration as recommended by Oracle. In Unix environment, ONM can be accessed by executing netmgr command and the same software can be accessed in windows under start and then all programs menu."

Creating Listener (or creating listerner.ora file)

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Not only listener name has to be default but we have to use default protocol i.e. TCP/IP and default port i.e. 1521 or 1520 if we want to go with dynamic service registration. After selecting listener name as LISTENER you have to click the OK button. Then the listener name will appear under the Listeners item inthe tree on the left pane of ONM."

Setting Up Net Service Name

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Figure 8-23: A successful connection means, Net Service Name (i.e. fan) is resolving to Oracle Database Server (on same machine or some other machine) using tnsnames.ora file."

Accessing Oracle Enterprise Manager Database Control

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. Point your web browser to the following URL: http://hostname:portnumber/em

SQL Statements Based Oracle Database Management

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Availability of tablespace to the users can be controlled using ALTER TABLESPACE statement. SYSTEM tablespace can never be placed in the OFFLINE mode as Oracle utilizes the tables relating to data dictionary views and dynamic performance view in itsnormal operation."

ALTER TABLESPACE Statement

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Complete management of tablespace using ALTERTABLESPACE statement."

Bigfile Tablespace (BFT) vs Smallfile Tablespace (SFT)

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Bigfile Tablespace (BFT) and Smallfile Tablespace (SFT): This is a special tablespace introduced in Oracle 10g having only one data file. You cannot have more than one data file in bigfile tablespace. This feature is first time introduced in Oracle 10g. The size of the data file can be as big as 2 power of 32 (4GB) blocks."

Oracle Enterprise Management Database Control based database management

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "In the previous chapter you have learnt how to access and start Oracle Enterprise Manager Database Control. Here we are presuming that you already logged into Oracle Enterprise Manager Database Control using SYS credentials and as SYSDBA. Figure 9-3 shows the Home page of Oracle Enterprise Manager Database Control. The whole Oracle database management task is divided into four tabs: Home, Performance, Administration and Maintenance."

Managing Redo Log Groups/Redo Log Members - EM Database Control

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Managing Redo Log Groups/Redo Log Members: Under the Administration tab of Oracle Enterprise Manager Database Control, we have "Redo Log Groups" link. Clicking this link will take you to Redo Log Groups page which will not only provides you the current information about redo log groups but helps you to add new group or new member for already existing group."

Managing Oracle Instance Memory Architecture

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Memory Parameters link under the Administration tab enables us not only to control SGA and PDA sizes but provides us with their current status as well."

Where is the location of Archive Logs link in EM Database Control?

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Archive Logs: Oracle Enterprise Manager Database Control provides information regarding archived redo logs through the Archive Logs page. This page is accessible through Administration tab as shown in Figure 9-17."

What are Steps for Manual Archiving?

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Put the database in ARCHIVELOG mode by first shutting down the database as NORMAL and then starting it in mount state using STARTUP MOUNT statement. Then executing the following statement."

Other Database Management Operations

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "We have touched very small portion of things that we can do with Oracle Enterprise Manager Database Control. Most of the features/abilities of Database Control are self-explanatory as long as you know the theory/concepts e.g. if you do not know what redo log files are and how redo log gets utilized by OracleInstance then click "Redo Log Group" link will make you feel as if you are in another world."