Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

location of xdb wallet

EdStevensJan 23 2018 — edited Jan 25 2018

I have three databases recently upgraded from 11.2.0.4 to 12.1.0.2 (SE-One to SE-Two). One production and two test dbs that are created with an rman DUPLICATE from backup of the prod.

I took no specific actions dealing with the configuration of EM Express, beyond specifying the port at the relevant screen in the DBUA.  But I just happened to notice that the location of the wallet is different.  On the two test db's (on the same server), a 'lsnrctl status' showed this. Note the difference in the value of MY_WALLET_DIRECTORY.  The database DWDEV was the one I had just finished upgrading when I checked this.

 

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=itdwdev.myorg.org)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=itdwdev.myorg.org)(PORT=5501))(Security=(my_wallet_directory=/u01/app/oracle/admin/DWSTG/xdb_wallet))(Presentation=HTTP)(Session=RAW))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=itdwdev.myorg.org)(PORT=5502))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.2/dbhome_1/admin/DWDEV/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

I simply copied the above lines from the output of 'lsnrctl status', executed as part of the check after updating LOCAL_LISTENER, post-update.  To get even 'curiorsor and curiosor', when I went back to check it again to put this post together, I got this:

oracle:+ASM$ lsnrctl status|grep xdb_wallet

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=itdwdev.myorg.org)(PORT=5501))(Security=(my_wallet_directory=/u01/app/oracle/admin/DWSTG/xdb_wallet))(Presentation=HTTP)(Session=RAW))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=itdwdev.myorg.org)(PORT=5502))(Security=(my_wallet_directory=/u01/app/oracle/admin/DWDEV/xdb_wallet))(Presentation=HTTP)(Session=RAW))

The difference disappeared!  I swear I did nothing between the two except bounce the database to change the COMPATIBLE parameter to 12.1.0, and go to a meeting!  And it was the db I was NOT upgrading (having upgraded it previouisly) that changed!

And by contrast, the production server shows this:

oracle:+ASM$ lsnrctl status|grep xdb_wallet

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=itdwprod.myorg.org)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.2/dbhome_1/admin/DWPRD/xdb_wallet))(Presentation=HTTP)(Session=RAW))

No problem to be solved, but "veddy intelesting.  Veddy, veddy intelesting".

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2018
Added on Jan 23 2018
2 comments
2,048 views