[20190115]关于共享服务与专用模式.txt

最新推荐文章于 2024-08-17 22:35:09 发布
最新推荐文章于 2024-08-17 22:35:09 发布
阅读量116 收藏
点赞数

[20190115]关于共享服务与专用模式.txt


--//前几天看https://www.cnblogs.com/kerrycode/p/10252951.html的链接,原来许多不理解的问题一下理解了.

--//关于配置共享服务的问题,最好使用单独的服务名,不要一个服务名支持两种模式,这样很容易出现一些怪问题.

--//我在这方面吃了许多苦头.

--//有一些配置网络连接串,选择缺省连接模式,这样就没有SERVER = SHARED,SERVER = DEDICATED这些内容.

--//而如果服务名支持两种模式,在没有明确配置的情况下,优先选择共享模式.

--//另外共享服务模式关闭直接路径读，异步IO,支持并行模式.参考链接:


http://blog.itpub.net/267265/viewspace-2151928/

http://blog.itpub.net/267265/viewspace-2151913/

http://blog.itpub.net/267265/viewspace-2130292/


--//如何区分这些服务支持那些模式,哪一些是静态注册的服务我自己也是很混乱的.通过我测试环境说明.


1.环境:

SCOTT@book> @ ver1

PORT_STRING         VERSION        BANNER

------------------- -------------- --------------------------------------------------------------------------------

x86_64/Linux 2.4.xx 11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


--//首先关闭数据库重启监听.

--//我的监听文件配置如下:

$ grep -v "^#" listener.ora

SID_LIST_LISTENER =

   (SID_LIST =

    (SID_DESC =

      (SDU=32767)

      (GLOBAL_DBNAME = booK123)

      (ARGV0=myapp0)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)

      (SID_NAME=book)

      )

    )


SID_LIST_LISTENERz =

   (SID_LIST =

    (SID_DESC =

      (SDU=32767)

      (GLOBAL_DBNAME = booK123)

      (ARGV0=myapp0)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)

      (SID_NAME=book)

      )

    )

   


LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(ARGV0=LLLLLL)(HOST = 0.0.0.0)(PORT = 1521)(ARGV0=KKKKK))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  )

 )


LISTENERz =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1522))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  )

 )


  

SECURE_REGISTER_LISTENER = (TCP)

ADR_BASE_LISTENER = /u01/app/oracle

DIAG_ADR_ENABLED_LISTENER=OFF

USE_NS_PROBES_FOR_DCD=true

INBOUND_CONNECT_TIMEOUT_LISTENER=10


$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 11:01:46

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(ARGV0=LLLLLL)(HOST=0.0.0.0)(PORT=1521)(ARGV0=KKKKK)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                15-JAN-2019 10:52:18

Uptime                    0 days 0 hr. 9 min. 28 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

--//有1个服务booK123,这是1个静态注册服务名,状态UNKNOWN.因为静态注册服务名根本不知道实例名为book的数据库是否存在.


$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 11:02:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(ARGV0=LLLLLL)(HOST=0.0.0.0)(PORT=1521)(ARGV0=KKKKK)))

Services Summary...

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0

         LOCAL SERVER

The command completed successfully

--//这个服务名仅仅支持DEDICATED模式.


--//实际上这个时候是通过通过服务名book123远程连接数据库的.

d:\>sqlplus sys@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.78)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=book123))) as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 15 11:12:45 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:

Connected to an idle instance.

--//注意一点这样写连接串里面不能有空格.这样可以实现远程启动数据库.这也是为什么配置dg要求配置静态注册服务名的主要原因.

--//注:如果连接串里面有空格,要使用双引号,避免作为参数解析.


2.启动数据库(nomount):

SYS@book> startup nomount

ORACLE instance started.

Total System Global Area  643084288 bytes

Fixed Size                  2255872 bytes

Variable Size             205521920 bytes

Database Buffers          427819008 bytes

Redo Buffers                7487488 bytes

--//nomount仅仅启动实例.


SYS@book> show parameter service_name

NAME          TYPE   VALUE

------------- ------ ---------------

service_names string BOOK, BOOKSHARE


SYS@book> show parameter dispatchers

NAME        TYPE   VALUE

----------- ------ -------------------------------------

dispatchers string (PROTOCOL=TCP) (SERVICE=book,bookXDB)


$ lsnrctl status

....

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

  Instance "book", status BLOCKED, has 1 handler(s) for this service...

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

Service "book" has 1 instance(s).

  Instance "book", status BLOCKED, has 1 handler(s) for this service...

The command completed successfully


$ lsnrctl services

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

  Instance "book", status BLOCKED, has 1 handler(s) for this service...

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:2 refused:0

         LOCAL SERVER

Service "book" has 1 instance(s).

  Instance "book", status BLOCKED, has 1 handler(s) for this service...

    Handler(s):

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

         LOCAL SERVER

The command completed successfully


--//增加2个服务名,BOOKSHARE,book,状态是BLOCKED.因为这个时候数据库还没有到mount状态.

--//注意这个时候并没有启动共享服务book,bookxdb.虽然s000,d000进程已经启动.

$ ps -ef | egrep 's00[0]|d00[0]'

oracle   49808     1  0 11:16 ?        00:00:00 ora_d000_book

oracle   49810     1  0 11:16 ?        00:00:00 ora_s000_book


--//这个时候远程客户端无法使用服务名BOOKSHARE,book.不过有一个方法绕过.加入(UR=A),这个相当于一个后门.


d:\>sqlplus sys@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.78)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(UR=A)(SERVICE_NAME=book))) as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 15 11:18:54 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


--//这样写sqlplus sys@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.78)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(UR=A)(SERVICE_NAME=bookshare))) as sysdba

--//不写(UR=A)报如下错误.

--//ORA-12528: TNS:listener: all appropriate instances are blocking new connections


3.启动数据库(mount):

SYS@book> alter database mount ;

Database altered.


$ lsnrctl status

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

Service "book" has 1 instance(s).

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

The command completed successfully


$ lsnrctl service

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:3 refused:0

         LOCAL SERVER

Service "book" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

The command completed successfully


--//与nomount状态很相似,仅仅服务名BOOKSHARE,book,状态是READY.也就是这个时候远程客户端可以连接数据库,连接串可以不用

--//(UR=A),当然限制sys用户.因为数据库还没有起来.

--//并且3个服务BOOKSHARE,book,booK123仅仅支持专用服务模式.


d:\> sqlplus sys@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.78)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=book))) as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 15 11:29:11 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options


--//sqlplus sys@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.78)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=bookshare))) as sysdba

--//一样ok.


4.启动数据库(open):

SYS@book> alter database open ;

Database altered.


$ lsnrctl status

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

Service "book" has 1 instance(s).

  Instance "book", status READY, has 2 handler(s) for this service...

Service "bookXDB" has 1 instance(s).

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

The command completed successfully


--//服务名增加了bookXDB.


$ lsnrctl services

..

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:4 refused:0

         LOCAL SERVER

Service "book" has 1 instance(s).

  Instance "book", status READY, has 2 handler(s) for this service...

    Handler(s):

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

         LOCAL SERVER

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

Service "bookXDB" has 1 instance(s).

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

The command completed successfully


--//可以注意一个细节,bookxdb仅仅支持共享服务模式.而book服务名增加了共享服务模式.


5.继续测试:

SYS@book> alter system set dispatchers='(PROTOCOL=TCP) (SERVICE=bookXDB,bookz,book123)' scope=memory;

System altered.


SYS@book> alter system register ;

System altered.


--//给共享服务器模式增加bookz,book123服务名.并且取消了服务名book的共享服务模式.


$ lsnrctl service

..

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:4 refused:0

         LOCAL SERVER

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

Service "book" has 1 instance(s).

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

    Handler(s):

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

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

         LOCAL SERVER

Service "bookXDB" has 1 instance(s).

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

Service "bookz" has 1 instance(s).

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

The command completed successfully


--//可以发现服务名book123,bookz增加支持共享服务模式,而服务名book的共享服务模式被取消了,仅仅支持专用连接模式.


SYS@book> alter system set dispatchers='(PROTOCOL=TCP) (SERVICE=bookXDB)' scope=memory;

System altered.


$ lsnrctl status

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

  Instance "book", status READY, has 0 handler(s) for this service...

Service "book" has 1 instance(s).

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

Service "bookXDB" has 1 instance(s).

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

Service "bookz" has 1 instance(s).

  Instance "book", status READY, has 0 handler(s) for this service...

The command completed successfully

--//注意看book123服务名现在出现两种状态,status=UNKNOWN,READY.实际上我已经取消了book123的共享服务模式,但是

--//这样操作无法删除book123动态注册的服务名,包括bookz也一样.

--//注意对应的handler(s)=0.


$ lsnrctl service

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:4 refused:0

         LOCAL SERVER

  Instance "book", status READY, has 0 handler(s) for this service...

Service "book" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "bookXDB" has 1 instance(s).

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

Service "bookz" has 1 instance(s).

  Instance "book", status READY, has 0 handler(s) for this service...


--//可以发现当前仅仅bookxdb支持共享服务模式.其它服务名支持专用服务模式(除了bookz服务名).

--//另外可以发现bookz服务还存在,但是2种模式都不支持.视乎oracle无法删除bookz这个服务.

--//bookz 对应的handler(s)=0.


SYS@book> exec dbms_service.stop_service('bookz');

BEGIN dbms_service.stop_service('bookz'); END;


*

ERROR at line 1:

ORA-44311: service bookz not running

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

ORA-06512: at "SYS.DBMS_SERVICE", line 466

ORA-06512: at "SYS.DBMS_SERVICE", line 400

ORA-06512: at line 1


SYS@book> alter system set service_names=BOOK,BOOKSHARE,bookz scope=memory;

System altered.


$ lsnrctl status

..

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

  Instance "book", status READY, has 0 handler(s) for this service...

Service "book" has 1 instance(s).

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

Service "bookXDB" has 1 instance(s).

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

The command completed successfully


SYS@book> alter system set service_names=BOOK,BOOKSHARE scope=memory;

System altered.


$ lsnrctl status

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

  Instance "book", status READY, has 0 handler(s) for this service...

Service "book" has 1 instance(s).

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

Service "bookXDB" has 1 instance(s).

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

The command completed successfully


$ lsnrctl services

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 2 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:4 refused:0

         LOCAL SERVER

  Instance "book", status READY, has 0 handler(s) for this service...

Service "book" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "bookXDB" has 1 instance(s).

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

The command completed successfully

--//这样才能删除bookz服务名.


SYS@book> alter system set service_names=BOOK,BOOKSHARE,book123 scope=memory;

System altered.


SYS@book> alter system set service_names=BOOK,BOOKSHARE scope=memory;

System altered.


$ lsnrctl status

...

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

Service "book" has 1 instance(s).

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

Service "bookXDB" has 1 instance(s).

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

The command completed successfully


--//服务名book123的动态注册才会删除.


6.再启动一个监听服务名看看.

--//我前面的监听配置还配置了一个监听服务名LISTENERz.缺省如果你启动监听服务执行lsnrctl start,启动的是缺省的

--//listener监听.我以前遇到一个问题就是对方配置一个特殊监听服务名,导致我执行lsnrctl start,client段无法连接数据库.


$ grep -v "^#" listener.ora

...

SID_LIST_LISTENERz =

   (SID_LIST =

    (SID_DESC =

      (SDU=32767)

      (GLOBAL_DBNAME = booK123)

      (ARGV0=myapp0)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)

      (SID_NAME=book)

      )

    )

..

LISTENERz =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1522))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  )

 )



$ netstat -nap | grep :1521 | grep tn[s]

(Not all processes could be identified, non-owned process info

 will not be shown, you would have to be root to see it all.)

tcp        0      0 0.0.0.0:1521                0.0.0.0:*                   LISTEN      49554/tnslsnr

tcp        0      0 192.168.100.78:1521         192.168.100.78:22140        ESTABLISHED 49554/tnslsnr


$ lsnrctl start listenerz

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 12:12:30

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

TNS-01106: Listener using listener name LISTENER has already been started

--//无法启动.


$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 12:12:55

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(ARGV0=LLLLLL)(HOST=0.0.0.0)(PORT=1521)(ARGV0=KKKKK)))

The command completed successfully


$ lsnrctl start listenerz

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 12:13:00

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

Starting /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/xxxxxyyy/listenerz/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1522)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias                     listenerz

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                15-JAN-2019 12:13:00

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/xxxxxyyy/listenerz/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1522)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully


$ lsnrctl services listenerz

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 12:17:22

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1522)))

Services Summary...

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0

         LOCAL SERVER

The command completed successfully


$ netstat -nap | grep :1522 | grep tn[s]

(Not all processes could be identified, non-owned process info

 will not be shown, you would have to be root to see it all.)

tcp        0      0 192.168.100.78:1522         0.0.0.0:*                   LISTEN      50219/tnslsnr

tcp        0      0 127.0.0.1:1522              0.0.0.0:*                   LISTEN      50219/tnslsnr


--//可以发现其它服务名book,bookshare没有动态注册成功.因为pmon进程缺省注册使用1521端口.


$ ps -ef | grep pmo[n]

oracle   49772     1  0 11:16 ?        00:00:02 ora_pmon_book


$ strace -f -p 49772 -e network

Process 49772 attached - interrupt to quit

getsockopt(0, SOL_SOCKET, SO_SNDBUF, 0x7fffedf9fabc, 0x7fffedf9fab8) = -1 ENOTSOCK (Socket operation on non-socket)

getsockopt(0, SOL_SOCKET, SO_RCVBUF, 0x7fffedf9fabc, 0x7fffedf9fab8) = -1 ENOTSOCK (Socket operation on non-socket)

socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 10

connect(10, {sa_family=AF_INET, sin_port=htons(1521), sin_addr=inet_addr("192.168.100.78")}, 16) = -1 EINPROGRESS (Operation now in progress)

getsockopt(10, SOL_SOCKET, SO_SNDBUF, [-1298728016444112896], [4]) = 0

getsockopt(10, SOL_SOCKET, SO_RCVBUF, [-1298728016444041900], [4]) = 0

getsockname(10, {sa_family=AF_INET, sin_port=htons(25054), sin_addr=inet_addr("192.168.100.78")}, [16]) = 0

^CProcess 49772 detached


--//因为启动监听使用1522,无法动态注册成功.必须修改参数local_listener.参考链接:

--//http://blog.itpub.net/267265/viewspace-2083455/=>[20160418]修改oracle监听端口.txt 


SYS@book> alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1522))' scope=memory ;

System altered.


SYS@book> alter system register;

System altered.


$ strace -f -p 49772 -e network

Process 49772 attached - interrupt to quit

getsockopt(0, SOL_SOCKET, SO_SNDBUF, 0x7fffedf9fabc, 0x7fffedf9fab8) = -1 ENOTSOCK (Socket operation on non-socket)

getsockopt(0, SOL_SOCKET, SO_RCVBUF, 0x7fffedf9fabc, 0x7fffedf9fab8) = -1 ENOTSOCK (Socket operation on non-socket)

socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 10

connect(10, {sa_family=AF_INET, sin_port=htons(1522), sin_addr=inet_addr("192.168.100.78")}, 16) = -1 EINPROGRESS (Operation now in progress)

getsockopt(10, SOL_SOCKET, SO_SNDBUF, [-1298728016444077260], [4]) = 0

getsockopt(10, SOL_SOCKET, SO_RCVBUF, [-1298728016443998016], [4]) = 0

getsockname(10, {sa_family=AF_INET, sin_port=htons(3098), sin_addr=inet_addr("192.168.100.78")}, [16]) = 0

^CProcess 49772 detached


SYS@book> show parameter service

NAME          TYPE   VALUE

------------- ------ ---------------

service_names string BOOK, BOOKSHARE


SYS@book> show parameter dispatchers

NAME        TYPE   VALUE

----------- ------ --------------------------------

dispatchers string (PROTOCOL=TCP) (SERVICE=bookXDB)


$ lsnrctl status listenerz


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 15:34:46


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias                     listenerz

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                15-JAN-2019 15:32:05

Uptime                    0 days 0 hr. 2 min. 40 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/xxxxxyyy/listenerz/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1522)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

Service "book" has 1 instance(s).

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

Service "bookXDB" has 1 instance(s).

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

The command completed successfully


$ lsnrctl services listenerz

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JAN-2019 14:58:50

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1522)))

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Services Summary...

Service "BOOKSHARE" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "booK123" has 1 instance(s).

  Instance "book", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0

         LOCAL SERVER

Service "book" has 1 instance(s).

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

    Handler(s):

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

         LOCAL SERVER

Service "bookXDB" has 1 instance(s).

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

    Handler(s):

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

         DISPATCHER <machine: xxxxxyyy, pid: 49808>

         (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxyyy.com)(PORT=26919))

The command completed successfully


--//这里仅仅看到127.0.0.1的IP.,不过远程能正常登录数据库.





来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2558389/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2558389/

cuixun7780
关注
12C ORA-错误汇总17 NZE-43000 to ORA-56974
ugghhj的博客
11-11 1363
12C ORA-错误汇总17 NZE-43000 to ORA-56974
23.网络文件共享服务
qq_39544887的博客
03-13 2849
1 存储类型 存储类型分为三种 直连式存储：Direct-Attached Storage，简称DAS 存储区域网络：Storage Area Network，简称SAN 网络附加存储：Network-Attached Storage，简称NAS 1.1 DAS存储 DAS存储是最常见的一种存储方式，尤其是在中小企业应用中。PC中的硬盘或只有一个外部SCSI接口的JBOD都属于DAS架构。DAS是指存储设备直接连接到服务器总线上，存储设备只与一台独立的主机连接，其他主机不能使用这个存储设备。DAS存
oracle监听查看说明,Oracle监听(Listener)中services说明
weixin_35513425的博客
04-07 842
Oracle 监听(Listener) 中 services 说明一. 查看service1.1 先看下一个监听查看的示例：[Oracle@db2 ~]$ lsnrctl serviceLSNRCTL for Linux: Version 10.2.0.1.0 -Production on 19-JUL-2011 01:24:43Copyright (c) 1991, 2005, Oracle. ...
Handler杂谈【二】Handler的用法及解析
AfinalStone的专栏
12-22 700
原文地址：https://www.jianshu.com/p/7cdf2c2ed354 在Handler机制中，每一个线程有一个Looper，Looper.loop()一直无限循环，为什么没有造成ANR呢？ 首先要知道造成ANR的基本原因是： 1.在5秒内没有响应输入的事件（例如，按键按下，屏幕触摸） 2.BroadcastReceiver在10秒内没有执行完毕 造成以上两点的原因有很多，比如在主...
ubuntu22.04配置samba实现ubuntu与windows共享文件夹
王人冉的博客
11-21 7241
ubuntu中下载Android aosp源码后想在windows中直接查看，将ubuntu文件系统映射到windows系统中，如下： 安装 sudo apt-get install samba # 安装samba sudo apt-get install smbclient # 安装smbclient sudo apt-get install cifs-utils # 安装smbf 配置 修改配置文件 sudo gedit /etc/samba/smb.conf 然后在配置文件末尾添加
Web服务器群集：podman与docker技术集群
cronaldo91的博客
07-06 1717
QEMU模拟IO设备（网卡，磁盘等），KVM负责cpu虚拟化+内存虚拟化。podman不需要守护进程，而dorker需要守护进程。podman采用模块化的方法，依靠专门的工具来完成特定的任务。docker是一个独立的、强大的工具，在整个循环中处理所有的容器化任务。
网络文件共享服务（一）
李凯的博客
12-18 2327
存储类型 存储类型分为三种 直连式存储：Direct-Attached Storage，简称DAS eg:家用电脑 网络附加存储：Network-Attached Storage，简称NAS 存储区域网络：Storage Area Network，简称SAN DAS存储 DAS存储是最常见的一种存储方式，尤其是在中小企业应用中。PC中的硬盘或只有一个外部SCSI接口的JBOD都属于DAS架构。...
Windows 10 搭建 开放虚拟专用网络实验（客户端与服务端）
wssfy的博客
08-03 5081
本文主要讲述了在windows上服务端与客户端的搭建以及一些问题
雨云服务器搭建异星工厂服务器
muzewei的博客
08-17 1862
异星工厂是一款关于采矿，规划并建设工厂，研发科技，自动生产以及与外星生物战斗的游戏。你在一场失败的太空移民行动中幸存了下来，却发现自己孤身一人地降落在一个充满危险生物的星球表面。除了脚下的石头和矿藏你一无所有，只能从头开始，用手砍树、挖矿，并一点一点建造你的工厂和流水线，从头开始生产出必要的装备和防御。很快你就能发展出大型的工厂，有着大片的太阳能板，可以进行石油的处理，还能管理工厂的建设和物流机器人，和你的生产所需要的其它东西。
关于DNS部署与根服务器的几点论述
zhy的博客
06-10 5988
    本文主要对根服务器的部署情况、根服务器为什么可以有几十台物理服务器共用同一个IP地址、为什么全球只有13个ipv4根服务器等进行论述，其中，对一些涉及的关键技术进行重点说明。一、DNS部署情况：1.1部署情况    根域名服务器（英语：root name server）是互联网域名解析系统（DNS）中最高级别的域名服务器，负责返回顶级域的权威域名服务器地址。它们是互联网基础设施中的重要部分...
网管教程 从入门到精通软件篇.txt
04-25
　如果不带任何参数，diskpart 命令将启动 diskpart 的 Windows 字符模式版本。 　/add 　创建新的分区。 　/delete 　删除现有分区。 　device_name 　要创建或删除分区的设备。设备名称可从 map 命令的输出...
TP-LINK WR703N无线路由改打印服务器固件
01-12
最后，"readme.txt"文件通常包含关于固件的重要信息，如版本号、变更日志、安装说明和注意事项等。在开始操作前，仔细阅读这份文件是非常必要的，以确保正确无误地完成固件升级和打印服务器的设置。 总的来说，将TP...
tools.txt
huhuoyun的专栏
02-15 972
-----------------update 2017.08.20---------------- add-tools: apt-get install eclipse-cdt-autotools apt-get install convmv fuse-convmvfs unar apt-get install blender-dbg blender-ogrexml-1.8 apt-get install libgtkmm-3.0-dbg systemtap-sdt-de.
【水果识别】基于matlab GUI形态学水果大小识别【含Matlab源码 920期】.md
10-15
CSDN Matlab武动乾坤上传的资料均有对应的代码，代码均可运行，亲测可用，适合小白； 1、代码压缩包内容 主函数：main.m； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开main.m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描博客文章底部QQ名片； 4.1 博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作 图像识别：表盘识别、车道线识别、车牌识别、答题卡识别、电器识别、跌倒检测、动物识别、发票识别、服装识别、汉字识别、红绿灯识别、火灾检测、疾病分类、交通标志牌识别、口罩识别、裂缝识别、目标跟踪、疲劳检测、身份证识别、人民币识别、数字字母识别、手势识别、树叶识别、水果分级、条形码识别、瑕疵检测、芯片识别、指纹识别
【瑕疵检测】基于matlab瓶盖瑕疵检测【含Matlab源码 730期】.md
10-15
CSDN Matlab武动乾坤上传的资料均有对应的代码，代码均可运行，亲测可用，适合小白； 1、代码压缩包内容 主函数：main.m； 调用函数：其他m文件；无需运行 运行结果效果图； 2、代码运行版本 Matlab 2019b；若运行有误，根据提示修改；若不会，私信博主； 3、运行操作步骤 步骤一：将所有文件放到Matlab的当前文件夹中； 步骤二：双击打开main.m文件； 步骤三：点击运行，等程序运行完得到结果； 4、仿真咨询 如需其他服务，可私信博主或扫描博客文章底部QQ名片； 4.1 博客或资源的完整代码提供 4.2 期刊或参考文献复现 4.3 Matlab程序定制 4.4 科研合作 图像识别：表盘识别、车道线识别、车牌识别、答题卡识别、电器识别、跌倒检测、动物识别、发票识别、服装识别、汉字识别、红绿灯识别、火灾检测、疾病分类、交通标志牌识别、口罩识别、裂缝识别、目标跟踪、疲劳检测、身份证识别、人民币识别、数字字母识别、手势识别、树叶识别、水果分级、条形码识别、瑕疵检测、芯片识别、指纹识别
Shapely-1.6.4.post2-cp35-cp35m-win_amd64.whl
10-15
Shapely-1.6.4.post2-cp35-cp35m-win_amd64.whl
Apache Flink CEP复杂事件处理详解及实战案例
10-15
内容概要：本文详细介绍了Apache Flink的FlinkCEP模块，讲解了其安装配置、事件流处理基础及其应用场景，其中包括电商欺诈检测、网络监控、实时交易系统的模式匹配以及社交媒体趋势分析的具体实现。通过多个实战示例演示了如何利用正则表达式定义复杂模式并在大数据流中识别有用的事件序列，适用于需要从实时数据流中挖掘价值的多种场景。 适用人群：具备一定大数据处理经验的研发人员、架构师以及相关领域的研究人员和技术爱好者。 使用场景及目标：针对金融反欺诈、网络安全、高频交易、物联网数据分析等领域，实现复杂事件模式的实时监测和处理。 其他说明：本文提供了大量的实践代码样本，旨在引导读者掌握Flink CEP的实际应用技巧。
SSM+JSP在线网课管理系统答辩PPT.pptx
最新发布
10-15
计算机毕业设计答辩PPT
稳压罐sw16_三维3D设计图纸.zip
10-15
稳压罐sw16_三维3D设计图纸.zip
CityLiveID：城市公共服务云与资源共享平台建设
"该文档是关于城市公共服务云及资源共享平台的建设方案，旨在构建一个集约化、智能化、网格化的政务服务云。方案介绍了CityLiveID的重要性，应用蓝图，技术方案，实施推广策略以及产品清单。" 城市公共服务云及资源...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值