Oracle Net Configuration

A. Open Net Manager, configure service naming

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/FE/wKioL1R1i7PQrUxVAAINdLa6fIA338.jpg "style=" float: none; "title=" 1 "alt=" wkiol1r1i7pqruxvaaindla6fia338.jpg "/>

The service name fills in the database instance name, and the host name fills in the IP address.

B. configuring listeners

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/54/00/wKiom1R1izLSuQ9RAAHtpfaqtW4044.jpg "style=" float: none; "Title=" 2 "alt=" Wkiom1r1izlsuq9raahtpfaqtw4044.jpg "/>

The host writes the IP address, and the port defaults (or chooses an unoccupied port) to be consistent with the configuration in the service name.

C. Adding a database service

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/FE/wKioL1R1i7SAJAnvAAIR8CncC2k719.jpg "style=" float: none; "Title=" 3 "alt=" Wkiol1r1i7sajanvaair8cncc2k719.jpg "/>

Click on the database service on the top right, then click Add Database, Global database name and SID to fill in the database instance name and fill in the Oracle home directory. And then save .

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/54/00/wKiom1R1izLgfTv-AAGs8JFJa7c108.jpg "style=" float: none; "Title=" 4 "alt=" Wkiom1r1izlgftv-aags8jfja7c108.jpg "/>

d. Restart the listener, open the DB instance service, and log in by typing the following statement at the command line.

Sqlplus Scott/[email PROTECTED]:1521/ORCL

Where Scott is the login account, 132456 is the password, 10.8.2.73 is ip,1521 is the port number, ORCL is the database instance name.

After I test can be used normally, if there is doubt welcome discussion.

This article from the "Flying Fish Technology" blog, reproduced please contact the author!

Oracle Net Configuration