oracle

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