OraFAQ Forum: Unix » How to find out where oracle is installed?

Home » Infrastructure » Unix » How to find out where oracle is installed?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to find out where oracle is installed? [message #285863]

Wed, 05 December 2007 23:18

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?

Report message to a moderator

Re: How to find out where oracle is installed? [message #285866 is a reply to message #285863]

Wed, 05 December 2007 23:22

BlackSwan
Messages: 20245
Registered: January 2009

Senior Member

find / -name sql.bsq -print
& be prepared to wait for your answer

Report message to a moderator

Re: How to find out where oracle is installed? [message #285870 is a reply to message #285863]

Wed, 05 December 2007 23:39

Michel Cadot
Messages: 54712
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

Report message to a moderator

Re: How to find out where oracle is installed? [message #285872 is a reply to message #285863]

Wed, 05 December 2007 23:42

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?

Report message to a moderator

Re: How to find out where oracle is installed? [message #285874 is a reply to message #285863]

Wed, 05 December 2007 23:51

BlackSwan
Messages: 20245
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")

Report message to a moderator

Re: How to find out where oracle is installed? [message #285875 is a reply to message #285863]

Wed, 05 December 2007 23:56

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]$

Report message to a moderator

Re: How to find out where oracle is installed? [message #285904 is a reply to message #285875]

Thu, 06 December 2007 01:03

Michel Cadot
Messages: 54712
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not a directory, this is a file.

Regards
Michel

Report message to a moderator

Re: How to find out where oracle is installed? [message #286396 is a reply to message #285904]

Fri, 07 December 2007 04:46

trantuananh24hg
Messages: 547
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]

Report message to a moderator

Re: How to find out where oracle is installed? [message #286401 is a reply to message #286396]

Fri, 07 December 2007 04:55

Michel Cadot
Messages: 54712
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What does this have to do with the question?

Regards
Michel

Report message to a moderator

Re: How to find out where oracle is installed? [message #286411 is a reply to message #286401]

Fri, 07 December 2007 05:13

trantuananh24hg
Messages: 547
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

I guess that the topic owner wanted to execute some script by sql Cool

Report message to a moderator

Re: How to find out where oracle is installed? [message #286426 is a reply to message #286411]

Fri, 07 December 2007 06:07

Michel Cadot
Messages: 54712
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

Report message to a moderator

Re: How to find out where oracle is installed? [message #286516 is a reply to message #285872]

Fri, 07 December 2007 14:38

ebrian
Messages: 2786
Registered: April 2006

Senior Member

You can avoid the "Permission denied" messages by using:

find / -name sql.bsq 2>/dev/null

Report message to a moderator

Previous Topic:	How can I do to start Oracle in Solaris automatically?
Next Topic:	How do I run backup schedule with RMAN?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 19:46:45 CDT 2013

Total time taken to generate the page: 0.13034 seconds