See "Connecting Locally with the SQL Command Line" for instructions. Start the SQL Command Line and connect to the database as user SYSTEM. See "Stopping and Starting the Listener" for instructions. Note that the line indicated in bold may or may not be present in the file.Ĭhange the text (PORT = 1521) to (PORT = 1522). (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) Locate the followin g section of the file: usr/lib/oracle/xe/app/oracle/product/11.2.0/server/network/admin/Ĭ:\oraclexe\app\oracle\product\11.2.0\server\NETWORK\ADMIN\ Table 4-3 Location of the listener.ora File Platform If successful, the command displays the report shown in "Viewing Listener Status". If the listener was already stopped, the command displays one or more TNS: no listener messages. The command displays the following output if successful.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))) On Linux, ensure that environment variables are set according to the instructions in "Setting Environment Variables on the Linux Platform". See "Changing Listener Port Numbers" for more information. To change the TCP port number that the listener listens on You stop the listener to disable remote connection requests, and restart the listener to enable them. To temporarily block remote connection requests The following are reasons why you may want to stop and restart the listener:
The listener is configured to start automatically when you install Oracle Database Express Edition (Oracle Database XE), and whenever the computer running Oracle Database XE is restarted. Oracle Database XE is properly registered with the listener and is ready to accept connections. Service "XE" has 1 instance(s) and Instance "XE", status READY The listener is listening for database connections through HTTP on port 8080. The listener is listening for database connections through Oracle Net on port 1521. In the preceding report, the bold text indicates particulars to look for. Instance "xe", status READY, has 1 handler(s) for this service. Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service. Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=) (PORT=8080))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - ProductionĬ:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.oraĬ:\oraclexe\app\oracle\diag\tnslsnr\user1-pc\listener\alert\log.xml If the listener is started, the command displays a report that looks something like this:Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) If the listener is not started, the command displays the following error messages: On Linux, ensure that environm ent variables are set according to the instructions in "Setting Environment Variables on the Linux Platform". On Windows: Log in to the Oracle Database XE host computer as the user who installed Oracle Database XE, and then open a command window. On Linux: Start a terminal session and log in to the Oracle Database XE host computer with the oracle user account. You do so with the Listener Con trol ( lsnrctl) utility. You vie w listener status to determine if the listener is started and to check listener properties (such as the TCP/IP port numbers that the listener is listening on). Table 4-1 lists the types of connection requests that the listener handles. The client application and the database then communicate directly. When the listener receives a valid connection request from a client application, it routes the connection request to the database. It is the host process that listens on specific TCP/IP ports for connection requests. Included with Oracle Net in an Oracle Database XE installation is the Oracle Ne t listener, commonly known as the listener. Oracle Net is automatically installed when you install Oracle Database XE and Oracle Database Express Edition Client. Oracle Net establishes the connection between the client application and the database, and exchanges messages between them using TCP/IP.
Remote client applications and the database communicate through Orac le Net, which is a software layer that resides both on the remote computer and on the Oracle Database XE host computer. Oracle Database Express Edition (Oracle Database XE) supports connections from client applications both remotely over the network and locally. About Network Connecti ons and the Oracle Net Listener