Oracle Database Discussions

It says that the port is already in use. You probably have something installed that is using that port already. Turn it off.

As the message says: the port 5500 is already in use.

Ask your system administrator to execute the following cmd as user root

# lsof -n | grep 5500

and get the PID from the output

this is the process occupying the port 5500.

Regards

Sven

@"handat" Please see my update. I couldn't find any process using 5500.

@"Sven-Olaf Hilmer" Please see my update. I couldn't find any process using 5500.

You need to run netstat with the following arguments:

netstat -an|grep LISTEN|grep 5500

I suggest to review https://support.oracle.com/knowledge/Oracle%20Database%20Products/2277154_1.html

Also, verify your /etc/hosts file and hostname, and firewall.

@"handat" "netstat -an|grep LISTEN|grep 5500" didn't return any result

@"Dude!" my /env/hosts file looks like this:

127.0.0.1   user-linux user-linux localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         user-linux user-linux localhost localhost.localdomain localhost6 localhost6.localdomain6

x.x.x.x user-linux user-linux

/env/hosts.conf file :

multi on

/env/hostname file:

user-linux

There is no firewall file at /etc location.

Further I checked out mentioned document as well. Please see below:

# ping user-linux

PING user-linux (127.0.0.1) 56(84) bytes of data.

64 bytes from user-linux (127.0.0.1): icmp_seq=1 ttl=64 time=0.023 ms

64 bytes from user-linux (127.0.0.1): icmp_seq=2 ttl=64 time=0.019 ms

64 bytes from user-linux (127.0.0.1): icmp_seq=3 ttl=64 time=0.024 ms

64 bytes from user-linux (127.0.0.1): icmp_seq=4 ttl=64 time=0.039 ms

64 bytes from user-linux (127.0.0.1): icmp_seq=5 ttl=64 time=0.023 ms

I'm still at loss as to how can I resolve this!!

Fix your /etc/hosts. You can't have "user-linux" to resolve both to the localhost address (127.0.0.1) and another address (shown here as x.x.x.x)

Andris

@"Andris Perkons-Oracle" That's my system's IPv4 address. I removed that line and tried again, but same error.

What OS are you using exactly?

@"Dude!" Oracle Enterprise Linux 7.5. It is from Red hat.

Are you using any kind of virtualization?

What is the output of the following commands:

# hostname
# ss -ntl

Regarding your files, there is no /env directory, you probably mean /etc ?

Having your node name on the localhost line shouldn't be a problem. This was actually standard in previous OS releases and the Oracle installer was using the hostname of the first entry it found in the 127.0.0.1 line. However, you don't need it when have a static ip address, and you don't need double entries.

Depending on your configuration, it can be a good idea to define the following prior to running the Oracle installer:

# export ORACLE_HOSTNAME=linux-user.localdomain

I suggest the following:

/etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

10.0.0.1 user-linux.localdomain user-linux

You shouldn't have /etc/hosts.conf unless you running your own name server (bind). Are you?

use  your real IP instead of 10.0.0.1

3750790 wrote:

Hello Folks -

I'm trying to install Oracle DB 12cR2 on Linux machine, but getting error in "Oracle Database Configuration Assistant". I checked the logs and seems like issue with emExpressPort value: 5500.

Please see below logs:

INFO: Started Plugin named: Oracle Database Configuration Assistant

INFO: Found associated job

INFO: Starting 'Oracle Database Configuration Assistant'

INFO: Starting 'Oracle Database Configuration Assistant'

INFO: Executing DBCA

INFO: Command /home/app/oracle/product/12.2.0/dbhome_2/bin/dbca -progress_only -createDatabase -templateName General_Purpose.dbc -createAsContainerDatabase true -pdbName pdborcl -numberOfPDBs 1 -sid orcl -gdbName orcl -emConfiguration DBEXPRESS -emExpressPort 5500 -storageType FS -datafileDestination /home/app/oracle/oradata -datafileJarLocation /home/app/oracle/product/12.2.0/dbhome_2/assistants/dbca/templates -characterset AL32UTF8 -obfuscatedPasswords false -recoveryAreaDestination NONE -automaticMemoryManagement false -totalMemory 12824 -maskPasswords false -ignorePrereqFailure -skipEnforcePasswordComplexityCheck true -oui_internal

INFO: ... GenericInternalPlugIn.handleProcess() entered.

INFO: ... GenericInternalPlugIn: getting configAssistantParmas.

INFO: ... GenericInternalPlugIn: checking secretArguments.

INFO: ... GenericInternalPlugIn: starting read loop.

INFO: Read: [FATAL] [DBT-06103] The port (5,500) is already in use.

INFO: [FATAL] [DBT-06103] The port (5,500) is already in use.

WARNING: Skipping line: [FATAL] [DBT-06103] The port (5,500) is already in use.

INFO: Read: ACTION: Specify a free port.

INFO: ACTION: Specify a free port.

WARNING: Skipping line: ACTION: Specify a free port.

INFO: Completed Plugin named: Oracle Database Configuration Assistant

INFO: Oracle Database Configuration Assistant failed.

INFO: Oracle Database Configuration Assistant failed.

INFO: ConfigClient.executeToolsInAggregate action performed

INFO: Exiting ConfigClient.executeToolsInAggregate method

INFO: Calling event ConfigToolsExecuted

I am not sure where is this 5500 value is hardcoded. While configuration I never gave any port manually.

I searched online and one of the solution is to edit /etc/hosts file and include hostname over there. I've done that as well but still same error.

As per suggestions I tried to search if any process is using this port, but couldn't find one. Please see below:

I tried - netstat | grep 5500, but it gives no result.

Also tried ps | grep 5500, but it also didn't give any result.

Please help!

Thanks

First off, I never select to create a database when I do an installation of the software. The two (install Oracle vs create a database) are to separate and distinct operations. I consider it unfortunate that Oracle even allows a selection to create a database at the time of installation. I understand they consider it a convenience, but I've seen so many people over the years who don't understand the distinction.

It would appear from the above that you successfully installed the software. The only failures reported deal with dbca attempting to create a database. In fact, you may very well have created a database also, but failed to get the network components configured correctly. I'd check on that first. What do you get from the OS command 'ps -ef | grep pmon' ? Do you have an spfile and a password file in $ORACLE_HOME/dbs ?

What do you get from

ORAENV_ASK=NO

ORACLE_SID=orcl

source oranenv

sqlplus / as sysdba

If you already have a database, we can reconfigur it to use another port.

If you do not have a database, we can use dbca to create one, and you will get a chance to specify another port as you walk through the screens.

@"Dude!"

I'm not using virtualization. System has got Linux OS and installing on this OS.

hostname gives output - user-linux

ss -ntl gives below output

And Yes it's /etc and not /env. Apologies for confusion.

I updated /etc/hosts file and tried again but failed. Just to mention, I'm trying in same window by clicking Retry button and not doing full installation from start. Hope that's not a issue.

I'm not running any name server,at least not now. Should I delete the file or just the contents?

@"EdStevens"

I tried 'ps -ef | grep pmon' and get below :

There is only one file at $ORACLE_HOME/dbs which is - init.ora, though I'm not able to open it and check the contents.

After executing all four commands, it gives below output:

# sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 23 17:17:01 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:

ORA-12546: TNS:permission denied

It's not allowing me to login, may be because there is no database? If I skip it(by clicking on skip button - please see attached screenshot in original post) and finish the current installation, how can I use dbca later to create the database?

3750790 wrote:
EdStevens
I tried 'ps -ef | grep pmon' and get below :
root 
14614 21278 0 16:57 pts/2
00:00:00 grep --color=auto pmon

So you don't have a database running.  Noted.

There is only one file at $ORACLE_HOME/dbs which is - init.ora, though I'm not able to open it and check the contents.

Why can't you open it?

In any event, if that's the only file there, then it appears a database did not get created.

After executing all four commands, it gives below output:
# sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 23 17:17:01 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-12546: TNS:permission denied

If that's an actual copy and paste, then it appears you are doing this as root.  You should not.  Did you also run the installation as root?  You should not.

It's not allowing me to login, may be because there is no database? If I skip it(by clicking on skip button - please see attached screenshot in original post) and finish the current installation, how can I use dbca later to create the database?

You use dbca by going to a command prompt as the oracle installation owner (NOT AS ROOT!!!!) and executing "dbca"

Creating and Configuring a Database

You will need to restart the system for changes in the hosts file to take affect. Although using a dash in the hostname shouldn't be a problem, but I would not use it, especially not "user-linux". I suggest you use something else, like linux01 for example. A busy TCP port 5500 is not the issue, at least not anymore. A failed installation, depending on the issue, can leave dead processes behind, so "retry" may not work. I suggest to abandon the installation, restart the system, clean up, and start over again.

You need to follow the installation instructions carefully. You cannot install Oracle Database by just running the installer, unless you know what you're doing. Nobody here can look over your shoulder. You're not installing the software as root, are you?

Error messages do not necessarily point to the problem. What you see in the log is also a warning, but not a failure. You may have other problems that cause the installation to fail.