How to Add Services to PDB
By default, Container Database (CDB) provides only one service for every Pluggable Database (PDB) for connections, but we can create our own services for various… Read More »How to Add Services to PDB
sqlplus
How to Tell What State of Database
We have already known that there're 4 states in life cycle of an instance. They are idle, nomount, mount and open. In this post, we… Read More »How to Tell What State of Database
How Oracle Find DBID
DBID Database Identifier (DBID) is a unique number that can be identified by RMAN so as to do backup and restore whenever needed. In some… Read More »How Oracle Find DBID
How Oracle RAC VIP Failover to Another Node
Since 11g, we rely more and more on SCAN Virtual IP to load balance and failover connections among nodes of a cluster, so the original… Read More »How Oracle RAC VIP Failover to Another Node
How to Connect a PDB Directly by OS Authentication
OS Authentication We usually connect to the database by / AS SYSDBA without providing any password for maintenance works, such as startup, shutdown and backup.… Read More »How to Connect a PDB Directly by OS Authentication
How to Resolve ORA-28002 Error Message
ORA-28002: the password will expire within days ORA-28002 means that the password of the user will expire soon in X days, although the user is… Read More »How to Resolve ORA-28002 Error Message
How to Resolve ORA-01017 Error Message
ORA-01017: invalid username/password; logon denied ORA-01017 means that you either provided an incorrect pair of username and password, or mismatched authentication protocol, so the database… Read More »How to Resolve ORA-01017 Error Message
How to Check Oracle Client Version 32-bit or 64-bit
32-bit or 64-bit In some situations, we need to know whether our Oracle client is 32-bit or 64-bit in order to use the right tool… Read More »How to Check Oracle Client Version 32-bit or 64-bit
How to Resolve "Connected to an idle instance"
Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you entered… Read More »How to Resolve "Connected to an idle instance"
How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154 ORA-12154 means that your connection tools including sqlplus cannot use TNSNAMES naming method for some reason. This reminds me that there're same error patterns… Read More »How to Resolve ORA-12154: TNS:could not resolve the connect identifier specified