ORA-28305: WALLET_LOCATION in sqlnet.ora file for container database is not supported.

ORA-28305: WALLET_LOCATION in sqlnet.ora file for container database is not supported.

Based on the Oracle documentation and bug 17758886 we need to remove the wallet_location from our sqlnet.ora

Checking the Oracle documentation the following is mentioned:

All the PDBs in a CDB have the same database unique name. By placing wallets in the default location, each PDB can have its own identity.

Note that since there is only one sqlnet.ora file for a CDB, the wallet location in sqlnet.ora is not supported for CDBs, because each PDB must have its own wallet. Which means I need to remove the wallet location from my sqlnet.ora

The default location for the cdb$root would be: ORACLE_BASE/admin/db-unique-name/wallet
The default location for a PDB would be: ORACLE_BASE/admin/db-unique-name/pdb-GUID/wallet

 

Based on the above information modified the sqlnet.ora and created a link from the db-unique-name location to the pdb wallet location. Altough each cdb and pdb can has his own wallet, for this environment the multitenant option is not used yet, so their is no need to have seperated wallets.

 

Get the GUID

SYS@TST>select guid,name from v$pdbs;

GUID                             NAME

-------------------------------- -------------------------------------------------
4404164297E84B3FE053D226EF0A8E73 PDB$SEED
440460742463391DE053D226EF0A2A5A PDB1

 
$ mkdir -p /u01/app/oracle/admin/TST_01/440460742463391DE053D226EF0A2A5A/
$ ln -s /u01/app/oracle/admin/TST_01/wallet  
/u01/app/oracle/admin/TST_01/440460742463391DE053D226EF0A2A5A/wallet

 

The additional step performed is to make sure when starting the database, as this is a cluster environment the srvctl set env was executed to make sure also this was using the proper sqlnet.ora file.

 $ srvctl setenv database -db tst_01 -env 
"TNS_ADMIN=/u01/app/oracle/admin/12c/network/admin"

Link to the Oracle doc: http://docs.oracle.com/database/121/REFRN/GUID-42D7474A-331D-4171-8071-513B42F40524.htm#REFRN10251

 

Hope this blog will help you.

 

12 januari 2017|12c, Multitenancy, rdbms|

Leave A Comment