Category Archives: Oracle

How to Export Oracle Schema

just use this commend exp ODS/welcomw FIlE=/u01/software/ODS.dmp OWNER=ODS statistics=none log=/u01/software/logODS.log where ODS is schema name Advertisements

Posted in Oracle | Tagged , , | Leave a comment

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 … Continue reading

Posted in Oracle, oracle, Uncategorized | Tagged , , | Leave a comment

ORA-12638: Credential retrieval failed

1) Go to /oracle home/network/admin and open sqlnet.ora 2) Search forĀ  SQLNET.AUTHENTICATION_SERVICES= (NTS) and change it to SQLNET.AUTHENTICATION_SERVICES= (NONE) 3) Save the file and try to connect via sqlplus /oracle home/bin/sqlplus sys/sys as sysdba sql>startup force;

Posted in Oracle | Tagged | Leave a comment

How to add sysdba user to oracle?

create user weblogic identified by pass; conn sys/sys as sysdba; grant sysdba to weblogic;  

Posted in Oracle