Oracle · oracle · Uncategorized

Oracle Sql

USING SQL PLUS or Any Oracle Tool Like “SQL Developer or TOAD” ============================================================== create user supplier2 identified by supplier2 grant connect,resource,dba to supplier2 unlock ====== alter user joe account unlock; alter user awb account unlock identified by awb; change password =============== alter user awb identified by awb; To use import tool go to the following… Continue reading Oracle Sql

oracle

How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?

sometimes ┬áthe oracle profile is not prepared correctly and this give so many errors and you should go direct to directory of SqlPlus to start DB /u01/app/oracle/product/11.2.0/dbhome_1/bin ./sqlplus sys/password as sysdba; the following error will arises ORA-12162 TNS:net service name is incorrectly specified Cause This arises if you have not set ORACLE_HOME and ORACLE_SID. Solution… Continue reading How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?