Hello.
I´ve installed Oracle 10.2.0.5.0 on Oracle Linux 6.5
I´ve created tnsnames.ora, lisntener.ora and sqlnet.ora by command line, as well a database who is in open state.
I can connect by SqlPlus without any problem.
This is my configuration:
| listener.ora | sqlnet.ora | tnsames.ora |
|---|
LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = MyLinuxDB) (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1) (SID_NAME = MyLinuxDB) ) ) LOCAL_OS_AUTHENTICATION_LISTENER = OFF | NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) SQLNET.AUTHENTICATION_SERVICES = (none) | MyLinuxDB= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = MyLinuxDB) ) ) |
When I run lsnrctl services with Oracle user I have this output:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "MyLinuxDB" has 1 instance(s).
Instance "MyLinuxDB", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
But, if I type tnsping MyLinuxDB with the same Oracle user I have this:
Used parameter files:
/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = MyLinuxDB)))
TNS-12541: TNS:no listener
another strange behavior is that I can stop or start listener with Oracle user, but if I try it as root user I don´t have permision to start it, I only can stop it as root.
[root]# lsnrctl stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
[root]# lsnrctl start
Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
Linux Error: 13: Permission denied
Can anybody help me to understand what I doing wrong?
Regards