Avatar of walkerdba
walkerdba
 asked on

oratab

why /etc/oratab   is not found



[oracle@new ~]$ cd /etc
[oracle@new etc]$ ls
acpi                                    motd
adjtime                                 mtab
alchemist                               mtools.conf
aliases                                 multipath.conf
aliases.db                              Muttrc
alsa                                    Muttrc.local
alternatives                            netplug
anacrontab                              netplug.d
asound.state                            NetworkManager
at.deny                                 nscd.conf
audit                                   nsswitch.conf
autofs_ldap_auth.conf                   ntp
auto.master                             ntp.conf
auto.misc                               odbc.ini
auto.net                                odbcinst.ini
auto.smb                                openldap
avahi                                   opt
bashrc                                  pam.d
blkid                                   pam_pkcs11
bluetooth                               pam_smb.conf
bonobo-activation                       pango
capi.conf                               passwd
cdrecord.conf                           passwd-
conman.conf                             pcmcia
cron.d                                  pinforc
cron.daily                              pki
cron.deny                               pm
cron.hourly                             ppp
cron.monthly                            prelink.cache
crontab                                 prelink.conf
cron.weekly                             printcap
csh.cshrc                               profile
csh.login                               profile.d
cups                                    protocols
dbus-1                                  quotagrpadmins
default                                 quotatab
depmod.d                                racoon
desktop-profiles                        rc
dev.d                                   rc0.d
DIR_COLORS                              rc1.d
DIR_COLORS.xterm                        rc2.d
dumpdates                               rc3.d
environment                             rc4.d
esd.conf                                rc5.d
exports                                 rc6.d
fb.modes                                rc.d
filesystems                             rc.local
firmware                                rc.sysinit
fonts                                   readahead.d
foomatic                                reader.conf
fstab                                   reader.conf.d
gconf                                   redhat-lsb
gdm                                     redhat-release
ghostscript                             resolv.conf
gnome-vfs-2.0                           rhgb
gnome-vfs-mime-magic                    rmt
gpm-root.conf                           rpc
gre.d                                   rpm
group                                   rwtab
group-                                  rwtab.d
grub.conf                               samba
gshadow                                 sasl2
gshadow-                                screenrc
gssapi_mech.conf                        scrollkeeper.conf
gtk-2.0                                 scsi_id.config
hal                                     securetty
host.conf                               security
hosts                                   selinux
hosts.allow                             services
hosts.deny                              sestatus.conf
httpd                                   setroubleshoot
idmapd.conf                             setuptool.d
init.d                                  sgml
initlog.conf                            shadow
inittab                                 shadow-
inputrc                                 shells
iproute2                                skel
isdn                                    slrn.rc
issue                                   smartd.conf
issue.net                               smrsh
java                                    sound
jvm                                     ssh
jvm-commmon                             stunnel
jwhois.conf                             sudoers
kdump.conf                              sysconfig
krb5.conf                               sysctl.conf
ldap.conf                               syslog.conf
ld.so.cache                             termcap
ld.so.conf                              tpvmlp.conf
ld.so.conf.d                            udev
lftp.conf                               updatedb.conf
libaudit.conf                           updatedb.conf.BeforeVMwareToolsInstall
libuser.conf                            vimrc
localtime                               virc
login.defs                              vmware-tools
logrotate.conf                          warnquota.conf
logrotate.d                             wgetrc
logwatch                                wpa_supplicant
lsb-release.d                           wvdial.conf
lvm                                     X11
mail                                    xdg
mailcap                                 xinetd.conf
mail.rc                                 xinetd.d
makedev.d                               xml
man.config                              yp.conf
maven                                   yum
mgetty+sendfax                          yum.conf
mime.types                              yum.repos.d
minicom.users                           zlogin
mke2fs.conf                             zlogout
modprobe.conf                           zprofile
modprobe.conf~                          zshenv
modprobe.conf.BeforeVMwareToolsInstall  zshrc
modprobe.d
[oracle@new etc]$
Linux DistributionsOracle Database

Avatar of undefined
Last Comment
walkerdba

8/22/2022 - Mon
Peter Kwan

Please see if oratab is located at:

/var/opt/oracle
walkerdba

ASKER
[oracle@new etc]$ cd /var
[oracle@new var]$ cd /opt
[oracle@new opt]$ ls
[oracle@new opt]$ pwd
/opt
[oracle@new opt]$ ls
[oracle@new opt]$


no..
Franck Pachot

Hi,
oratab is not mandatory.
It is used only by some tools (such as dbstart/dbshut).
Its default location is platform dependent.
Regards,
Franck.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
David VanZandt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
walkerdba

ASKER
Here is the output

I don't Know I typed in a right way...Please check the space..

[oracle@new etc]$ ps -ef |grep pmon
oracle    4497  4340  0 14:28 pts/1    00:00:00 grep pmon
[oracle@new etc]$ find /-name "oratab" -print
find: /-name: No such file or directory
find: oratab: No such file or directory
[oracle@new etc]$ find /-name "oratab"-print
find: /-name: No such file or directory
find: oratab-print: No such file or directory
[oracle@new etc]$ find /-name"oratab"-print
find: /-nameoratab-print: No such file or directory
[oracle@new etc]$ find /-name"oratab"-print
David VanZandt

The first command checked for existance of the pmon process -- found none, meaning no database is open on that box.

Secondly, there must be a space between / and -name.

I presume someone has installed an Oracle RDBMS on this box?
Mark Geerlings

Did you ever have an oratab file on this server?  Did to ever have a working Oracle database on this server?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Mark Geerlings

Oops!  I meant: "Did you ever...?"
Franck Pachot

>>A side comment to Frank in 38729206, if starting or stopping an Oracle instance can be done without (mandatory) oratab, please toss me a reference.
Just startup or shutdown under sqlplus. oratab is just a convenient way to list the instances with their ORACLE_HOME and ORACLE_SID. But you may have a system working well without any oratab. That was my point.
David VanZandt

Good point, I had overlooked that: ty.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
slightwv (䄆 Netminder)

I agree that it is optional but it is nice to have for things like oraenv (and the previously mentioned dbstart and dbshut).

When you installed the software id you have a root user run root.sh?
walkerdba

ASKER
Slightvv I found it that is why...

Sorry I did not run both of that script at the end..
Is there any way to run that script again where is the location..
slightwv (䄆 Netminder)

It should be in ORACLE_HOME.

Check out the following link:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r1/prod/install/dbinst/dbinst.htm

10.       You need to execute orainstRoot.sh and root.sh as the root user.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
walkerdba

ASKER
found out