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.BeforeVMware
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.BeforeVMware
modprobe.d
[oracle@new etc]$
[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.BeforeVMware
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.BeforeVMware
modprobe.d
[oracle@new etc]$
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..
[oracle@new var]$ cd /opt
[oracle@new opt]$ ls
[oracle@new opt]$ pwd
/opt
[oracle@new opt]$ ls
[oracle@new opt]$
no..
Hi,
oratab is not mandatory.
It is used only by some tools (such as dbstart/dbshut).
Its default location is platform dependent.
Regards,
Franck.
oratab is not mandatory.
It is used only by some tools (such as dbstart/dbshut).
Its default location is platform dependent.
Regards,
Franck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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?
Secondly, there must be a space between / and -name.
I presume someone has installed an Oracle RDBMS on this box?
Did you ever have an oratab file on this server? Did to ever have a working Oracle database on this server?
Oops! I meant: "Did you ever...?"
>>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.
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.
Good point, I had overlooked that: ty.
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?
When you installed the software id you have a root user run root.sh?
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..
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..
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.
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.
ASKER
found out
/var/opt/oracle