Configure and automatically start Oracle listening (lsnrctl)

Configure Oraclelsnrctl and auto start 1. Set the host name [root @ www ~] # Catetcsysconfignetworkingyeshostnamewww. linuxidc

Configure Oracle lsnrctl and auto start 1. Set host name [root @ www ~] # Cat/etc/sysconfig/networkNETWORKING = yesHOSTNAME = www. linuxidc

Configure and automatically start Oracle listening (lsnrctl)

[Date:] Source: Linux community Author: Robert tkun [Font:]

Configure Oracle lsnrctl and auto start

1. Set Host Name

[Root @ www ~] # Cat/etc/sysconfig/network
NETWORKING = yes
HOSTNAME = www.linuxidc.com

2. Set the Host Name and IP address

[Root @ www ~] # Cat/etc/hosts
127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4
: 1 localhost. localdomain localhost6 localhost6.localdomain6
192.168.2.16

3. Modify:/u01/app/oracle/network/admin/listener. ora

[Oracle @ www admin] $ cat listener. ora
# Listener. ora Network Configuration File:/u01/app/oracle/network/admin/listener. ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST =) (PORT = 1521 ))
)
)

ADR_BASE_LISTENER =/u01/app

4. Modify:/u01/app/oracle/network/admin/tnsnames. ora

[Oracle @ www admin] $ cat tnsnames. ora
# Tnsnames. ora Network Configuration File:/u01/app/oracle/network/admin/tnsnames. ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =)
)
)

5. Common lsnrctl Methods

[Oracle @ www admin] $ lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0-Production on 29-NOV-2013 21:56:57

Copyright (c) 1991,201 1, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:

Start stop status
Services version reload
Save_config trace spawn
Change_password quit exit
Set * show *

Lsnrctl start -- start the listener
Lsnrctl stop -- stop listening
Lsnrctl status -- view the status

0

How can Oracle support Chinese characters? Language _ region. Character Set

When the ORA-01552 was doing experiments, the undo segment management mode was modified.

,