Oracle First Experience Two

The database instance was created in the previous installment, but there was a problem when the DB instance was last accessed with EM?

Enterprise Manager cannot connect to the DB instance. The status of the components is listed below.

To answer the above questions, see the following Oracle structure:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/32/wKioL1SUOu6xVfxHAACXWOm4hMk922.jpg "title=" structure. png "alt=" Wkiol1suou6xvfxhaacxwom4hmk922.jpg "/>

Customers use the browser via the 1158 port of EM to access Em,em through the listener access to the Oracle DB instance, in the last section we created a DB instance from the database configuraion Assistant . But we haven't created a listener yet. So there is the question that was raised last verse. In this section we will complete Listener creation through the Oracle Network Configuration Assistant (Oracle Net config Assistant)

[Email protected] db_1]$ NETCA

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/36/wKiom1SUPOCwfKBeAAGQBsQyiTM535.jpg "title=" Netca1.png "alt=" Wkiom1supocwfkbeaagqbsqyitm535.jpg "/>

Oracle Net config Assistant (first page of Oracle Network Configuration Assistant) listener configuration Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/33/wKioL1SUPqryltjYAAGP6c7uveA022.jpg "title=" Netca2.png "alt=" Wkiol1supqryltjyaagp6c7uvea022.jpg "/>

Add Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/36/wKiom1SUPj_jUAgGAAF08yUxRxg251.jpg "title=" Netca3.png "alt=" Wkiom1supj_juaggaaf08yuxrxg251.jpg "/>

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/33/wKioL1SUP1ryNVupAAGTZ_B2Dys645.jpg "title=" Netca4.png "alt=" Wkiol1sup1rynvupaagtz_b2dys645.jpg "/>

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/36/wKiom1SUPvXT16WnAAGAeljjQaY681.jpg "title=" Netca6.png "alt=" Wkiom1supvxt16wnaagaeljjqay681.jpg "/>

Using the standard port number 1521 next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/33/wKioL1SUP-XDzIDoAAE9skMqfPY208.jpg "title=" Netca7.png "alt=" Wkiol1sup-xdzidoaae9skmqfpy208.jpg "/>

No Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/33/wKioL1SUQMXSg1qzAAE6qvXCjnc810.jpg "title=" Netca8.png "alt=" Wkiol1suqmxsg1qzaae6qvxcjnc810.jpg "/>

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/33/wKioL1SUQXLRulNFAAGe-K0vpVw576.jpg "title=" Netca91.png "alt=" Wkiol1suqxlrulnfaage-k0vpvw576.jpg "/>

Configure the local NET service name configuration to configure the next step when you are finished configuring the listener

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/36/wKiom1SUQYOSncFxAAGRHQU5YDE374.jpg "title=" Netca10.png "alt=" Wkiom1suqyosncfxaagrhqu5yde374.jpg "/>

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/33/wKioL1SUQmXTSDyeAAGAKNbKcnE067.jpg "title=" Netca11.png "alt=" Wkiol1suqmxtsdyeaagaknbkcne067.jpg "/>

The service name is the same as the instance name of the database next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/33/wKioL1SUQqridpw5AAFvsJDcGfQ500.jpg "title=" Netca12.png "alt=" Wkiol1suqqridpw5aafvsjdcgfq500.jpg "/>

Select TCP Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/33/wKioL1SUQzaRgtgBAAGolo67fPo669.jpg "title=" Netca13.png "alt=" Wkiol1suqzargtgbaagolo67fpo669.jpg "/>

Host name native IP next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/36/wKiom1SUQt3R8VfBAAGD6Ql3p_0295.jpg "title=" Netca14.png "alt=" Wkiom1suqt3r8vfbaagd6ql3p_0295.jpg "/>

No, do not test the next step

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/57/33/wKioL1SUQ_LQg1ZMAAFgXXfRlOY483.jpg "title=" Netca15.png "alt=" Wkiol1suq_lqg1zmaafgxxfrloy483.jpg "/>

Network Service Name DB instance name next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/33/wKioL1SURETw1qY_AAEvnG5zbDo802.jpg "title=" Netca16.png "alt=" Wkiol1suretw1qy_aaevng5zbdo802.jpg "/>

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/33/wKioL1SURKPSVTaGAAEsHp9hqPk174.jpg "title=" Netca17.png "alt=" Wkiol1surkpsvtagaaeshp9hqpk174.jpg "/>

Next

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/36/wKiom1SURFzhX2jUAAGfJGA3y_A803.jpg "title=" Netca18.png "alt=" Wkiom1surfzhx2juaagfjga3y_a803.jpg "/>

Complete

Verify that the configuration succeeded with no:

[

[Email protected] db_1]$ lsnrctl status lsnrctl for linux: version  10.2.0.1.0 - Production on 19-DEC-2014 23:31:06Copyright  (c)  1991,  2005, oracle.  all rights reserved. connecting to  (description= (address= (protocol=tcp) (HOST=ORCL) (port=1521)) status of the  listener------------------------alias                      LISTENERVersion                    TNSLSNR for  linux: version 10.2.0.1.0 - productionstart date                 19-DEC-2014 23:09:11Uptime                     0 days 0 hr. 21 min. 55 sectrace level                offSecurity                   on: local  OS AuthenticationSNMP                       offlistener parameter file   / u01/app/oracle/product/10.2.0/db_1/network/admin/listener.oralistener log file          /u01/app/oracle/product/10.2.0/db_1/network/log/listener.loglistening  Endpoints Summary...   (description= (address= (protocol=tcp) (HOST=ORCL) (port=1521))     (description= (address= (PROTOCOL=IPC) (key=extproc0)) services summary ... service  "ORCL"  has 1 instance (s).  instance  "ORCL",  status ready, has 1 

Handler (s) for the This service ...  Service "Orclxdb" has 1 instance (s). Instance "ORCL", status ready, have 1 handler (s) for the This service ...  Service "ORCL_XPT" has 1 instance (s). Instance "ORCL", status ready, have 1 handler (s) for the This service ...  Service "Plsextproc" has 1 instance (s). Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ... The command completed successfully

The following line appears in the command result stating that the configuration was successful:

Instance "ORCL", status ready, have 1 handler (s) for the This service ...

Monitor management life Make

[[email protected] db_1]$ lsnrctl lsnrctl for linux: version  10.2.0.1.0 - production on 19-dec-2014 23:36:57copyright  (c)  1991,  2005, oracle.  all rights reserved. welcome to lsnrctl, type  "Help"  for information. lsnrctl> help the following operations are availablean asterisk  (*)  denotes a modifier or extended command:start                stop                 status               services             version             reload               save_config          trace                spawn                change_password     quit                 exit                 set*                 show*

This article is from the "attention to Linux technology" blog, please be sure to keep this source http://werewolftj.blog.51cto.com/1606482/1594013

Oracle First Experience Two