Home » Infrastructure » Unix » How to find out where oracle is installed?
How to find out where oracle is installed? [message #285863] Wed, 05 December 2007 23:18 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
Hi

I am logged into a remote linux machine, i want to find out where
the oracle software is installed..basically, i want to see the following
files...

oracle_home/rdbms/admin/sql.bsq
oracle_home/rdbms/admin/catalog.sql

i am taken to home directory...do i need to export something here?
how to know where oracle is installed?

Re: How to find out where oracle is installed? [message #285866 is a reply to message #285863] Wed, 05 December 2007 23:22 Go to previous messageGo to next message
BlackSwan
Messages: 22485
Registered: January 2009
Senior Member
find / -name sql.bsq -print
& be prepared to wait for your answer
Re: How to find out where oracle is installed? [message #285870 is a reply to message #285863] Wed, 05 December 2007 23:39 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On a database server, I think it better search for "oracle" binary. SQL files are not mandatory.

Regards
Michel
Re: How to find out where oracle is installed? [message #285872 is a reply to message #285863] Wed, 05 December 2007 23:42 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
[wasadmin@devlinuxvm5 wasadmin]$ find / -name sql.bsq
find: /lost+found: Permission denied
find: /boot/lost+found: Permission denied
find: /proc/tty/driver: Permission denied
find: /proc/1/fd: Permission denied
find: /proc/2/fd: Permission denied
find: /proc/3/fd: Permission denied
find: /proc/4/fd: Permission denied
find: /proc/5/fd: Permission denied
find: /proc/6/fd: Permission denied
find: /proc/9/fd: Permission denied
find: /proc/7/fd: Permission denied
find: /proc/8/fd: Permission denied
find: /proc/10/fd: Permission denied
find: /proc/11/fd: Permission denied
find: /proc/19/fd: Permission denied
find: /proc/440/fd: Permission denied
find: /proc/441/fd: Permission denied
find: /proc/442/fd: Permission denied
find: /proc/443/fd: Permission denied
find: /proc/792/fd: Permission denied
find: /proc/796/fd: Permission denied
find: /proc/807/fd: Permission denied
find: /proc/825/fd: Permission denied
find: /proc/845/fd: Permission denied
find: /proc/892/fd: Permission denied
find: /proc/920/fd: Permission denied
find: /proc/942/fd: Permission denied
find: /proc/1042/fd: Permission denied
find: /proc/1057/fd: Permission denied
find: /proc/1073/fd: Permission denied
find: /proc/1102/fd: Permission denied
find: /proc/1111/fd: Permission denied
find: /proc/1122/fd: Permission denied
find: /proc/1132/fd: Permission denied
find: /proc/1156/fd: Permission denied
find: /proc/1166/fd: Permission denied
find: /proc/1177/fd: Permission denied
find: /proc/1193/fd: Permission denied
find: /proc/1207/fd: Permission denied
find: /proc/.1208/fd: Permission denied
find: /proc/1216/fd: Permission denied
find: /proc/1217/fd: Permission denied
find: /proc/1218/fd: Permission denied
find: /proc/1219/fd: Permission denied
find: /proc/1220/fd: Permission denied
find: /proc/1221/fd: Permission denied
find: /proc/1222/fd: Permission denied
find: /proc/1276/fd: Permission denied
find: /proc/1277/fd: Permission denied
find: /proc/1286/fd: Permission denied
find: /proc/22505/fd: Permission denied
find: /proc/22509/fd: Permission denied
find: /proc/22510/fd: Permission denied
find: /proc/22511/fd: Permission denied
find: /proc/22512/fd: Permission denied
find: /proc/22513/fd: Permission denied
find: /proc/22514/fd: Permission denied
find: /proc/22515/fd: Permission denied
find: /proc/22516/fd: Permission denied
find: /proc/22517/fd: Permission denied
find: /proc/22518/fd: Permission denied
find: /proc/22522/fd: Permission denied
find: /proc/7348/fd: Permission denied
find: /proc/31443/fd: Permission denied
find: /proc/31445/fd: Permission denied
find: /proc/23959/fd: Permission denied
find: /proc/23964/fd: Permission denied
find: /var/lib/slocate: Permission denied
find: /var/lib/nfs/statd: Permission denied
find: /var/lib/xdm/authdir: Permission denied
find: /var/lib/dav: Permission denied
find: /var/log/samba: Permission denied
find: /var/log/httpd: Permission denied
find: /var/log/audit.d: Permission denied
find: /var/cache/alchemist/printconf.rpm: Permission denied
find: /var/cache/alchemist/printconf.local: Permission denied
find: /var/cache/samba/winbindd_privileged: Permission denied
find: /var/cache/mod_proxy: Permission denied
find: /var/run/sudo: Permission denied
find: /var/run/mdmpd: Permission denied
find: /var/run/named: Permission denied
find: /var/spool/at: Permission denied
find: /var/spool/clientmqueue: Permission denied
find: /var/spool/mqueue: Permission denied
find: /var/spool/cron: Permission denied
find: /var/spool/cups: Permission denied
find: /var/empty/sshd: Permission denied
find: /var/gdm: Permission denied
find: /var/named: Permission denied
find: /tmp/orbit-root: Permission denied
find: /tmp/orbit-oracle: Permission denied
find: /tmp/orbit-phadmin: Permission denied
find: /etc/audit: Permission denied
find: /etc/racoon/certs: Permission denied
find: /etc/cups/certs: Permission denied
find: /root: Permission denied
find: /usr/lost+found: Permission denied
find: /usr/share/ssl/CA: Permission denied
find: /home/phadmin: Permission denied
find: /home/oracle: Permission denied
find: /opt/lost+found: Permission denied
find: /opt/was60/AppServer/cloudscape/databases: Permission denied
find: /opt/was60/AppServer/derby/databases: Permission denied
/opt/oracle/10.2.0/client_1/rdbms/admin/sql.bsq
find: /apps/.Trash-root: Permission denied




this is waht i get, do i need to login to root user to do this?

Re: How to find out where oracle is installed? [message #285874 is a reply to message #285863] Wed, 05 December 2007 23:51 Go to previous messageGo to next message
BlackSwan
Messages: 22485
Registered: January 2009
Senior Member
>/opt/oracle/10.2.0/client_1/rdbms/admin/sql.bsq
Are you sure that the server version of Oracle installed on this system? ("client_1")
Re: How to find out where oracle is installed? [message #285875 is a reply to message #285863] Wed, 05 December 2007 23:56 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
well i am connected to my onsite machine..and I am not sure
what version they have installed...

i tried this

[wasadmin@devlinuxvm5 wasadmin]$ cd /opt/oracle/10.2.0/client_1/rdbms/admin/sql.bsq
-bash: cd: /opt/oracle/10.2.0/client_1/rdbms/admin/sql.bsq: Not a directory
[wasadmin@devlinuxvm5 wasadmin]$

Re: How to find out where oracle is installed? [message #285904 is a reply to message #285875] Thu, 06 December 2007 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not a directory, this is a file.

Regards
Michel
Re: How to find out where oracle is installed? [message #286396 is a reply to message #285904] Fri, 07 December 2007 04:46 Go to previous messageGo to next message
trantuananh24hg
Messages: 600
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
and then, if you want to execute any sql file in SQLPLUS

$sqlplus /nolog
SQL> conn /as sysdba
SQL> @'/opt/oracle/10.2.0/client_1/rdbms/admin/[b][i]file.sql[/b][/i]


Re: How to find out where oracle is installed? [message #286401 is a reply to message #286396] Fri, 07 December 2007 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does this have to do with the question?

Regards
Michel
Re: How to find out where oracle is installed? [message #286411 is a reply to message #286401] Fri, 07 December 2007 05:13 Go to previous messageGo to next message
trantuananh24hg
Messages: 600
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I guess that the topic owner wanted to execute some script by sql Cool
Re: How to find out where oracle is installed? [message #286426 is a reply to message #286411] Fri, 07 December 2007 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The question is "How to find out where oracle is installed?" nothing more otherwise we can answer many not expressed questions.
Maybe he wants to know this to backup the database.
Maybe he wants to erase the directory.
Maybe he wants to relocate it.
Maybe he wants to update oratab.
Maybe...

Regards
Michel
Re: How to find out where oracle is installed? [message #286516 is a reply to message #285872] Fri, 07 December 2007 14:38 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can avoid the "Permission denied" messages by using:

find / -name sql.bsq 2>/dev/null
Previous Topic: How can I do to start Oracle in Solaris automatically?
Next Topic: How do I run backup schedule with RMAN?
Goto Forum:
  


Current Time: Wed Jul 23 11:31:51 CDT 2014

Total time taken to generate the page: 0.09948 seconds