DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: connect to new user within PDB not working

  1. #1
    Join Date
    Apr 2020
    Posts
    2

    connect to new user within PDB not working

    Oracle 18c

    Connecting to PDB as 'sys', I cannot figure out how to connect to a schema other than 'sys'.

    Here is what I have tried after logging into Oracle 18c CDB as 'sys':

    ALTER SESSION SET CONTAINER= PDB;
    conn myschema/mypasswd

    --and also tried right from CDB

    conn myschema/mypasswd@PDB;

    Both approaches fail to get me connected as 'myschema' within the PDB.
    Any suggestions?

  2. #2
    Join Date
    Apr 2020
    Posts
    2
    The issue was that the tnsnames.ora file had an incorrect HOST ip address for the tns alias.
    All the SQL in the initial details now works as advertised.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width