Hello Experts,
This is Avinash, a student, trying to learn Oracle 11g Administration. I encountered a problem while installing Oracle Database 11g r2 on Red Hat Enterprise Linux 6.0 (guest).
I have Windows 7 Ultimate (32-bit) as host OS and use Oracle Virtual Box for Red Hat Enterprise Linux 6 (guest).
Being new to UNIX environment, I had to get help from internet to install the Oracle Database. I installed the Database software using http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_23.shtml.
It was successfully installed. Only while I tried to configure the LISTENER, I came across an error, which is in the following screenshots:
The error was produced while I was trying to use the default port (1521) for listener configuration. So, I tried several other ports for the listener but -- same error. I also tried to find out non-listening ports using netstat command and tried those ports, but same error. I might have used 100s of port numbers, but the error was still there.
Finally I ignored the error and continued with the installation and checked the listener status.
[oracle@bugsbunny Desktop]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-OCT-2015 18:21:29
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 101: Network is unreachable
Of course the listener was not configured. I ignored that and tried to create a database using the Database Configuration Assistant. I chose CUSTOM database. Also, I chose Sample Schemas to be installed. While creating the database, it again produced some errors when the DBCA reached ADDING SAMPLE SCHEMAS stage. The errors are as follows;
ORA:01017: invalid username/password, logon denied ---- it happened several times. I ignored all the errors -- I suppose it was trying to add different sample users(schemas)
The next error while being at ADDING SAMPLE SCHEMAS, was regarding TNS.
ORA:12154 - TNS could not resolve the connect identified. I ignored this error too and continued.
The last error I got was as follows:
Somehow I feel that the both the errors (DEFAULT PORT NUMBER BUSY and the DBCA error) are related. If not, please accept my apology for including them both in one discussion.
I tried to get further help from internet. Tried lots of posts and blogs but I could not find any solution for the port number issue. I also tried the OraDocs but I did not find any solution. OraDocs explain how to configure listener but do not provide any information about other ports that can be used or about what needs to be done if the default port is busy.
Please help me
which other port numbers (other than the default 1521) I could use for listener configuration?
please help me what other changes i ll have to do on red hat linux in order to get this configuration thing going.
Thanking you.