Linux Oracle in Ubuntu 10.10

avi

avi

Level J
I have installed successfully from the link :

Samushka: Installing Oracle SQL*Plus in Ubuntu

But he said :

Go ahead and enter your favorite connections into it.

gedit ~/tnsnames.ora
Click to expand...

What I have to enter in it ?

sqlplus /nolog is working. But when I enter sqlplus & give username : scott & password : tiger, it gives me following error :

ERROR:

ORA-12545: Connect failed because target host or object does not exist
Click to expand...

I assume it's because of empty tnsnames.ora file. So what I have to write in that file ?

And also I have these two lines to ~/.bashrc

export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib

export TNS_ADMIN=~

I need to add ORACLE_SID also right ? What should be it's value ?

Thanks in advance :D

PS - I am total n00b in oracle
 
Ohh...you just installed SQL Plus not the database server? I thought you installed oracle database server. SQL Plus is a client to connect to Oracle database. So your Oracle database should be up and running before connecting via SQL Plus. Also while creating database, you need to specify the SID name.
 
Dude, you need to install Database server as well. Go for Express Edition - Its free

Also, You do not need to install the client onto the same computer as Oracle Database 10g Express Edition. so SQL*PLus might not be needed.

Still if you face trouble, follow documentation. Particularly pay attention to Installation flash Video.Instead of downloading *.rpm file and doing rpm -ivh as given in guide.

download *.deb file and double click on it to install.
 
I was misunderstood by that tutorial. Actually I am an engineering student, just wanted it for to practice basic commands. I love linux, so thought I'd be using in it. Now I found out I got to download nearly 2GB data to work everything properly. So, I installed VMPlayer in my linux, running XP & installed SQL Plus 8 [yeah, my teacher suggests me to use this obsolete software].

Thank you everyone :D
 
Back
Top