Oracle Change User Password
Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »Oracle Change User Password
sqlplus
TNSNAMES, How and Why
Local Naming = TNSNAMES Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn username/password@chicago-db-server:1521/ORCL Connected. Or… Read More »TNSNAMES, How and Why
How DBMS_SERVICE.CREATE_SERVICE
How to Use DBMS_SERVICE to Create a New Service? The default service name of a database is the DB_UNIQUE_NAME, if we'd like to add some… Read More »How DBMS_SERVICE.CREATE_SERVICE
How to Add Service 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 Service to PDB
Database States Differentiations in Oracle
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 »Database States Differentiations in Oracle
How to Find Oracle 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 to Find Oracle 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 in a cluster, so the original… Read More »How Oracle RAC VIP Failover to Another Node
Connect to PDB as SYSDBA by ORACLE_PDB_SID
Connect as SYSDBA We usually connect to the database by / as SYSDBA without providing any password for maintenance works, such as startup, shutdown and… Read More »Connect to PDB as SYSDBA by ORACLE_PDB_SID
How to Resolve ORA-28002: the password will expire within 7 days
ORA-28002 ORA-28002 means that the password of the user will expire soon in N days, although the user is allowable to connect to the database.… Read More »How to Resolve ORA-28002: the password will expire within 7 days
How to Resolve ORA-01017: invalid username/password; logon denied
ORA-01017 ORA-01017 means that you either provided an incorrect pair of username and password, or mismatched authentication protocol, so the database that you tried to… Read More »How to Resolve ORA-01017: invalid username/password; logon denied