Oracle Forms

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!

Can not connect to a 12c Database to run RCU

myluismNov 16 2019 — edited Nov 17 2019

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

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.

This post has been answered by myluism on Nov 17 2019

Jump to Answer

Added on Nov 16 2019

#forms, #moved-from-devops

1 comment

491 views