Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

new installation DB 19.3c delivers "the network adapter could not establish the connection"

cacodriSep 19 2019 — edited Sep 23 2019

Hello everyone,

I have a completely new installation on a MV aws ec2 m5.large with ol7.6.

but I don't have access from the outside, both from sqldeveloper and https: // server: 5500 / em.

The configuration is as follows:

__________________________

[ec2-user@cobrotech_DB_19_3 ~]$ ip addr

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 scope host lo

valid_lft forever preferred_lft forever

inet6 ::1/128 scope host

valid_lft forever preferred_lft forever

2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 9001 qdisc mq state UP group default qlen 1000

link/ether 12:1c:a3:0a:b4:0e brd ff:ff:ff:ff:ff:ff

inet 172.31.95.189/20 brd 172.31.95.255 scope global dynamic eth0

valid_lft 3551sec preferred_lft 3551sec

inet6 fe80::101c:a3ff:fe0a:b40e/64 scope link

valid_lft forever preferred_lft forever

[ec2-user@cobrotech_DB_19_3 ~]$ cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

172.31.95.189 cobrotech_DB_19_3 cobrotech_DB_19_3.exact.cl

[ec2-user@cobrotech_DB_19_3 ~]$ cat /etc/hostname

cobrotech_DB_19_3.exact.cl

[ec2-user@cobrotech_DB_19_3 ~]$ sudo cat /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cobrotech_DB_19_3)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

[oracle@cobrotech_DB_19_3 ~]$ cat /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

EXACT =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cobrotech_DB_19_3)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = exact)

)

LISTENER_EXACT =

(ADDRESS = (PROTOCOL = TCP)(HOST = cobrotech_DB_19_3)(PORT = 1521))

[oracle@cobrotech_DB_19_3 ~]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-SEP-2019 21:39:48

Starting /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/cobrotech_DB_19_3/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobrotech_DB_19_3)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cobrotech_DB_19_3)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 19-SEP-2019 21:39:49

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/cobrotech_DB_19_3/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobrotech_DB_19_3)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

[oracle@cobrotech_DB_19_3 ~]$ sqlplus sys as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 19 21:40:03 2019

Version 19.3.0.0.0

Enter password:

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 4831835720 bytes

Fixed Size 8906312 bytes

Variable Size 872415232 bytes

Database Buffers 3942645760 bytes

Redo Buffers 7868416 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@cobrotech_DB_19_3 ~]$ lsnrctl services

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-SEP-2019 21:41:21

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cobrotech_DB_19_3)(PORT=1521)))

Services Summary...

Service "exact" has 1 instance(s).

Instance "exact", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

LOCAL SERVER

Service "exactXDB" has 1 instance(s).

Instance "exact", status READY, has 1 handler(s) for this service...

Handler(s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

DISPATCHER <machine: cobrotech_DB_19_3.exact.cl, pid: 1644>

(ADDRESS=(PROTOCOL=tcp)(HOST=cobrotech_DB_19_3)(PORT=32487))

The command completed successfully

[oracle@cobrotech_DB_19_3 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 19-SEP-2019 21:42:15

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cobrotech_DB_19_3)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 19-SEP-2019 21:39:49

Uptime 0 days 0 hr. 2 min. 25 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/cobrotech_DB_19_3/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobrotech_DB_19_3)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=cobrotech_DB_19_3)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/19.3.0/dbhome_1/admin/exact/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "exact" has 1 instance(s).

Instance "exact", status READY, has 1 handler(s) for this service...

Service "exactXDB" has 1 instance(s).

Instance "exact", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@cobrotech_DB_19_3 ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

export ORACLE_HOME

ORACLE_SID=exact

export ORACLE_SID

PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin

export PATH

db.rsp file

####################################################################

## ##

## Specify values for the variables listed below to customize ##

## your installation. ##

## ##

## Each variable is associated with a comment. The comment ##

## can help to populate the variables with the appropriate ##

## values. ##

## ##

## IMPORTANT NOTE: This file contains plain text passwords and ##

## should be secured to have read permission only by oracle user ##

## or db administrator who owns this installation. ##

## ##

####################################################################

#------------------------------------------------------------------------------

# Do not change the following system generated value.

#------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0

#-------------------------------------------------------------------------------

# Specify the installation option.

# It can be one of the following:

# - INSTALL_DB_SWONLY

# - INSTALL_DB_AND_CONFIG

#-------------------------------------------------------------------------------

oracle.install.option=INSTALL_DB_AND_CONFIG

#-------------------------------------------------------------------------------

# Specify the Unix group to be set for the inventory directory.

#-------------------------------------------------------------------------------

UNIX_GROUP_NAME=oinstall

#-------------------------------------------------------------------------------

# Specify the location which holds the inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

#-------------------------------------------------------------------------------

INVENTORY_LOCATION=/u01/app/oraInventory

#-------------------------------------------------------------------------------

# Specify the complete path of the Oracle Base.

#-------------------------------------------------------------------------------

ORACLE_BASE=/u01/app/oracle

#-------------------------------------------------------------------------------

# Specify the installation edition of the component.

# The value should contain only one of these choices.

# - EE : Enterprise Edition

# - SE2 : Standard Edition 2

#-------------------------------------------------------------------------------

oracle.install.db.InstallEdition=EE

###############################################################################

# #

# PRIVILEGED OPERATING SYSTEM GROUPS #

# ------------------------------------------ #

# Provide values for the OS groups to which SYSDBA and SYSOPER privileges #

# needs to be granted. If the install is being performed as a member of the #

# group "dba", then that will be used unless specified otherwise below. #

# #

# The value to be specified for OSDBA and OSOPER group is only for UNIX based #

# Operating System. #

# #

###############################################################################

#------------------------------------------------------------------------------

# The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.

#-------------------------------------------------------------------------------

oracle.install.db.OSDBA_GROUP=dba

#------------------------------------------------------------------------------

# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.

# The value to be specified for OSOPER group is optional.

#------------------------------------------------------------------------------

oracle.install.db.OSOPER_GROUP=oper

#------------------------------------------------------------------------------

# The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSBACKUPDBA_GROUP=backupdba

#------------------------------------------------------------------------------

# The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSDGDBA_GROUP=dgdba

#------------------------------------------------------------------------------

# The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSKMDBA_GROUP=kmdba

#------------------------------------------------------------------------------

# The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges.

#------------------------------------------------------------------------------

oracle.install.db.OSRACDBA_GROUP=racdba

################################################################################

# #

# Root script execution configuration #

# #

################################################################################

#-------------------------------------------------------------------------------------------------------

# Specify the root script execution mode.

# - true : To execute the root script automatically by using the appropriate configuration methods.

# - false : To execute the root script manually.

# If this option is selected, password should be specified on the console.

#-------------------------------------------------------------------------------------------------------

oracle.install.db.rootconfig.executeRootScript=false

#--------------------------------------------------------------------------------------

# Specify the configuration method to be used for automatic root script execution.

# Following are the possible choices:

# - ROOT

# - SUDO

#--------------------------------------------------------------------------------------

oracle.install.db.rootconfig.configMethod=

#--------------------------------------------------------------------------------------

# Specify the absolute path of the sudo program.

# Applicable only when SUDO configuration method was chosen.

#--------------------------------------------------------------------------------------

oracle.install.db.rootconfig.sudoPath=

#--------------------------------------------------------------------------------------

# Specify the name of the user who is in the sudoers list.

# Applicable only when SUDO configuration method was chosen.

# Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database.

#--------------------------------------------------------------------------------------

oracle.install.db.rootconfig.sudoUserName=

###############################################################################

# #

# Grid Options #

# #

###############################################################################

#------------------------------------------------------------------------------

# Value is required only if the specified install option is INSTALL_DB_SWONLY

# Specify the cluster node names selected during the installation.

# Example : oracle.install.db.CLUSTER_NODES=node1,node2

#------------------------------------------------------------------------------

oracle.install.db.CLUSTER_NODES=

###############################################################################

# #

# Database Configuration Options #

# #

###############################################################################

#-------------------------------------------------------------------------------

# Specify the type of database to create.

# It can be one of the following:

# - GENERAL_PURPOSE

# - DATA_WAREHOUSE

# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.

# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

#-------------------------------------------------------------------------------

# Specify the Starter Database Global Database Name.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.globalDBName=exact

#-------------------------------------------------------------------------------

# Specify the Starter Database SID.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.SID=exact

#-------------------------------------------------------------------------------

# Specify whether the database should be configured as a Container database.

# The value can be either "true" or "false". If left blank it will be assumed

# to be "false".

#-------------------------------------------------------------------------------

oracle.install.db.ConfigureAsContainerDB=false

#-------------------------------------------------------------------------------

# Specify the Pluggable Database name for the pluggable database in Container Database.

#-------------------------------------------------------------------------------

oracle.install.db.config.PDBName=

#-------------------------------------------------------------------------------

# Specify the Starter Database character set.

# One of the following

# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,

# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,

# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.characterSet=AL32UTF8

#------------------------------------------------------------------------------

# This variable should be set to true if Automatic Memory Management

# in Database is desired.

# If Automatic Memory Management is not desired, and memory allocation

# is to be done manually, then set it to false.

#------------------------------------------------------------------------------

oracle.install.db.config.starterdb.memoryOption=false

#-------------------------------------------------------------------------------

# Specify the total memory allocation for the database. Value(in MB) should be

# at least 256 MB, and should not exceed the total physical memory available

# on the system.

# Example: oracle.install.db.config.starterdb.memoryLimit=512

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.memoryLimit=6124

#-------------------------------------------------------------------------------

# This variable controls whether to load Example Schemas onto

# the starter database or not.

# The value can be either "true" or "false". If left blank it will be assumed

# to be "false".

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.installExampleSchemas=true

###############################################################################

# #

# Passwords can be supplied for the following four schemas in the #

# starter database: #

# SYS #

# SYSTEM #

# DBSNMP (used by Enterprise Manager) #

# #

# Same password can be used for all accounts (not recommended) #

# or different passwords for each account can be provided (recommended) #

# #

###############################################################################

#------------------------------------------------------------------------------

# This variable holds the password that is to be used for all schemas in the

# starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.ALL=

#-------------------------------------------------------------------------------

# Specify the SYS password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYS=

#-------------------------------------------------------------------------------

# Specify the SYSTEM password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYSTEM=

#-------------------------------------------------------------------------------

# Specify the DBSNMP password for the starter database.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.DBSNMP=

#-------------------------------------------------------------------------------

# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.PDBADMIN=

#-------------------------------------------------------------------------------

# Specify the management option to use for managing the database.

# Options are:

# 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.

# 2. DEFAULT -If you want to manage your database using the default Database Express option.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.managementOption=DEFAULT

#-------------------------------------------------------------------------------

# Specify the OMS host to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.omsHost=

#-------------------------------------------------------------------------------

# Specify the OMS port to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.omsPort=0

#-------------------------------------------------------------------------------

# Specify the EM Admin user name to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.emAdminUser=

#-------------------------------------------------------------------------------

# Specify the EM Admin password to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.emAdminPassword=

###############################################################################

# #

# SPECIFY RECOVERY OPTIONS #

# ------------------------------------ #

# Recovery options for the database can be mentioned using the entries below #

# #

###############################################################################

#------------------------------------------------------------------------------

# This variable is to be set to false if database recovery is not required. Else

# this can be set to true.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.enableRecovery=true

#-------------------------------------------------------------------------------

# Specify the type of storage to use for the database.

# It can be one of the following:

# - FILE_SYSTEM_STORAGE

# - ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

#-------------------------------------------------------------------------------

# Specify the database file location which is a directory for datafiles, control

# files, redo logs.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata

#-------------------------------------------------------------------------------

# Specify the recovery location.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/u01/app/oracle/recovery_area

#-------------------------------------------------------------------------------

# Specify the existing ASM disk groups to be used for storage.

# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.asm.diskGroup=

#-------------------------------------------------------------------------------

# Specify the password for ASMSNMP user of the ASM instance.

# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

#-------------------------------------------------------------------------------

oracle.install.db.config.asm.ASMSNMPPassword=

Autostart configuration

************ comandos a inserta *********

#! /bin/sh -x

# chkconfig: 2345 80 05

# description: start and stop Oracle Database Enterprise Edition on Oracle Linux 5 and 6

# In /etc/oratab, change the autostart field from N to Y for any

# databases that you want autostarted.

# Create this file as /etc/init.d/dbora and execute:

# chmod 750 /etc/init.d/dbora

# chkconfig --add dbora

# chkconfig dbora on

# Note: Change the value of ORACLE_HOME to specify the correct Oracle home

# directory for your installation.

# ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

# Note: Change the value of ORACLE to the login name of the oracle owner

ORACLE=oracle

PATH=${PATH}:$ORACLE_HOME/bin

HOST=`hostname`

PLATFORM=`uname`

export ORACLE_HOME PATH

case $1 in

'start')

echo -n $"Starting Oracle: "

su $ORACLE -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" &

;;

'stop')

echo -n $"Shutting down Oracle: "

su $ORACLE -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" &

;;

'restart')

echo -n $"Shutting down Oracle: "

su $ORACLE -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" &

sleep 5

echo -n $"Starting Oracle: "

su $ORACLE -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" &

;;

echo "usage: $0 {start|stop|restart}"

exit

;;

esac

exit

********* fin comandos a insertar ********

execute:

# chmod 750 /etc/init.d/dbora

# chkconfig --add dbora

# chkconfig dbora on

oratab

exact:/u01/app/oracle/product/19.3.0/dbhome_1:Y

__________________________

Your help is greatly appreciated,

thank you

Carlos Codriansky

This post has been answered by cacodri on Sep 23 2019

Jump to Answer

Added on Sep 19 2019

#database-installation

9 comments

4,691 views