我在linux服务有两个用户oracle, 和admin. 我用oracle用户sqlplus数据库时,可以正常登录;但用admin用户登录时 ,却提示ORA-12541: TNS: 无监听程序。执行lsnrctl status时,显示如下:我怀疑可能是权限问题,但不知如何确认是否权限问题。请大侠们不吝指教。
oracle安装目录的权限如下:
$ ll
总用量 40
drwxr-x--- 3 oracle oinstall 4096 2012-01-06 14:43 admin
drwxr-xr-x 5 oracle oinstall 4096 2012-01-06 13:44 cfgtoollogs
drwxr-xr-x 2 oracle oinstall 4096 2012-01-06 10:56 checkpoints
drwxrwxr-x 4 oracle oinstall 4096 2012-01-06 10:25 diag
drwxr-x--- 6 oracle oinstall 4096 2012-01-06 13:52 flash_recovery_area
drwxr-xr-x 3 oracle oinstall 4096 2012-01-06 14:43 oradata
drwxr-xr-x 3 oracle oinstall 4096 2012-01-06 11:22 oradiag_oracle
drwxrwx--- 5 oracle oinstall 4096 2012-01-06 10:24 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 2012-01-06 10:13 product
drwxr-xr-x 2 oracle oinstall 4096 2012-01-06 10:01 server
$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-1? -2012 16:12:50Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 06-1? -2012 14:56:05
Uptime 4 days 1 hr. 16 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/local/oracle11g/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /usr/local/oracle11g/diag/tnslsnr/caihf-deepin/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=caihf-deepin)(PORT=1521)))
Services Summary...
Service "upnet" has 2 instance(s).
Instance "upnet", status UNKNOWN, has 1 handler(s) for this service...
Instance "upnet", status READY, has 1 handler(s) for this service...
Service "upnetXDB" has 1 instance(s).
Instance "upnet", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle安装目录的权限如下:
$ ll
总用量 40
drwxr-x--- 3 oracle oinstall 4096 2012-01-06 14:43 admin
drwxr-xr-x 5 oracle oinstall 4096 2012-01-06 13:44 cfgtoollogs
drwxr-xr-x 2 oracle oinstall 4096 2012-01-06 10:56 checkpoints
drwxrwxr-x 4 oracle oinstall 4096 2012-01-06 10:25 diag
drwxr-x--- 6 oracle oinstall 4096 2012-01-06 13:52 flash_recovery_area
drwxr-xr-x 3 oracle oinstall 4096 2012-01-06 14:43 oradata
drwxr-xr-x 3 oracle oinstall 4096 2012-01-06 11:22 oradiag_oracle
drwxrwx--- 5 oracle oinstall 4096 2012-01-06 10:24 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 2012-01-06 10:13 product
drwxr-xr-x 2 oracle oinstall 4096 2012-01-06 10:01 server
$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-1? -2012 16:12:50Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 06-1? -2012 14:56:05
Uptime 4 days 1 hr. 16 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /usr/local/oracle11g/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /usr/local/oracle11g/diag/tnslsnr/caihf-deepin/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=caihf-deepin)(PORT=1521)))
Services Summary...
Service "upnet" has 2 instance(s).
Instance "upnet", status UNKNOWN, has 1 handler(s) for this service...
Instance "upnet", status READY, has 1 handler(s) for this service...
Service "upnetXDB" has 1 instance(s).
Instance "upnet", status READY, has 1 handler(s) for this service...
The command completed successfully
解决方案 »
- Oracle 中 Blob 类型,获得的它的大小单位是什么?
- 触发器编译错误
- select 的时候如何指定字段默认值
- 100分提问,通过在Oracle中编写Java存储过程,对于Java返回的自定义对象,Oracle该如何处理呢?
- 请教维表替换的sql怎么写
- 才鸟求救!!
- 请问,哪位高手有SI Object Browser软件的800308版本的注册码,恳请不吝赐教。
- 求用jbuilder调用oracle数据库的开发过程
- 关于查询重复记录的问题?
- !!!!!!急啊,100分求救,redhat9下安装oracle,为什么我下载了Oracle8.17后,双击runintaller后什么反应也没有,命令行也不行,怎么
- 新手求救 Qracle登录的那个帐户被锁定怎么办
- 修改数据类型提示ORA-25150错误
(SID_DESC =
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME = /oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)然后重启监听,再试试。
sqlplus命令只對Oracle數據庫的用戶有效,與Linux系統用戶無關。
http://blog.csdn.net/luiseradl/article/details/7064916
总用量 20
drwxr-xr-x 2 oracle oinstall 4096 2012-01-06 10:14 samples
-rw-r----- 1 oracle oinstall 541 2012-01-06 11:38 listener.ora
-rw-r----- 1 oracle oinstall 187 2007-05-09 14:59 shrept.lst
-rw-r--r-- 1 oracle oinstall 233 2012-01-06 10:24 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 338 2012-01-06 14:43 tnsnames.oraminruicjdx 的方法应该是可以的。