Solaris

What I am trying to do is install Remedy on a Solaris machine. However to install Remedy on Solaris, the server has to be able to connect to the oracle database on the Linux server? How can I accomplish this?

You need to install an Oracle client. You can download the 11.2.0.1
Oracle client from technet.oracle.com. You need to create an account
on the site first.

It doesn't matter that the app server is Solaris and the database server is Linux. Just download the right version of the client and you should be fine. As long as you are running a 64 bit OS, you probably want the 64 bit Oracle client.

I ended up downloading Oracle client 11.2.0 and installed it on Solaris where application is installed. Please bare with me since I am fairly new to oracle and don't know even 2 % about it. Questions that I have in mind.

1) Which account I have to create (since you mentioned to create an account)?
2) How do I even connect from Solaris machine and access Oracle DB on linux?(steps)
3) I also don't have instance running on solaris and I can't do sqlplus as sysdba because it just hangs.
4) Do I have to update tnsnames.ora file in Solaris with linux system's information (Oracle sid, hostname port number etc)?

ahh, so you need to connect *AN* Oracle database, however, you don't have one created yet?
That'll be more fun You need to create a database instance first. You may need to grab Oracle Express (?) as I believe that one has no license requirement.

For more specific Oracle related help (ie help in getting it all setup), you may want to try the Oracle forum (since this issue sounds more Oracle related than Unix related )
https://community.oracle.com/communi...eloper/english

In any case, you need to hit the docs here:
Oracle Database Online Documentation 11g Release 2 (11.2)

And do some serious reading, my friend
Either that, or find yourself a proper DBA who can help get you setup.

Cheers, good luck!

I am trying to read as much as I can (seriously) but Oracle is not as simple as it sounds or maybe it is but not for me. I also have a new thread regarding some of the issues I am running into when creating DB from dbca. (some font error).
I also installed enterprise edition assuming it's free because we are just using it for testing purposes. We would love to find some Oracle consultant who can help but we can't ( resource issues ). This is the first experiment we are doing with the Oracle installation and it has been a painful experience for us.

I also know that i m no expert but i think I did good despite of having no knowledge of Oracle and how to install or what listener is or what tnsname.ora file is (all that good stuff) and I know I will get better once I get this thing up and running.

You need to start with the instalation guide for 64 bit Oracle on Linux.
Oracle

For the networking you will need to create a listener on the database server and a tnsnames.ora file on the Solaris application server. I assume that you are using hardware that you have, but I would think that it would be easier if everything was running on Linux. Solaris is OK, but in my humble opinion, most people are moving away from Unix towards Linux.

You should be able to use X-windows before you start the install. When you are done installing the software, and using dbca to create the database you can use netmgr to create the listener.

There are just so many steps I don't see how someone can just give you all of the instructions at once. you basically need to try installing the software and see if you can create a database. When you run dbca to create the database they have several templates that you can choose, it will make it easier to get through the database creation process.

I am glad I learned to be an Oracle DBA, I can't think of anything else that has such a steep learning curve to becoming proficient. Just take it one step at a time and keep learning.

For database specific questions you might try DBASupport.com, I am a moderator there.
DBAsupport.com Forums
You can also try the Oracle Forums, they get a lot more traffic, but they might not have that much patience for someone who is learning.

Thank you so much for being so helpful. I will start the installation process and will get back to this form if I run into any issues?

Thank you all for help.