search

oraclebase / vagrant

Vagrant Builds
https://oracle-base.com/
GNU General Public License v3.0
194 stars 170 forks source link

Update oracle_create_database.sh #6

Closed A7rMtWE57x closed 4 years ago

A7rMtWE57x commented 4 years ago

corrected fast_recovery_area to flash_recovery_area

oraclebase commented 4 years ago

I'm curious why you think this is a problem. In Oracle 11.2 the Flash Recovery Area was rebranded to the Fast Recovery Area, so technically the fast_recovery_area directory is more correct than using flash_recovery_area. In addition the build work, so I'm not sure why you are suggesting making the change.

Are you seeing a problem with the build, or are you just changing the name because you prefer the old name?

oraclebase commented 4 years ago

FYI. I actually made the change you suggested and it breaks the build. It produces errors as the second node is expecting to have the fast_recovery_area directory present.

I'm going to deny the pull request unless you can explain why you think it is necessary...

A7rMtWE57x commented 4 years ago

Hi Tim

I downloaded these files (linux.x64_11gR2_database_1of2.zip and linux.x64_11gR2_database_2of2.zip) from Oracle download page and then I had to change the install.env from this: export DB_SOFTWARE="p13390677_112040_Linux-x86-64_*of7.zip" to this: export DB_SOFTWARE="linux.x64_11gR2_database_*of2.zip"

after vagrant up the first node I have:

[oracle@ol7-112-dg1 ~]$ cd /u01/app/oracle/
[oracle@ol7-112-dg1 oracle]$ ls -al
total 4
drwxr-xr-x. 9 oracle oinstall 4096 Apr 26 12:32 .
drwxr-xr-x. 4 oracle oinstall   40 Apr 26 12:28 ..
drwxr-x---. 3 oracle oinstall   19 Apr 26 12:29 admin
drwxr-x---. 3 oracle oinstall   18 Apr 26 12:29 cfgtoollogs
drwxr-xr-x. 2 oracle oinstall    6 Apr 26 12:31 checkpoints
drwxr-x---. 4 oracle oinstall   41 Apr 26 12:32 DB11G
drwxrwxr-x. 4 oracle oinstall   34 Apr 26 12:29 diag
drwxr-x---. 4 oracle oinstall   32 Apr 26 12:30 flash_recovery_area  <--------
drwxr-xr-x. 3 oracle oinstall   22 Apr 26 12:28 product
[oracle@ol7-112-dg1 oracle]$

and while starting node 2 I get:

RMAN-00571: ===========================================================
    default: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    default: RMAN-00571: ===========================================================
    default: RMAN-03002: failure of Duplicate Db command at 04/26/2020 13:08:00
    default: RMAN-03015: error occurred in stored script Memory Script
    default: ORA-19504: failed to create file "/u01/app/oracle/flash_recovery_area/db11g/control02.ctl"
    default: ORA-27040: file create error, unable to create file
    default: Linux-x86_64 Error: 2: No such file or directory
    default: ORA-19600: input file is control file  (/u01/oradata/db11g/control01.ctl)
    default: ORA-19601: output file is control file  (/u01/app/oracle/flash_recovery_area/db11g/control02.ctl)
oraclebase commented 4 years ago

OK. It looks that the 11.2.0.1 release used the old directory name and some patch between there and the 11.2.0.4 released fixed the bug.

I'm going to reject this pull request, but include the following in install.env file.

11.2.0.1 : Use the following two parameters.

export DB_SOFTWARE="linux.x64_11gR2database*of2.zip"

export FRS_DIR="flash_recovery_area"

11.2.0.4 : Use the following two parameters.

export DB_SOFTWARE="p13390677_112040Linux-x86-64*of7.zip" export FRS_DIR="fast_recovery_area"

And this in the node 2 oracle_create_database.sh file.

mkdir -p ${ORACLE_BASE}/${FRS_DIR}/${ORACLE_SID}

That way people can switch depending on the release they've got. I'll give you a shout out in the commit history for bringing it to my attention.

Cheers

Tim...