Quote:
Originally Posted by
newborndba
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)?
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.