Hi guys, I need some help from you.
I know it's lame to ask for help for college, but for oracle databases we have a professor that really doesn't know how to explain anything.
We are learning it all theoretically and nothing practically and now he gave us a code to annotate. I would be very grateful if you could help me with explaining this code with the parts that I don't understand.
I won't be lazy and just copy paste afterwards, I'm really interested in this, and I'm asking for your help,

Thank you very much.
Here are some thing that I don't get and need help with, so if you could explain it for me:

Case 1:

OLD_UMASK=`umask`
umask 0027

Case 2:

mkdir -p /u01/app/oracle/admin/jobs/adump

Case 3:

umask ${OLD_UMASK}

Case 4:

/u01/app/oracle/product/11.2.0/db_1/bin/sqlplus /nolog @/u03/labfiles/lab1/JOBS.sql

Case 5:

set verify off
  ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE
  ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE

Case 6:

host /u01/app/oracle/product/11.2.0/db_1/bin/orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwJOBS force=y

Case 7:

pfile="/u01/app/oracle/admin/jobs/create/init.ora";

Once again, Thank you very much in advance,

Best regards,

Toni

Recommended Answers

All 2 Replies

None of those are generic Oracle syntax.

Those are either OS or environment setting commands.

If you are not understanding anything it is you, not the professor to blame.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.