oracle

I was getting the error , when I was clicking on "register" button in step2. Instead of of using the hostname ,I used the private IP. example 10.0.0.X:1521/service_name = After replacing the hostname under connect string to private IP , I was able to register the database.

 RMAN> DUPLICATE PLUGGABLE DATABASE pdb1 AS pdb1_in_cdb19 FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT ('ORCL', 'CDB19');2> 3>  Starting Duplicate PDB at 27-JAN-22 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=403 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate PDB command at 01/27/2022 15:47:52 RMAN-05501: aborting duplication of target database RMAN-05655: specified REMOTE_RECOVERY_FILE_DEST parameter is NULL REMOTE_RECOVERY_FILE_DEST specifies a directory from which to read archive log files during a pluggable database (PDB) refresh operation if the source is not available. Solution: In the auxiliary, I set REMOTE_RECOVERY_FILE_DEST from null to  SQL> show parameter ...

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jan 26 18:50:15 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.   All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> ALTER DATABASE FLASHBACK OFF Above command was taking a long time, then I checked the alert log file and there was following error: """ ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit 2022-01-26T18:32:55.460673+00:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_tt00_24306.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 bytes limit 2022-01-26T18:33:55.875760+00:00 Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_tt00_24306.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 15728640000 b...

My Environment where tested: OCI DBCS 19c SQL> alter session set container=OCIBENCH; Session altered. SQL> drop pluggable database OCIBENCH; drop pluggable database OCIBENCH * ERROR at line 1: ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged SQL> drop pluggable database OCIBENCH including datafiles; Pluggable database dropped. SQL>  SQL> sho pdbs     CON_ID CON_NAME   OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED   READ ONLY  NO 3 ORCL_PDB1   READ WRITE NO SQL> 

My Environment: OCI Compute Instance OEL 8 while accesing using vncviewer Solution: export CV_ASSUME_DISTID=8.2   then run ./runInstaller from same screen where you set above parameter.

 My Environment: Source: Macbook Target Server: OCI Compute Mahcine, OEL 8 ==================================================================== [opc@myserver ~]$ sudo yum -y groups install "Server with GUI" [opc@myserver ~]$ sudo yum -y install tigervnc-server [opc@myserver ~]$ sudo yum -y install xterm [opc@myserver ~]$ sudo su - oracle [oracle@myserver ~]$ vncserver WARNING: vncserver has been replaced by a systemd unit and is about to be removed in future releases. Please read /usr/share/doc/tigervnc/HOWTO.md for more information. You will require a password to access your desktops. Password: Verify: Would you like to enter a view-only password (y/n)? n A view-only password is not used xauth:  file /home/oracle/.Xauthority does not exist New 'myserver:1 (oracle)' desktop is myserver:1 Creating default startup script /home/oracle/.vnc/xstartup Creating default config /home/oracle/.vnc/config Starting applications specified in /home/oracle/.vnc/xstartup Log file is /...