I am not sure what exactly you tried to do, but generally speaking I can advise you to set the NLS_DATE_FORMAT variable before starting your program (like Excel). For example, in Windows, you can open a terminal window and type SET NLS_DATE_FORMAT='DD/MM/YYYY' and then run the program from the same terminal window. You can also set this variable in the regedit under Oraclehome node.

It is Camtasia.

You can use the V$SQLAREA and V$TRANSACTION dynamic performance views: SELECT sql.sql_text, SUM(txn.xidusn) redo_size FROM v$sqlarea sql, v$transaction txn WHERE sql.address = txn.sqladdr GROUP BY sql.sql_text ORDER BY SUM(txn.xidusn) DESC; You can also use the LogMiner utility to analyze the redo logs and identify the SQL statements that generated the most redo archive log.

@@AhmedBarakaDBA Great. Thanks

@@AhmedBarakaDBA This query did not work for , can you please check this again. Thanks

Yes. Actually, they do use the same DB name.

I am working on a course for beginners. Cheers!

yes you can schedule rman backup script with crontab.

You will find plenty of videos and courses on SQL fundamentals. Good luck!

Use tnsping to make sure the tnsnames.ora name that you use to connect to the database is working.

@@AhmedBarakaDBA No, it is not working on the client side

@@enriquebarbosa9580 then most likely you have a network issue. Try pinging the host name, if the ping fails, it is definitely a network issue.

@@AhmedBarakaDBA Thank you for you reply, but I can ping the dbserver from client and visesersa. I am using RedHat 8.6 Enterprice nd Oracle 18c XEas the db with oracle instantclient 18.6, are dose compatible?

whenever you face the error "[Errno 14] problem making ssl connection", it means you are using Linux 6 and unfortunately Oracle currently restricts Linux 6 from accessing its Yum repositories. To cope with this issue, download the required rpm manually from the following link then install it: yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/getPackage/ The best thing to do to avoid this error in the future is to use Linux 7 instead.

@@AhmedBarakaDBA ​Hello. I have purchased your class through udemy, and i have been stuck for days on this very problem. how do i install those packages? and which one should i download? i decided to go one by one but each time i download one it asks for another one and eventually i am stuck because it's asking for some dracut-kernel: here is the error message: error: Failed dependencies: dracut-kernel >= 004-408.el6 is needed by kernel-2.6.32-754.el6.x86_64 i can' t find this dracut-kernel 004-408.el6 anywhere in that repository. should i just destroy this linux 6 and install linux 7 ? which linux 7 won't give me this crazy problem? like i said i have been working on this for many days now, and i feel discouraged.

@@mr.opportunity7813 I am sorry you face those issues but actually I am not surprised. Oracle stopped accepting connections from Linux 6 to its Yummy repositories. So, yes you got it right. Better to go for Linux 7. I already have a video about it in my KZbin channel. On the courses side, it is in my top priority to update the course material on Linux 7 on all the courses.

It means oracle user isn't there. Create oracle user using the following commands as root: /usr/sbin/groupadd dba /usr/sbin/groupadd -g 54321 oinstall /usr/sbin/useradd -u 54321 -g oinstall -G dba oracle passwd oracle

@@AhmedBarakaDBA Thank you. Also on the step where I need to unzip the file. Its says the file can not be found. I know i copied it to the shared folder.

Create oracle user using the following commands as root: /usr/sbin/groupadd dba /usr/sbin/groupadd -g 54321 oinstall /usr/sbin/useradd -u 54321 -g oinstall -G dba oracle passwd oracle

It must be a privilege issue. Is oracle database software owner added to the group asmdba?

@@AhmedBarakaDBA Dear Ahmed , thanks very much . SPot on , Just added oracle user to asmdba group and installation is successful . Thank you very much for your response . Appreciated .