Difference between revisions of "GGSCI Utility"

From Robs_Wiki
Jump to: navigation, search
(Created page with "__TOC__ == configure supplemental logging == <pre> GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> info trandata pdb4.robla.rl_objects GGSCI (rob01db01.robdomain as c##/CD...")
 
(configure supplemental logging)
Line 1: Line 1:
 
__TOC__
 
__TOC__
 +
 +
== configure a wallet ==
 +
<pre>
 +
GGSCI (rob01db01.robdomain) 1> add credentialstore
 +
GGSCI (rob01db01.robdomain) 1> alter credentialstore add user c##gg_admin password gg_admin alias c##gg_admin_root Credential store altered.
 +
GGSCI (rob01db01.robdomain) 2> alter credentialstore add user c##gg_admin@pdb4 password gg_admin alias c##gg_admin_pdb4
 +
GGSCI (rob01db01.robdomain) 3> alter credentialstore add user c##gg_admin@pdb5 password gg_admin alias c##gg_admin_pdb5
 +
GGSCI (rob01db01.robdomain as c##gg_admin@orcl/CDB$ROOT) 24> info credentialstore
 +
</pre>
  
 
== configure supplemental logging ==
 
== configure supplemental logging ==

Revision as of 07:56, 25 September 2020

configure a wallet

GGSCI (rob01db01.robdomain) 1> add credentialstore 
GGSCI (rob01db01.robdomain) 1> alter credentialstore add user c##gg_admin password gg_admin alias c##gg_admin_root Credential store altered. 
GGSCI (rob01db01.robdomain) 2> alter credentialstore add user c##gg_admin@pdb4 password gg_admin alias c##gg_admin_pdb4
GGSCI (rob01db01.robdomain) 3> alter credentialstore add user c##gg_admin@pdb5 password gg_admin alias c##gg_admin_pdb5
GGSCI (rob01db01.robdomain as c##gg_admin@orcl/CDB$ROOT) 24> info credentialstore

configure supplemental logging

GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> info trandata pdb4.robla.rl_objects   
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> add trandata pdb4.robla.rl_objects   
GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> delete trandata pdb4.robla.rl_objects