database connection failing from linux

DILEEP410 · #1 (**permalink**) 10-05-2007

Hi,

I am trying to connect to an Oracle database using the following code :
sqlplus username/password@database_name

It was showing an error 'username/password invalid'

But i tried: sqlplus username/password ,it was connecting now.

Can anyone suggest what may be the issue and why?Can i track from where did it fetch the database information?

Your help is appreciated

With Regards
Dileep Pattayath

ermur · #2 (**permalink**) 10-05-2007

Hi Dileep

If you get connected without providing the Oracle SID, it's been gotten from the environment, try this:

$ echo $ORACLE_SID

It should show what SID you're connecting to.

Regards,

Erwin

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
database connection (unresolved sqlcxt)	gfhgfnhhn	UNIX for Advanced & Expert Users	3	09-20-2008 09:44 AM
Oracle database connection pools setting	skully	Oracle Updates (RSS)	0	06-02-2008 03:04 AM
Connection problem with gui java program to postgreaql database using unix	uci	UNIX for Dummies Questions & Answers	2	12-15-2007 09:16 AM
database connection	ramneek	High Level Programming	0	10-18-2005 07:14 AM
Database connection	whartoner	High Level Programming	2	01-15-2002 12:38 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by