The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Course Of The Month
6 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
oratab
Posted on 2012-12-29
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]$
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
2- +3
14 Comments
[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.
Active today
Please run and reply with:
ps -ef |grep pmon
find / -name "oratab" -print
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.
ps -ef |grep pmon
find / -name "oratab" -print
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.
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
Active today
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?
Active 1 day ago
Did you ever have an oratab file on this server? Did to ever have a working Oracle database on this server?
>>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.
Active today
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?
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..
Active today
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.
Featured Post
WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
The purpose of this article is to fix the unknown display problem in Linux Mint operating system. After installing the OS if you see Display monitor is not recognized then we can install "MESA" utilities to fix this problem or we can install additio…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month6 days, 23 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.