How to Register Pluggable Database(PDB) with new created LISTENER

by

Connect to an idle instance and startup the instance

[oracle@ol8-19 ~]$ sqlplus / as sysdba

SQL> startup;

change container to that pluggable database

SQL> alter session set container=pdb;
Session altered.

and open it

SQL> alter pluggable database pdb open;

Now, you set local_listener

SQL> alter system set local_listener="(address=(protocol=tcp)(host=ol8-19.localdomain)
(port=1522))" scope=spfile;

System altered.

and issue the following command in order to register the service immediately

SQL> alter system register;

System altered.

and restart pluggable database

SQL> alter pluggable database pdb close immediate;

SQL> alter pluggable database pdb open;

SQL> exit;

then start listener

[oracle@ol8-19 ~]$ lsnrctl start

and recheck listener’s current status

[oracle@ol8-19 ~]$ lsnrctl status

which should start within a half minute.

More Related Contents:

  1. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  2. Oracle client ORA-12541: TNS:no listener [closed]
  3. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  4. How do I escape a reserved word in Oracle?
  5. How to put more than 1000 values into an Oracle IN clause [duplicate]
  6. ORA-30926: unable to get a stable set of rows in the source tables
  7. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  8. Fetch Oracle table type from stored procedure using JDBC
  9. “Safe” TO_NUMBER()
  10. When or Why to use a “SET DEFINE OFF” in Oracle Database
  11. error: ORA-65096: invalid common user or role name in oracle
  12. Oracle insert if not exists statement
  13. Error : ORA-01704: string literal too long
  14. Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
  15. Reason why oracle is case sensitive?
  16. Create an Excel Spreadsheet from a Oracle Database
  17. How do I turn off Oracle password expiration?
  18. ORACLE IIF Statement
  19. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  20. SQL Fiddle Output Error
  21. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  22. Oracle Age calculation from Date of birth and Today
  23. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  24. How to list active / open connections in Oracle?
  25. ORA-12705: Cannot access NLS data files or invalid environment
  26. jboss 7 oracle datasource configuration
  27. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  28. How to generate a version 4 (random) UUID on Oracle?
  29. How to test an Oracle Stored Procedure with RefCursor return type?
  30. Getting Error – ORA-01858: a non-numeric character was found where a numeric was expected

Leave a Comment