Oracle DBA Support

Search This Blog

User not able to identify TNS identifier - Oracle Database

October 14, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

User not able to identify TNS identifier - Oracle Database

change permission of admin folder

chmod -r 755 Oracle_Home/network/admin

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Kill user session in Oracle Database

Kill user session in Oracle Database select 'alter system kill session '''||sid||','||serial#|| ''' immediate;' from v$session where osuser='&username';

How to use log miner in Oracle Database

How to use log miner in Oracle Database SELECT * FROM V$ARCHIVED_LOG WHERE FIRST_CHANGE# <= 12435785206731 AND NEXT_CHANGE# >= 12435785206731; EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - LOGFILENAME => 'arch file', - OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.START_LOGMNR( - OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID, SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS where XIDUSN=49 and XIDSLT=25 and XIDSQN=22415431; EXECUTE DBMS_LOGMNR.END_LOGMNR();

How to get Oracle database directories details

Get Oracle Database directories details SQL> desc dba_directories; Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER NOT NULL VARCHAR2(128) DIRECTORY_NAME NOT NULL VARCHAR2(128) DIRECTORY_PATH VARCHAR2(4000) ORIGIN_CON_ID NUMBER set linesize 190 col owner for a30 col ...

Powered by Blogger

User not able to identify TNS identifier - Oracle Database

User not able to identify TNS identifier - Oracle Database

Comments

Post a Comment