Shulou(Shulou.com)06/01 Report--

Ps aux | grep ora_pmon has several database servers and several of these processes (process monitoring processes deal with external users)

Vim sqlnet.ora can make the database slightly secure and prevent sqlplus from logging in.

Sqlnet.authentication_services= (none)

Conn hr/oracle_4U@orcl generates a physical connection logical session

Host ps to check which terminal is.

! Ps

Then connect through windows's sqlplus plus tool

Select * from v_$session 's where s.TERMINAL = 'pts/2'

SADDR session address SGA shared pool, which controls the storage of new values

PADDR memory address

TADDR transaction address, old value address, which generates things if changed, and is also in the shared pool

At this time, lsnrctl stop

The select salary from employes; is still connected, but when you make a new connection, you find that it can't be connected.

Lsnrctl

Help

Srvctl status listener

Crs_stat-p | grep lsnr

Crs_unregister ora.LISTENER.lsnr

Srvctl add listener-p 15210 manually add listeners

Crsctl stop has shuts down the entire cluster

Emctl start dbconsole launches the graphics page

Emca regenerates the graphics page

Emca-deconfig dbcontrol db-repos drop

Emca-config dbcontrol db-repos create

Configure the second listener

Vim listener.ora

Srvctl add listener-l L2-p 15211

Srvctl start listener-l L2

Lsnrctl services l2

Vim tnsnames.ora

Sqlplus / nolog

Alter system register; forces the system to register dynamically.

Dynamic registration cannot open a database remotely

FOR15212 =

(DESCRIPTION =

(ADDRESS_LIST=

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.55) (PORT = 15212))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.55) (PORT = 15211))

))

Conn hr/oracle_4U@192.168.0.55:15212/orcl.example.com simple connection

Shutdown abort forced database shutdown

Export LANG=en_US

Netmgr Graphics configuration Web Page

Netca

Vim tnsnames.ora

Conn hr/oracle_4U@192.168.0.55:TIGER/rcat.example.com

TIGER load balancing configuration

Let the two listeners know lsnrctl services D000.

Vim listener.ora

# dynamically register LISTENER listeners

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15212))

)

)

# dynamically register L2 listeners

L2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15213))

)

)

# enable the listener LISTENER to register statically so that it can move and quiet with the listeners above

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME= rcat.example.com)

(SID_NAME= rcat)

(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/

)

)

)

SID_LIST_L2 =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME= rcat.example.com)

(SID_NAME= rcat)

(ORACLE_HOME= / u01/app/oracle/product/11.2.0/dbhome_1/

)

)

)

Vim tnsnames.ora

The client where # tnsnames.ora is located thinks that the registration service can be found in 15212, and if it can't be found, it won't be connected.

RCAT =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15212))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rcat.example.com)

)

)

The client where # tnsnames.ora is located thinks that the registration service can be found in 15212, and if it can't be found, it won't be connected.

RCAT2

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15213))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rcat.example.com)

)

)

# dynamically register FOR15212

FOR15212 =

(DESCRIPTION =

(ADDRESS_LIST=

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15212))

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15213))

)

)

# tiger is an entry written to the win client. Load balancer static 15212 and 15213 are listening ports

TIGER =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15212))

(ADDRESS = (PROTOCOL = TCP) (HOST = station90.example.com) (PORT = 15213))

(LOAD_BALANCE = yes)

)

(CONNECT_DATA =

(SERVICE_NAME = rcat.example.com)

)

)

# above need to make its dynamic registration effective, and you need to go to sqlplus to modify the configuration

. Oraenv

Rcat

Sqlplus / nolog

Conn / as sysdba

Alter system set local_listener=FOR15212

Alter register; # allows listeners to register dynamically faster, or you'll have to wait more than 2 minutes.

. Oraenv

+ ASM

Sqplus / nolog

Conn / as sysdba

Alter system set local_listener=FOR15212

# above need to make its dynamic registration effective, and you need to go to sqlplus to modify the configuration

. Oraenv

Rcat

Sqlplus / nolog

Conn / as sysdba

Alter system set local_listener=FOR15212

Alter system register; # allows listeners to register dynamically faster, or you'll have to wait more than 2 minutes.

. Oraenv

+ ASM

Sqplus / nolog

Conn / as sysdba

Alter system set local_listener=FOR15212

Alter system register; # allows listeners to register dynamically faster, or you'll have to wait more than 2 minutes.

# Let the listener register dynamically faster, otherwise you will have to wait for more than 2 minutes

Check the status of LISTENER listeners after the above

[oracle@station90 admin] $lsnrctl services LISTENER

LSNRCTL for Linux: Version 11.2.0.3.0-Production on 05-SEP-2016 23:16:52

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=station90.example.com) (PORT=15212)

Services Summary...

Service "+ ASM" has 1 instance (s).

Instance "+ ASM", status READY, has 1 handler (s) for this service... # is a dynamic registration

Handler (s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "rcat.example.com" has 2 instance (s).

Instance "rcat", status UNKNOWN, has 1 handler (s) for this service... # is a static registration

Handler (s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Instance "rcat", status READY, has 1 handler (s) for this service... # is a dynamic registration

Handler (s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "rcatXDB.example.com" has 1 instance (s). # is an implicit service that appears in dynamic registration, XMLDB

Instance "rcat", status READY, has 1 handler (s) for this service...

Handler (s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

DISPATCHER

(ADDRESS= (PROTOCOL=tcp) (HOST=station90.example.com) (PORT=44903))

The command completed successfully

Status of the L2 listener

[oracle@station90 admin] $lsnrctl services L2

LSNRCTL for Linux: Version 11.2.0.3.0-Production on 05-SEP-2016 23:19:08

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=station90.example.com) (PORT=15213)

Services Summary...

Service "rcat.example.com" has 2 instance (s).

Instance "rcat", status UNKNOWN, has 1 handler (s) for this service... # is a static registration

Handler (s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Instance "rcat", status READY, has 1 handler (s) for this service... # is a dynamic registration

Handler (s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "rcatXDB.example.com" has 1 instance (s).

Instance "rcat", status READY, has 1 handler (s) for this service... # is an implicit service that appears in dynamic registration, XMLDB

Handler (s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

# D000 is affected by this parameter sqlplus alter system set dispatchers=' (PROTOCOL=TCP) (dispatchers=3)'

DISPATCHER

(ADDRESS= (PROTOCOL=tcp) (HOST=station90.example.com) (PORT=44903))

The command completed successfully

Tip: crossdver software allows WINDOWNS programs to be installed on linux

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.