TNS-01190 錯誤解決方案

TNS-01190 錯誤解決方案

由於監聽程式原來是使用的是連接埠1532.現在修改成1521,結果不能啟動說監聽已經啟動了.於是停止監聽報錯
 TNS-01190: The user is not authorized to execute the requested listener command
 [Oracle@bkjia admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2014 11:23:07

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

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

[oracle@bkjia admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2014 11:23:24

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bkjia)(PORT=1521)))
TNS-01190: The user is not authorized to execute the requested listener command
 
查看監聽狀態:
[grid@bkjia ~]$ ps -ef | grep -i listener
grid      4180    1  0 11:28 ?        00:00:00 /grid/11.2.0/grid/bin/tnslsnr LISTENER -inherit
grid      4517  4138  0 11:56 pts/1    00:00:00 grep -i listener
[oracle@bkjia ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2014 11:24:25

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bkjia)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                03-JUL-2014 10:40:26
Uptime                    0 days 0 hr. 43 min. 59 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /grid/11.2.0/grid/network/admin/listener.ora
Listener Log File        /grid/11.2.0/grid/log/diag/tnslsnr/bkjia/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bkjia)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "jycs" has 1 instance(s).
  Instance "jycs", status READY, has 1 handler(s) for this service...
Service "jycs (ORACLE_HOME =/u01/app/oracle/11.2.0/db" has 1 instance(s).
  Instance "jycs", status UNKNOWN, has 1 handler(s) for this service...
Service "jycsXDB" has 1 instance(s).
  Instance "jycs", status READY, has 1 handler(s) for this service...
The command completed successfully
 
其中:Security ON: Local OS Authentication 此條提示資訊表明監聽處於Local OS Authentication認證模式.Oracle 10g版本以及之後的版本中推出了監聽的本地作業系統認證安全特性.若監聽程式是在目前使用者下啟動的，則目前使用者具有管理監聽的所有權利，其他使用者對監聽的管理將受到限制
 
因為資料庫是11.2.0.1而且使用了oracle restart特性且使用者為grid.註冊了listener服務且只對預設連接埠1521有效.之前是1532所以oracle restart不會自動重啟監聽.由於將連接埠修改成了1521所以oracle restart自動重啟了listener
 [grid@bkjia ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): bkjia
 
由於Oracle restart 以grid使用者自動啟動了監聽所以oracle使用者不能重動由grid使用者所啟動的監聽。

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

Linux-6-64下安裝Oracle 12C筆記

在CentOS 6.4下安裝Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虛擬機器中安裝步驟

Debian 下 安裝 Oracle 11g XE R2

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