Thanks for the update and additional information. The last comment in my previous post described the method for running the v2p as, for example, the oracle user which would mean the file ownership was as desired to begin with. Was an error seen in the alert log for example when attempting to start the database as user oracle leading to the comment that other users cannot identify the control file? I would still recommend checking the filesystem mount options and for any extended attributes that may be preventing other users accessing the file as the standard permissions would suggest were possible. What type of filesystem was the data written to?
Original Message:
Sent: 11-29-2023 08:27:51 AM
From: Johnley Li
Subject: Permission error during Oracle Virtual to Physical
Thank you Stuart for the quick response.
Actually attempting to change the ownership of the file is just the workaround for the original issue. The original issue is most files of the Physical DB provisioned through V2P is owned by our delphix user ( delphix_os ), with 'r' granted to ALL, so 'oracle' user should be able to read control files to restart the DB; The problem is even those files with 'r' to ALL, still no other users include 'oracle' cannot identify the control file. The DB has to be operated by 'delphix_os' which is not what we want. The same scenario works fine on other target host. See output below from the other target host; We easily shutdown the DB through 'delphix_os', make a redundant copy of the control file; restart the DB throuhg 'oracle' account.
--(/data/DEVSOP67/Base/data/DLPHX01/Base)-$ ps -ef | grep smon | grep DEVSOP67
oracle 47242 1 0 Sep21 ? 00:30:10 ora_smon_DEVSOP67
--(oracle@gbl25051780)-()-()-()-(OTK v)-(29-Nov-2023 15:24:08)--
--(/data/DEVSOP67/Base/data/DLPHX01/Base)-$ ls -l | more
total 3510267136
-rw-rw-r--. 1 delphix_os oradba 1468014592 Nov 29 15:23 DERIVES_SAUVEGARDES_01.dbf
-rw-rw-r--. 1 delphix_os oradba 1363156992 Nov 29 15:23 DERIVES_SAUVEGARDES_02.dbf
-rw-rw-r--. 1 delphix_os oradba 1363156992 Nov 29 15:23 DERIVES_SAUVEGARDES_03.dbf
-rw-rw-r--. 1 delphix_os oradba 1363156992 Nov 29 15:23 DERIVES_SAUVEGARDES.dbf
-rw-rw-r--. 1 delphix_os oradba 104865792 Nov 29 15:23 DERIVES_TEMPLATE_1.dbf
-rw-rw-r--. 1 delphix_os oradba 104865792 Nov 29 15:23 DERIVES_TEMPLATE_2.dbf
-rw-rw-r--. 1 delphix_os oradba 209723392 Nov 29 15:23 FIDESSA.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_10.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_11.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_12.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_13.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_14.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_15.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:22 INDEXES_16.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:23 INDEXES_17.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:23 INDEXES_18.dbf
-rw-rw-r--. 1 delphix_os oradba 12884910080 Nov 29 15:23 INDEXES_19.dbf
--(oracle@gbl25051780)-()-()-()-(OTK v)-(29-Nov-2023 15:24:31)--
--(/data/DEVSOP67/Base/data/DLPHX01/Control)-$ ls -l
total 40608
-rw-rw-r--. 1 delphix_os oradba 20791296 Nov 29 15:24 ora_control1.con
-rw-r--r--. 1 oracle oinstall 20791296 Nov 29 15:24 ora_control2.con
------------------------------
Johnley Li
Intern
HSBC Canada
Original Message:
Sent: 11-29-2023 05:22:08 AM
From: Stuart Williams
Subject: Permission error during Oracle Virtual to Physical
Hello Johnley
Yes, as you found execute permissions are needed to list directories. I would check the type of filesystem, the mount options on the filesystem and look for any extended attributes on the file also ensure the Oracle instance is shutdown while these changes are made. Did you attempt to change the permissions recursively from the base? I would recommend that. While your shell is in the directory use 'df .' to identify the filesystem mount point and then 'mount' maybe piped to grep for the mount point name to see the options 'mount | grep Delphix', there may be something there to help understand the restriction. Any extended attributes (if enabled) should be visible via lsattr or getfattr.
You can also specify the desired owner when using v2p by adding them as an environment user and selecting that one when performing the operation.
Regards
Stuart
------------------------------
Stuart Williams
Principal Solution Engineer
Delphix Community Members
Original Message:
Sent: 11-28-2023 09:46:43 AM
From: Johnley Li
Subject: Permission error during Oracle Virtual to Physical
I just figured out there was trick, I have to give 'x' as well, then I can view the folders and its subfolders and files from 'root' user. However, the key issue is still there, I cannot change the owner to 'oracle:oinstall' through root account, even the file privilege is '7777'. Any recommendation/solutions are greatly appreciated!
[root@gbl20178293 Control]# whoami
root
[root@gbl20178293 Control]# cd /Delphix/INTUKSOPHIS01/2023-01-31-US/Base/data/data/DLPHX01/Control
[root@gbl20178293 Control]# ls -l ora_control1.con
-rwxrwxrwx. 1 delphix_os oradba 20791296 Nov 28 15:38 ora_control1.con
[root@gbl20178293 Control]# chown oracle:oinstall ora_control1.con
chown: changing ownership of 'ora_control1.con': Operation not permitted
[root@gbl20178293 Control]#
Thank you
Johnley
------------------------------
Johnley Li
Intern
HSBC Canada
Original Message:
Sent: 11-28-2023 09:34:57 AM
From: Johnley Li
Subject: Permission error during Oracle Virtual to Physical
I finished my V2P through the Delphix Console, DB is running well under 'delphix_os'. However, when I tried to switch it to 'oracle', I found all the major directory 'data' generated by Delphix is owned by 'delphix_os' and has proper privileges given 'r' to all, but it still can only be viewed by 'delphix_os', even 'root' cannot view it. Hence, I couldn't change their owner to 'oracle'. Any idea or solution?
Thank you very much!
Johnley
[root@gbl20178293 data]# whoami
root
[root@gbl20178293 data]# ls -l
total 16
drwxrwxr--. 3 delphix_os oradba 3 Nov 27 18:04 data
-rw-rw-r--. 1 delphix_os oradba 0 Nov 27 18:04 includedParameters.ora
-rw-rw-r--. 1 delphix_os oradba 1924 Nov 27 20:50 init.ora
-rw-rw-r--. 1 delphix_os oradba 2083 Nov 27 18:24 init.ora.createControlfile
-rw-rw-r--. 1 delphix_os oradba 2182 Nov 27 18:24 init.ora.recovery
-rw-rw-r--. 1 delphix_os oradba 2183 Nov 27 21:19 init.ora.rename
-rw-rw-r--. 1 delphix_os oradba 2373 Nov 27 18:44 source_init.ora
-rw-r-----. 1 oracle oinstall 5632 Nov 27 23:12 spfile.ora
drwxr-x---. 3 oracle oinstall 3 Nov 27 23:01 US23JAN
[root@gbl20178293 data]# cd data
-bash: cd: data: Permission denied
[root@gbl20178293 data]# chown oracle:oinstall data
chown: changing ownership of 'data': Operation not permitted
------------------------------
Johnley Li
Intern
HSBC Canada
Original Message:
Sent: 03-11-2015 02:02:00 PM
From: Adam Bowen
Subject: Permission error during Oracle Virtual to Physical
Thanks for your kind words, and you English was fine. We strive to answer every question as quickly and efficiently as possible. This is the same level of service we aim to give all of our customers in the event they need to file a support ticket. Our support organization is the best. My customers love them!