9 Replies Latest reply on Sep 23, 2019 3:36 PM by Dude!

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

    cacodri

      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

       

      Copyright (c) 1991, 2019, Oracle.  All rights reserved.

       

      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

       

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

       

      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

       

      Copyright (c) 1991, 2019, Oracle.  All rights reserved.

       

      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

       

      Copyright (c) 1991, 2019, Oracle.  All rights reserved.

       

       

      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

      fi

       

      # 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

       

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

      ## Copyright(c) Oracle Corporation 1998,2019. All rights reserved.##

      ##                                                                ##

      ## 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

        • 1. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
          EdStevens

          You've shown a few of the things we'd ask to see.  And a whole lot of stuff that is totally irrelevent.

           

          We'd want to see the listener.ora file, and the output of 'lsnrctl status'.

           

          We don't need to see the ouput of 'lsnrctl start'.

          We don't need to see

          - .bash_profile

          - db.rsp file

          - autostart configuration

          - oratab

           

          Pages and pages of totally irrelevant information.

           

          So, it seems you've shown everything expect the one thing we'd want to see first - the actual, full, complete error message, in context.

          • 2. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
            Dude!

            While it is valid to have underscores in a domain name, the general recommendation is not to. The info you posted suggests some misconceptions on several levels that are beyond the scope of a single post, however, regarding your connectivity problem, I suggest to check your Firewall configuration, or disable temporarily to verify it is not the problem.

            1 person found this helpful
            • 3. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
              cacodri

              Hi EdStevens,

               

              [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 ~]$ lsnrctl status

               

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

               

              Copyright (c) 1991, 2019, Oracle.  All rights reserved.

               

               

              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

              • 4. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
                EdStevens

                I say again ..... "So, it seems you've shown everything expect the one thing we'd want to see first - the actual, full, complete error message, in context."

                 

                And as an aside, why did you feel it necessary to use 'sudo' in order to run a 'cat' command on listener.ora?

                • 5. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
                  cacodri

                  the exact error is in sqldeveloper when testing the connection, as the screenshot indicates, also when trying to access oracle EM

                   

                   

                   

                  The use of sudo is due to the fact that at that time I was logged in as user "ec2-user" not as "oracle"

                   

                  [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.

                  • 6. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
                    cacodri

                    I installed the db-19.3c again on a new ec2, but now with the suggestion of Dude! I changed the server name to "cobrotech-db-193", the same thing happens, but this time "netstat -at" delivers:

                     

                    [oracle@cobrotech-db-193 ~]$ netstat -at

                    Active Internet connections (servers and established)

                    Proto Recv-Q Send-Q Local Address           Foreign Address         State

                    tcp        0      0 localhos:x11-ssh-offset 0.0.0.0:*               LISTEN

                    tcp        0      0 localhost:6011          0.0.0.0:*               LISTEN

                    tcp        0      0 0.0.0.0:sunrpc          0.0.0.0:*               LISTEN

                    tcp        0      0 0.0.0.0:ssh             0.0.0.0:*               LISTEN

                    tcp        0     36 cobrotech-db-193:ssh    pc-85-209-241-201:60860 ESTABLISHED

                    tcp        0      0 cobrotech-db-193:9840   cobrotech-db-1:ncube-lm ESTABLISHED

                    tcp        0      0 cobrotech-db-193:ssh    pc-85-209-241-201:60859 ESTABLISHED

                    tcp        0      0 cobrotech-db-193:ssh    pc-85-209-241-201:60858 ESTABLISHED

                    tcp        0      0 cobrotech-db-193:ssh    pc-85-209-241-201:60861 ESTABLISHED

                    tcp6       0      0 localhos:x11-ssh-offset [::]:*                  LISTEN

                    tcp6       0      0 localhost:6011          [::]:*                  LISTEN

                    tcp6       0      0 [::]:fcp-addr-srvr1     [::]:*                  LISTEN

                    tcp6       0      0 [::]:43457              [::]:*                  LISTEN

                    tcp6       0      0 [::]:sunrpc             [::]:*                  LISTEN

                    tcp6       0      0 [::]:ncube-lm           [::]:*                  LISTEN

                    tcp6       0      0 [::]:ssh                [::]:*                  LISTEN

                    tcp6       0      0 cobrotech-db-1:ncube-lm cobrotech-db-193:9831   TIME_WAIT

                    tcp6       0      0 cobrotech-db-1:ncube-lm cobrotech-db-193:9840   ESTABLISHED

                    tcp6       0      0 cobrotech-db-1:ncube-lm cobrotech-db-193:9792   TIME_WAIT

                    tcp6       0      0 cobrotech-db-1:ncube-lm cobrotech-db-193:9843   TIME_WAIT

                     

                    The AMI security group is as follows:

                     

                     

                    And when I try the connection test from sqldeveloper iftop delivers:

                     

                    • 7. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
                      Dude!

                      What I would do first is to check whether the server TCP ports 1521 and 5500 are open and can be accessed from your computer. There are many ways how to do this, for example, installing nmap. Then use your PC or client system and check the server address for open ports. If the mentioned ports are closed or do not respond, then either the remote service isn't running, or access is blocked externally, which is usually a firewall. A firewall may run on several levels, the server, your PC or network gateway.

                      1 person found this helpful
                      • 8. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
                        cacodri

                        I finally solved the problem, reinstalled the db again but this time, I used:

                         

                        The "/ etc / hosts" file must contain a fully qualified name for the server.

                         

                        <IP-address> <fully-qualified-machine-name> <machine-name>

                         

                        For example.

                        127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

                        192.168.56.107 ol7-19.localdomain ol7-19

                         

                        Set the correct hostname in the "/ etc / hostname" file.

                        ol7-19.localdomain

                         

                        As indicated at: https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7

                         

                        It worked perfect, apparently the problem was in the definition of / etc / hosts and / etc / hostname.

                         

                        thank you very much to all

                         

                         

                        Carlos Codriansky

                        • 9. Re: new installation DB 19.3c delivers "the network adapter could not establish the connection"
                          Dude!

                          The "/ etc / hosts" file must contain a fully qualified name for the server.

                          Sorry that's a common misconception.

                           

                          A remote system has no knowledge or access to your local /etc/hosts file. It only matters if you use the TCP/IP address or hostname when configuring your software. You can however also use localhost, which is universal and works on any machine.

                           

                          The Oracle Listener will listen on all TCP/IP interfaces when the HOST entry in the listener.ora file matches the machine's hostname. For example, if the listener is configured to listen to host localhost and the machine hostname is localhost.localdomain, the listener will listen to "any" for incoming connections and hence also accept remote connections. If the host entry is localhost, but the machine name is not, the listener will not accept remote connections. And of course if you use a HOST name that cannot be resolved, it won't work at all.