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

Thread: Can't connect do pdbs - Listener problem?

  1. #1
    Join Date
    Mar 2023
    Posts
    2

    Unhappy Can't connect do pdbs - Listener problem?

    Hi everyone, it's my first time configuring a VM with Oracle Linux and Oracle 18.3 on it.
    Everything was going ok, but I'm having some trouble to connect to my PDBs.
    I can connect to my main container using SQL Developer from a client machine, but can't connect to the pdbs...
    The pdbs are open, and I can alter session to get into them, I just can't connect to them directly...
    I have been going back and forth and trying many things for a few days now, and just can't find a way to connect to them.
    Any help is truly appreciated.

    They seem to be up and running...
    SQL> show pdbs

    CON_ID CON_NAME OPEN MODE RESTRICTED
    ---------- ------------------------------ ---------- ----------
    2 PDB$SEED READ ONLY NO
    3 ORCLPDB READ WRITE NO
    4 PDBTS READ WRITE NO

    My listener is never with status READY, always UNKNOWN...
    Services Summary...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    Service "orclpdb" has 1 instance(s).
    Instance "orclpdb", status UNKNOWN, has 1 handler(s) for this service...
    Service "pdbts" has 1 instance(s).
    Instance "pdbts", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    And here is my Listener...
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1539))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1539))
    )
    )

    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (GLOBAL_DBNAME=orcl)
    (SID_NAME=orcl)
    (ORACLE_HOME=/u01/app/oracle/product/18/db_1)
    )
    (SID_DESC=
    (GLOBAL_DBNAME=orclpdb)
    (SID_NAME=orclpdb)
    (ORACLE_HOME=/u01/app/oracle/product/18/db_1)
    (SERVICE_NAME=orclpdb)
    )
    (SID_DESC=
    (GLOBAL_DBNAME=pdbts)
    (SID_NAME=pdbts)
    (ORACLE_HOME=/u01/app/oracle/product/18/db_1)
    (SERVICE_NAME=pdbts)
    )
    )


    I can connect using SQL Developer to the ORCL root container, but just can't manage to connect to the pdbs

  2. #2
    Join Date
    Mar 2023
    Posts
    2
    In SQL Developer:



    Status : Failure -Test failed: ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 4150
    Additional information: 1396612763

    In SQLPlus:


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