I have installed oracle 10g on a ubuntu 10.x, This is my first time installation. After installing I tried to start it with the command below.
tsegay@server-name:/u01/app/oracle/product/10.2.0/db_1/bin$ lsnrctl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-DEC-2010 22:46:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
Listener failed to start. See the error message(s) above...
my listener.ora file looks like this:
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = acct-vmserver)(PORT = 1521))
)
)
I can guess the problem is with permission issue, But i dont know where I have to do the change on permission.
Any help is appreciated …
EDIT##
When i run with the command sudo, i got this
tsegay@server-name:/u01/app/oracle/product/10.2.0/db_1$ sudo ./bin/lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-DEC-2010 01:01:03
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting ./bin/tnslsnr: please wait...
./bin/tnslsnr: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
Best Answer
The listener must be started using the same account you used to install Oracle. Typically, this account is named 'oracle'.
Using sudo, the command line should be:
(btw, I don't think that using Ubuntu to run an Oracle database is supported by Oracle)