1 Reply Latest reply on Nov 17, 2019 1:46 PM by myluism

    Can not connect to a 12c Database to run RCU

    myluism

      Hi all.

       

      Here is the situation:

       

      - One Oracle Linux Server with Oracle Database 12c SE2 :

       

      [oracle@oraclelinux ~]$ hostname

      oraclelinux

      [oracle@oraclelinux ~]$ lsnrctl status

       

       

      LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 16-NOV-2019 11:49:46

       

       

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

       

       

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

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

      Start Date                15-NOV-2019 10:22:45

      Uptime                    1 days 1 hr. 27 min. 0 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/oracle/product/12.2.0.1/db_1/network/admin/li                                                                                        stener.ora

      Listener Log File         /u01/app/oracle/diag/tnslsnr/oraclelinux/listener/aler                                                                                        t/log.xml

      Listening Endpoints Summary...

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

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

      Services Summary...

      Service "976296606283e585e053090801c00461" has 1 instance(s).

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

      Service "9763188b2a31cfc7e053090801c0f98e" has 1 instance(s).

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

      Service "cdb1" has 1 instance(s).

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

      Service "cdb1XDB" has 1 instance(s).

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

      Service "cdb2" has 1 instance(s).

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

      Service "cdb2XDB" has 1 instance(s).

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

      Service "cggbd1" has 1 instance(s).

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

      Service "infra" has 1 instance(s).

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

      The command completed successfully

       

       

      [oracle@oraclelinux ~]$

       

      There are 2 containers on this server.

       

      CDB1 and INFRA is the pluggable Database i want to connect to.

       

       

      It looks like a pretty simple problem, but i can't not connect to either INFRA or CDB1.

       

      - I'm a hundred 100% sure is it not password related. The password is correct.

      - I can ping to the database server. I have even tried using the IP address, but no success.

      - Also firewall is disable on both servers:

       

      Database Server:

       

      [root@oraclelinux ~]# systemctl status firewalld

      ● firewalld.service - firewalld - dynamic firewall daemon

         Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

         Active: inactive (dead)

           Docs: man:firewalld(1)

      [root@oraclelinux ~]#

       

      [root@oraclelinux ~]# cat /etc/selinux/config

       

      SELINUX:

       

      # This file controls the state of SELinux on the system.

      # SELINUX= can take one of these three values:

      #     enforcing - SELinux security policy is enforced.

      #     permissive - SELinux prints warnings instead of enforcing.

      #     disabled - No SELinux policy is loaded.

      # SELINUX=enforcing

      # SELINUXTYPE= can take one of three values:

      #     targeted - Targeted processes are protected,

      #     minimum - Modification of targeted policy. Only selected processes are protected.

      #     mls - Multi Level Security protection.

      SELINUXTYPE=targeted

       

       

      SELINUX=permissive

       

       

      [root@oraclelinux ~]#

       

      On App Server:

       

      [root@redlineApp ~]# systemctl status firewalld

      ● firewalld.service - firewalld - dynamic firewall daemon

         Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

         Active: inactive (dead)

           Docs: man:firewalld(1)

       

       

      nov 08 16:16:37 redlineApp systemd[1]: Starting firewalld - dynamic firewall daemon...

      nov 08 16:16:38 redlineApp systemd[1]: Started firewalld - dynamic firewall daemon.

      nov 15 18:28:05 redlineApp systemd[1]: Stopping firewalld - dynamic firewall daemon...

      nov 15 18:28:06 redlineApp systemd[1]: Stopped firewalld - dynamic firewall daemon.

      [root@redlineApp ~]#

       

      [root@redlineApp ~]# cat /etc/selinux/config

       

       

      # This file controls the state of SELinux on the system.

      # SELINUX= can take one of these three values:

      #     enforcing - SELinux security policy is enforced.

      #     permissive - SELinux prints warnings instead of enforcing.

      #     disabled - No SELinux policy is loaded.

      SELINUX=permissive

      # SELINUXTYPE= can take one of three values:

      #     targeted - Targeted processes are protected,

      #     minimum - Modification of targeted policy. Only selected processes are protected.

      #     mls - Multi Level Security protection.

      SELINUXTYPE=targeted

       

       

       

       

      [root@redlineApp ~]#

       

      I have run setenforce Permissive on both servers .

       

      I'm trying to perform this installation using teamviewer which is an absolute nightmare because the installer runs in a weird way. Delays, no character echo, etc.

       

      I have done this many times on Oracle 11g. This is my first time on 12c but as far as i can see services are up, registered with the listener, does not work even when trying to connect to the container database.

       

      I have not idea here.

       

      Maybe a reboot or using client vnc to see if this is the problem.