database connection failing from linux - UNIX for Dummies Questions & Answers

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
Oracle database connection pools setting	skully	Oracle Updates (RSS)	0	06-02-2008 12:04 AM
Connection problem with gui java program to postgreaql database using unix	uci	UNIX for Dummies Questions & Answers	2	12-15-2007 05:16 AM
database connection (unresolved sqlcxt)	gfhgfnhhn	UNIX for Advanced & Expert Users	2	03-01-2006 05:02 AM
database connection	ramneek	High Level Programming	0	10-18-2005 04:14 AM
Database connection	whartoner	High Level Programming	2	01-15-2002 08:38 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode