Oracle User when installing Oracle DB Server on Ubuntu [message #614639] |
Sat, 24 May 2014 16:55 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
Hi at all,
I'm newbie with oracle Database and I'm attempting to install oracle XE 11g R2 on linux Ubuntu 13.10.
Seeing several tutorials on the internet I have seen that between the steps for installing oracle XE 11g R2 there is always the following:
-) We need to add oracle user and oinstall, dba, nobody group.
Please, can anyone explain me precisely why do we need to add oracle user?
I already have a user (my_user) on ubuntu. Why cannot I install oracle XE in the User my_user?
thanks in advance.
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #614645 is a reply to message #614641] |
Sun, 25 May 2014 02:42 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
Hi BlackSwan, thanks for the response.
-) Because this is how Oracle is coded & documented.
Indeed, Oracle create oracle user per default when installing oracle XE.
I do not well know linux system but i think that Oracle create an oracle user during installation mainly for a permission reason. Is that right?
In this way oracle user is Owner and ONLY it can do all operation on Database having all permission. Is that right?
Finally, which is the linux operating system distro for which Oracle XE 11g R2 is certified? Peeking into forum it seems that Oracle is certified for the red hat and suse distro. Is that right?
Where can I find official documentation for install Oracle 11g r2 XE on linux?
thanks.
[Updated on: Sun, 25 May 2014 03:32] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #616902 is a reply to message #616895] |
Sun, 22 June 2014 10:30 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
As far as I understood, googling on internet, s390 refers to IBM mainframe which have a particular architecture identified by 31-bit-address/32-bit-data. Moreover, machines supporting that architecture have been sold under the brand System/390 (S/390).
Then, subsequently, IBM renamed S390 in System z.
So, from what i have said above, Linux system on System z is a 32 bit distro developed suitably for that hardware architecture.
So, s390x is the 64 bit distro of linux for System z.
It's right?
[Updated on: Sun, 22 June 2014 10:35] Report message to a moderator
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #616945 is a reply to message #616941] |
Mon, 23 June 2014 09:47 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
OMG! Where did you find Yugo?!?
25 years ago I lived in a country whose name was Yugoslavia (so, guess how that car got its name). Yugo was produced in "Zastava", a Serbian factory located in Kragujevac. That factory produced weapons as well, such as Kalashnikov. It was bombed by NATO during the late 90s because of Serbian involvement into Kosovo happenings.
I remember first Yugos ... it was a small car, reminded me of WV Golf (look, what a strange looking Golf!). The best series was Yugo America, exported into the USA. Ordinary people over here couldn't even buy it. The car also took its role in Die Hard with Bruce Willis. History says that it was the ugliest, the worst, etc. car ever (I don't agree with that, though).
|
|
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617399 is a reply to message #617217] |
Sun, 29 June 2014 04:40 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
Hi,
from chapter 2 of documentation - section Creating an Oracle Base Directory:
Before you create an Oracle base directory, you must identify an appropriate file system with sufficient free disk space.
To identify an appropriate file system:
- To determine the free disk space on each mounted file system, use the following command: # df -h
- From the display, identify a file system that has the appropriate amount of free space
- Note the name of the mount point directory for the file system that you identified.
To create the Oracle base directory and specify the correct owner, group, and permissions for it:
- Enter commands similar to the following to create the recommended subdirectories in the mount point directory that you identified and set the appropriate owner, group, and permissions on them:
# mkdir -p /mount_point/app/oracle_sw_owner
# chown -R oracle:oinstall /mount_point/app/oracle_sw_owner
# chmod -R 775 /mount_point/app/oracle_sw_owner
For example:
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
Following the above steps I get:
- To determine the free disk space on each mounted file system, use the following command: # df -h
[oracle@vmoraclelinux ~]$ df -h
Filesystem Size Used Use% Mounted on
/dev/sda3 36G 3.6G 11% /
tmpfs 935M 304K 1% /dev/shm
/dev/sda1 291M 39M 14% /boot
[oracle@vmoraclelinux ~]$
- From the display, identify a file system that has the appropriate amount of free space
- from the above point (1.) it look like that the file system that has the appropriate amount of free space is the follow:
Filesystem Size Used Use% Mounted on
/dev/sda3 36G 3.6G 11% /
- Note the name of the mount point directory for the file system that you identified.
- from the point 2. the mount point directory is the root directory (/)
So, now, to create the Oracle base directory and specify the correct owner, group, and permissions for it:
- Enter commands similar to the following to create the recommended subdirectories in the mount point directory that you identified and set the appropriate owner, group, and permissions on them:
# mkdir -p /mount_point/app/oracle_sw_owner
For example:
# mkdir -p /u01/app/oracle
Now, from the point (2. and 3.) file system that has the appropriate amount of free space is /dev/sda3 and the mount point directory is / ... NOT u01 directory.
So, in my case, what's /mount_point/app/oracle_sw_owner?? .... Is it [i]/app/oracle[i]?? (considering that the mount point directory is /)
Thanks.
[Updated on: Sun, 29 June 2014 04:51] Report message to a moderator
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617402 is a reply to message #617401] |
Sun, 29 June 2014 05:16 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
John Watson wrote on Sun, 29 June 2014 05:07Just follow the advice:
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
For the documentation the directory u01 is the mount point directory. In my linux system I have not u01 as mount point directory ..... my mount point directory is root (/).
According to me, as far as I understood, Oracle wants that we create a partition on disk, which mount point directory is u01, for install oracle software correctly.
Is it right?
[Updated on: Sun, 29 June 2014 05:24] Report message to a moderator
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617407 is a reply to message #617402] |
Sun, 29 June 2014 06:51 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
dancko wrote on Sun, 29 June 2014 05:16
According to me, as far as I understood, Oracle wants that we create a partition on disk, which mount point directory is u01, for install oracle software correctly.
Is it right?
You already have a partition. It is mounted to / (the root directory). In a more sophisticated system you might want to create a partition dedictated to oracle, but you do not need to do that and doing so is an un-necessary complication for your needs. Just create the directories as per the example and as per re-inforced by John.
Since you seem to be doing the specifically to learn how to manage oracle on linux, you really, really, really need to take some time learning some fundamentals of linux. In this case, you need to learn about mount points, directory names, and mounting a directory.
And you need to be doing it on a version of Linux that is specifically supported by Oracle .. not one that you think should be supported by Oracle just because it is similar to one that is.
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617409 is a reply to message #617407] |
Sun, 29 June 2014 08:38 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
EdStevens wrote on Sun, 29 June 2014 06:51
You already have a partition. It is mounted to / (the root directory). In a more sophisticated system you might want to create a partition dedictated to oracle, but you do not need to do that and doing so is an un-necessary complication for your needs. Just create the directories as per the example and as per re-inforced by John.
Since you seem to be doing the specifically to learn how to manage oracle on linux, you really, really, really need to take some time learning some fundamentals of linux. In this case, you need to learn about mount points, directory names, and mounting a directory.
And you need to be doing it on a version of Linux that is specifically supported by Oracle .. not one that you think should be supported by Oracle just because it is similar to one that is.
Okay okay. I agree with you.
Just for clarity: I'm trying to install Oracle DB on linux system, in particular, finally, I chose to do that on CentOS 6.5 distro, which it look like to be the closest to RedHat distro. My goal is to learn how to manage oracle on linux.
In the meanwhile I have already learned some fundamentals on linux and for this reason it come back to me the doubt if it were necessary to create a dedicate partition (filesystem) for oracle software which mount point directory were u01 directory.
In any case, I also think that, for my goal, I do not need to do that... doing so is an un-necessary complication for my needs.
So, I just create the directories as per the example in the documentation.
However, thanks for your support!!
[Updated on: Sun, 29 June 2014 08:54] Report message to a moderator
|
|
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617568 is a reply to message #617566] |
Tue, 01 July 2014 15:02 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
In section 2.11.1.1 "Understanding Restrictions for Oracle Installations with Job Role Separation" (this is the link: http://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#LADBI1163), although it recommends that you create one software owner to own each Oracle software installation, at a certain point tells about:
To create separate Oracle software owners, to create separate users, and separate operating system privileges groups for different Oracle software installations, each of these users must have the Oracle central inventory group (oraInventory group) as their primary group. Members of this group have write privileges to the Oracle central inventory (oraInventory) directory, and and are also granted permissions for various Oracle Restart resources and directories in the Oracle Restart home to which DBAs need write access, and other necessary privileges. In Oracle documentation, this group is represented as oinstall in code examples. See "Creating the Oracle Inventory Group".
[Updated on: Tue, 01 July 2014 15:06] Report message to a moderator
|
|
|
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617690 is a reply to message #617684] |
Wed, 02 July 2014 12:41 |
|
dancko
Messages: 108 Registered: June 2013 Location: italy
|
Senior Member |
|
|
Yes, you have been very very helpful.
Thanks you at all!
P.S.: With the packages problem Oracle Universal Installer (OUI) has not recognized that on the system was installed the latest version of the same packages. Simply by checking "Ignore All" the installation was completed successfully.
How to start and stop manually the oracle db services? E.g. OracleServiceSYSDBA and all other?
[Updated on: Wed, 02 July 2014 12:47] Report message to a moderator
|
|
|
|
Re: Oracle User when installing Oracle DB Server on Ubuntu [message #617698 is a reply to message #617697] |
Wed, 02 July 2014 13:36 |
John Watson
Messages: 8962 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This is difficult. There are many cases where the packages really are not needed. All they are is a list in one of those prereq.xml files. I suspect that some guy at Redwood Shores does an install, it works, so he documents what he has as "required". But even though you and I might know that a package is not required, you can't ignore it on a client site. Because if you rise a TAR later on and get an awkward support analyst, he may just say "come back when you meet the prereqs" and put the 'phone down. That's what I always said.
I had a problem a while back with a RAC install on AIX that was demanding a fileset we couldn't find anywhere. Turned out that it was part of HACMP, which we weren't using and therefore didn't need. But until you get the OK from Oracle Support, you can't proceed.
|
|
|
|
|
|