Sunday, November 15, 2020

EBS 12.2: Autoconfig/Sqlplus connection is faling with ORA-28547 on 19c





Issue: 

Receiving   "ORA-28547: connection to server failed, probable Oracle Net admin error"  while running autoconfig (or) connecting via sqlplus  after sourcing CDB (or) PDB env file.

Cause:

Missing $ORACLE_HOME/nls/data/9idata directory

Solution:
 
On the database server node, as the owner of the Oracle RDBMS file system and database instance, run the following command to create the $ORACLE_HOME/nls/data/9idata directory.

$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl

After creating the directory, make sure that the ORA_NLS10 environment variable is set to the full path of the 9idata directory whenever you enable the 19c Oracle home.

Now re-run the autoconfig & make sure it completes without any issues.
at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to Compile Forms , Reports & Custom.pll in R12.2

How to Compile Custom.pll   cd $AU_TOP/resource  cp CUSTOM.plx CUSTOM.plx_bkup  cp CUSTOM.pll CUSTOM.pll_bkup  frmcmp_batch module=CUSTOM.pl...

  • Terraform - count vs for_each
      Count: Before Terraform 0.12.6, the only way to create multiple instances of the same resource was to use a  count  parameter. One o...
  • How to check If a patch is applied in R12.2
    In eBusiness Suite (EBS) 12.2.x you cannot query the AD_BUGS table to check if patches have been applied.The AD_BUGS table may have entries...
  • How to Export DB_LINKS
    We used to refresh our DEV database from production.so we need to preserve the DEV dblinks before we start refresh . we need to restore aft...