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

  Grant the below privileges to gguser - exec dbms_goldengate_auth.grant_admin_privilege('<ogg_user>'); grant select any dictionary to <ogg_user>; grant insert any table to <ogg_user>; grant update any table to <ogg_user>; grant delete any table to <ogg_user>;

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;

while working on autonomous database after import of soe schema, I got following error while doing compilations of package owned by soe schema:  Copyright (c) 1982, 2019, Oracle.  All rights reserved. Last Successful login time: Wed Feb 10 2021 20:56:22 +05:30 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL> ALTER PACKAGE SOE.ORDERENTRY COMPILE BODY; Warning: Package Body altered with compilation errors. SQL> sho error Errors for PACKAGE BODY SOE.ORDERENTRY: LINE/COL ERROR -------- ----------------------------------------------------------------- 104/13   PL/SQL: Statement ignored 104/13   PLS-00201: identifier 'DBMS_LOCK' must be declared 107/13   PL/SQL: Statement ignored 107/13   PLS-00201: identifier 'DBMS_LOCK' must be declared SQL> GRANT execute ON DBMS_LOCK TO soe; Grant succeeded. SQL> ALTER PACKAGE SOE.ORDERENTRY COMPILE BODY; Package body altered. SQL>

Adding a New Application Tier Node to an Existing System on a non shared file system:  col node_name format a30  col virtual_ip format a30  col server_id format a30  list    select node_name,virtual_ip, support_db,support_cp,support_forms,support_web,support_admin from fnd_nodes 1. Steps for adding a node on a non-shared file system     Run adpreclone.pl on both the Run and Patch Edition File Systems in the primary application tier node of the E-Business Suite instance.         Note: Before executing this step, ensure the AdminServer on both the Run Edition File System and the Patch Edition File System is running.      The AdminServer on the Patch Edition File System can be shut down after completion of adpreclone.pl.             2.     Copy the Run Edition File System to the Target secondary node.     Only the following directories ...

SQL> SELECT s.sid,        s.username,        s.program,        s.module from v$session s where module like '%AD_ZD%';               SID USERNAME ---------- ------------------------------ PROGRAM ------------------------------------------------ MODULE ----------------------------------------------------------------        214 SYSTEM sqlplus@ip-172-31-46-159.ec2.internal (TNS V1-V3 AD_ZD SQL> select event from v$session where sid=214; EVENT ---------------------------------------------------------------- library cache pin SQL> select decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',                       4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',                           7, 'PROCEDURE', 8, '...

On oracle virtualbox on my laptop, tnsping was not responding. Then I check the telnet, it was not working: [oracle@primary1 ~]$ telnet primary1 1521 Trying 192.168.1.27... telnet: connect to address 192.168.1.27: No route to host Solution: iptables -F  (  If you want to flush your firewall chains) After that my tnsping and telnet started working.

After cloning on appsTier, following was error as on source SSO was enabled: Error: applprod@hostname:…1_hostname/admin/scripts$ sh adapcctl.sh start                                                                                            You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance ... adapcctl.sh: exiting with status 204 In the logfile: 19/07/09 20:35:17 Start process -------- /erp_ndr/app/inst/apps/SID_hostname/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing ht...

My Grid version was 11.2.0.4: ./tfactl diagcollect -from "2019-06-15 17:00:00" -to "2019-06-15 18:00:00" javax.crypto.BadPaddingException: Given final block not properly padded         at com.sun.crypto.provider.SunJCE_h.b(DashoA12275)         at com.sun.crypto.provider.SunJCE_h.b(DashoA12275)         at com.sun.crypto.provider.AESCipher.engineDoFinal(DashoA12275)         at javax.crypto.Cipher.doFinal(DashoA12275)         at oracle.rat.tfa.util.EncryptionUtil.decrypt(EncryptionUtil.java:96)         at oracle.rat.tfa.CommandLine.processCommand(CommandLine.java:261)         at oracle.rat.tfa.CommandLine.main(CommandLine.java:478) Not enough space in Repository or TFA_BASE to run collections javax.crypto.BadPaddingException: Given fin...

Tnsping Net Service Name fails with TNS-12537: TNS:connection closed or Sqlplus connection errors out with Ora-12537     Cause:     * In the Sqlnet.ora file the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to some specific IP's of the Client Machine.     * If trying to connect to the Apps database, by default, with Oracle Apps Installation the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to Server Machines IP or Hostname.     Solution     (i)  You can disable these parameters in the Sqlnet.ora as following, then lsnrctl reload listener_name #tcp.validnode_checking = yes #tcp.invited_nodes=(xxx.domain.com) or    (ii) add the client machines ip address in the TCP.INVITEDNODES list, then lsnrctl reload listener_name

Initializing.     Run Edition context  : /oradev/oracle/r12/uat/fs1/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch edition context: /oradev/oracle/r12/uat/fs2/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch file system free space: 222.29 GB Validating system setup.     Node registry is valid.     [ERROR]     META:18:03:58.800: bad stylesheet: kustrigc     Encountered the above errors when performing database validations.     Resolve the above errors and restart adop. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files along with snippet of the error message corresponding to each log file. adop exiting with status = 1 (Fail) $ Solution: 1. To find the current version of the adgrants.sql script on the instance, do the following:   a. Source the database environ...

While starting services in 12.1.3 using adstrtal.sh , oacore,oafm and forms are not coming. In $LOG_HOME/ora/10.1.3/opmn/opmn.log  , there is following error while starting : 9/05/02 01:04:36 [libopmnoc4j] Process Start Error: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:37 [pm-process] Stopping Process: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:37 [libopmnoc4j] Process Stop Error: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:37 [libopmnoc4j] Failed to construct stop command for proc: 2118410796 19/05/02 01:04:37 [libopmnoc4j] Forcefully Terminating Process: default_group~oacore~default_group~1 (2118410796:6598) 19/05/02 01:04:39 [pm-process] Starting Process: default_group~oacore~default_group~1 (2118410796:0) 19/05/02 01:04:46 [libopmnoc4j] Host and Port information for port type jms not sent by the OC4J process 19/05/02 01:04:46 [libopmnoc4j] WARNING: OC4J did not send the protocol value for port...

During cloning when running autoconfig on application node in R12.2.5: [APPLY PHASE]   AutoConfig could not successfully execute the following scripts:     Directory: /appclone/r12crp2/fs1/FMW_Home/webtier/perl/bin/perl -I /appclone/r12crp2/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /appclone/r12crp2/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /appclone/r12crp2/fs1/EBSapps/appl/au/12.0.0/perl -I /appclone/r12crp2/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/aix-thread-multi-64all /appclone/r12crp2/fs1/inst/apps/infrcrp2_cndarupgdbop01/admin/install       txkGenADOPWrapper.pl    INSTE8_APPLY       1 AutoConfig is exiting with status 1 AutoConfig execution completed on Wed Apr 17 16:11:48 2019 Time taken for AutoConfig execution to complete : 4 mins  16 secs Cause: This happens occasionally when old nodes are left in 12.2 tables and might be "fnd_conc_clone.setup_clean" was not exe...

ORA-16826: apply service state is inconsistent with the DelayMins property (Doc ID 1608166.1) DGMGRL> show configuration verbose; Configuration - orcl1_site   Protection Mode: MaxPerformance   Databases:     orcl1   - Primary database     dgorcl1 - Physical standby database        Warning: ORA-16826: apply service state is inconsistent with the DelayMins property      <<<<<<<<<<<<<<< Solution: Check on Which node MRP process is running. SQL>alter database recover managed standby database cancel; SQL> alter database recover managed standby database using current logfile disconnect;