Oracle Learning Notes

4-2 1 Morning See 40:40

This statement , can not be used in production environment , because there are only one variable , the company has a lot of people , not enough . Solve with Loops

where

========================================================================

Listening

Listen to the links between the databases and monitor them.

to link a database with a middleware, you need to have a port, which is 1521 by default

Master profile--Listening files

/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

The discovery file has no content and can be written to it via log information.

The method of drawing configuration monitoring

"Database Side"

Open the netmgr tool

"Add" at listeners

The IP address of the native name (listener) is filled in here

Select Database Services Card, fill in the name of the correct local DB instance.

Save exit

See found a file in the network/admin below the $ORACLE _home

Listener.ora. This is the configuration file generated by the above operation. The above section is which library you are listening to outside requests. Here is the listener's address, port. If you want to configure the character form, you have to back it up, and then configure the time to copy and paste

"Database Side":

Lsnrctl start

"Requester Side"

Log on to the local database

shut down the database shutdown immediate

also open the netmgr tool configuration transfer file

added . Just a name, anyway .

can only select TCPIP Protocol

fill in the host name of the target server to which you want to connect (IP) . The port check is on the line.

Fill in the database name of the target host

Finish saving exit. The results are as follows

View $ORACLE _home/network/admin/

A new file Tnsnames.ora appears . This is the configuration file generated by the above operation

Description The transfer file is built.

"Test it. link target Server "

Sqlplus Sys/[email protected]

To120 is the name of a link you just set, and the system will find the target address contained under TO120. Do not add @ is connected to the machine. If you want to reverse the connection, then the respective configuration file Exchange copy, make the corresponding changes to the line. Configuration files can be configured

Attention!

Listener Side  ( database Side )         Open Monitoring Create file /listener.ora

Requester Side     no need to open the monitor Create a transfer file /tnsnames.ora

--------------------

Tips!

Company in the form of character configuration, the configuration file backup a portion of the line.

=========================================================================

Installing the Client Software

650) this.width=650; "width=" 171 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>650) this.width=650, "width=" 179 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/ U261/themes/default/images/word.gif ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

Oracle windows

PL/SQL Developer

PL/SQL Developer , this software, now uses the most, in the company will use this software. However, will not use this, because the company workload is very large, all write good script to run, so the SQL statement to pay attention to. Note that each window is a session,

Key Operating Skills

Column name Completion The table name .

Edit Data in tables , locate the table you want to edit, and right-click.

=========================================================================

Afternoon

oem- -- oracleenterprise Manager

monitoring is One of the DBA 's work, which is mostly used with OEM tools,the OEM is Oracle's own development, very powerful, so unlike other software, often used by third parties. This software can not only monitor, but also can manage,

like OEMs can also create tables, but generally no one does.

Port number 1158

Attention!

since the use OEM, you need to open the monitoring.

-----------------------------------

Installation steps

1. 1. Creating Repositories

Use this command to view the status of the OEM (Enterprise Management Console). Show no OEM. Next install. If the display has been installed, it may have been loaded with Oracle.

[Email protected] ~]$ emctlstatus dbconsole

TZ set to PRC

oc4j Configuration Issue./oracle/app/oracle/product/10.2.0/db_1/oc4j/j2ee/oc4j_dbconsole_localhost.localdomain_ Leenot found.

This is the order to deactivate the OEM, if you want to reload, first stop him

[Email protected] emdrep]$ emctlstop dbconsole

Reinstall the OEM commands

[email protected] ~]$ emca-reposrecreate first time installation with Emca-repos create

STARTED EMCA at APR 5, 2:27:22 AM

EM Configuration Assistant, Version 10.2.0.1.0Production

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database SID:ORCL

Listener Port number:1521

Password for SYS User:

Password for Sysman User:

wish to continue? [Yes (Y)/no (N)]: Y

Configuration Management Library, dbsnmp that piece, you will find no password, first change

-------

Select username from Dba_users

Alert user Dbsnmp identified by! Qaz1qaz

------- and then configure it. After a successful configuration, you will be prompted to access an address to access it

[Email protected] admin]$ emca-config Dbcontrol db

Database SID:ORCL

Listener Port number:1521

Password for SYS User:

Password for DBSNMP User:

wish to continue? [Yes (Y)/no (N)]: Y

...

APR 6, 10:41:14 AMoracle.sysman.emcp.EMDBPostConfig performconfiguration

INFO: >>>>>>>>>>> thedatabase Control URL is http://localhost.localdomain:1158/ EM<<<<<<<<<<<

On the client access http://localhost.localdomain:1158/em

******************

Attention!

If the Rebuild EM time is too long, separate execution , Delete First

[Email protected] emdrep]$ emca-deconfig dbcontrol db-repos Drop

Create again em

[Email protected] emdrep]$ Emca-repos Create

===================================================================

OEM the Use

The entire manager is divided into several main pages

generally look at the dark green part, the general company deep green than light green. Light green is not related to Oracle.

Active Sessions There is a wait or wait time too long to indicate that performance is affected.

Top SQL is often viewed to see which parts occupy a relatively high

==============================================================================

Build a library by hand

The meaning is not big, willing to do a bit. The key is to do the questions left yesterday. Make a script or document, do a little detail, add a note

You can delete a database only if it is not in open state.

production environment, is listening to the front side of the middleware, class teacher with Sqlplus instead of

6.

Build up four table spaces and you can install at least four

8

The interview will ask you what this thing is for.

Small knowledge

You can only delete the million at a time

Remember that the character set must be properly managed, otherwise

Oracle Learning Notes