hi

currently i am sql developer
here my connection as

username: acctdb_database
password: password

host name : 192.168.20.20
port: 7890
sid: udi

the above are myschema details.

now i am using plsql developer tool.

here how can i connect to my database.
the only asking
username:
pasword:
and
Database;

when i am giving above credentials, not logon.

i am using oracle 10g database

any idea ??

What Oracle Client installation are you using? e.g.

• Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)
• Instant Client 11g

etc

Hi,

try using the Easy Connect Naming Method (aka EZ Connect)
The easy connect naming method enables clients to connect to a database without any configuration.

username/password@//hostname:port/SERVICENAME
Port 1521 is used if no port number is specified in the connection string.

Make sure that EZCONNECT is enabled in the sqlnet.ora file. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

'//' in data source is optional and is there to enable URL style hostname values

Using the SID instead of SERVICENAME
username/password@hostname:port:SID should work also (I couln't test this method)