Hi,
I installed personal free version of Oracle 19c on my Windows PC. A newly created user is not able to login. Here are the steps followed so far. I created a user PDB2_ADMIN in pluggable database PDB2. select username from dba_users where username = 'PDB2_ADMIN'; confirms the user having been created successfully. select name from v$services; confirms pdb2. My \NETWORK\ADMIN\tnsnames.ora is as follows.
PDB2TNSALIAS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = PDB2.ULTRAHUB)
)
)
My \NETWORK\ADMIN\listener.ora is as follows:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PDB2.ULTRAHUB)
(SID_NAME = orcl)
(ORACLE_HOME = C:\Users\datab\Downloads\WINDOWS.X64_193000_db_home)
)
)
SQL> ALTER USER PDB2_ADMIN IDENTIFIED BY ALLCAPSPASSWORD ACCOUNT UNLOCK;
User altered.
SQL> show user;
USER is "SYS"
SQL> show con_name;
CON_NAME
------------------------------
PDB2
SQL> grant create session to PDB2_ADMIN;
Grant succeeded.
SQL> grant all privileges to PDB2_ADMIN;
Grant succeeded.
SQL> select value from v$parameter where name = 'service_names';
VALUE
--------------------------------------------------------------------------------
orcl.ultrahub
SQL> CONNECT PDB2_ADMIN/ALLCAPSPASSWORD@orcl.ultrahub;
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
On my Windows Personal PC, "OracleServiceORCL" is running as seen from Services.
Could you please let me know what could be wrong?
thanks