Ravi Jaiswal

********For Connection through SQL Developer (or any IDE) using service name *************  Let Suppose, sid,db_name,db_unique_name,instance_name = oradb (are same by default installation in Single Instances) service_names (in DB) =oradb (by default)  Suppose, we set service names (in DB) = ora 1. Service name inside oracle database. show parameter service_names; 2. Global names should be same in case of Static Listener.  3. For Connection through SQL developer using service should match above criteria. Service name = " ora " will be used   ******************For Connection through " tnsnames.ora " alias name ********************* Let Suppose, SID = oradb service_names (in DB) =oradb (by default)  Suppose, we set service names (in DB) = ora We can give Alias name in tnsnames.ora file whatever like oradb, but there service name must be the ora. If we set service name in tnsnames.ora or in db. We must bounce the Listener. For Testing TNS connection is working...

 [oracle@LNX-D1V-ORCL01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 15 07:59:58 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB                            READ WRITE NO   Create the common user using the CONTAINER clause SQL> create user c##user1 identified by c##user1 container=all; User created. SQL> grant create session to c#...