> sudo su oracle
TNS_ADMIN=/u01/app/oracle/oci/network/admin LD_LIBRARY_PATH=/u01/app/oracle/oci: HOME=/u01/app/oracle/tools/home/oracle GGHOME=/u01/app/oracle/gghome ORACLE_INVENTORY=/u01/app/oracle/oraInventory/ ORACLE_HOME=/u01/app/oracle/gghome
[opc@ggcsdb4ocpunode ~]$ cd /u01/app/oracle/oci/network/admin [opc@ggcsdb4ocpunode admin]$ ls tnsnames.ora [opc@ggcsdb4ocpunode admin]$ more tnsnames.ora #GGCS generated file target = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DBAAS4OCPU)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PDB1.a228251.oraclecloud.internal) ) )
GGSCI> alter credentialstore add user demo@target alias demouser_alias GGSCI (ggcsdb4ocpunode) 3> dblogin useridalias ggcsuser_alias Successfully logged into database PDB1.
GGSCI> dblogin userid sys@target PASSWORD pwd sysdba Successfully logged into database PDB1.
SQL> alter session set container=PDB1; Session altered. SQL> create user ggdemo identified by ggdemo; User created. SQL> grant dba, connect, resource to ggdemo; Grant succeeded. SQL> connect ggdemo@PDB1/ggdemo Connected.
GGSCI (ggcsdb4ocpunode) 22> dblogin userid ggdemo@target password ggdemo
ERROR: Unable to connect to database using user ggdemo@target. Please check privileges.<br/>
ORA-00942: table or view does not exist.<br/>
Answer: After you grant the DBA role to the ggdemo user. You then can connect successfully.