Home » RDBMS Server » Networking and Gateways » Not able to connect to Oracle (Oracle 9i)
Not able to connect to Oracle [message #345876] Fri, 05 September 2008 03:30 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
I am not able to connect to a database through Toad or SQL Plus which I am able to connect through "Toad for Oracle".
Actually the problem is that I do not know how to do that using the other two when I have an IP address and port number.

I need to connect to Sql Plus to work on something but not able to do that. Please look into this.

While connecting to "Toad for Oracle", I am entering under
1). user/schema -- dbone
2). Password -- dbone

Under Direct Tab I am entrying :
Host -- 170.13.254.91
Port -- 1521

Service Name :
etgdev

And it connects to Toad for Oracle
It connects as dbone@170.13.254.91:1521/etgdev

I tried connecting to sql plus in different ways like :
username : dbone@170.13.254.91:1521/etgdev
password : dbone

and other combinations too...
but it didn't worked.

Please advice as how to connect to sql plus when I am able to connect through "toad for oracle".

Thanks for looking into this,

Mahi
Re: Not able to connect to Oracle [message #345991 is a reply to message #345876] Fri, 05 September 2008 08:40 Go to previous messageGo to next message
BlackSwan
Messages: 22488
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

my blue car works.
my red car does not work.
Tell me how to make my red car go.
Re: Not able to connect to Oracle [message #346077 is a reply to message #345876] Fri, 05 September 2008 18:02 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Show us the command you are typing at the command prompt to connect to the SQL*PLUS utility.
Re: Not able to connect to Oracle [message #346258 is a reply to message #346077] Sun, 07 September 2008 23:46 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
In Toad for Oracle it connects as : dbdone@170.13.254.91:1521/etgdev

Where the value entered are as :
Username/schema : dbdone
Password : dbdone
Direct : 170.13.254.91
Port : 1521
Service Name: etgdev


In Oracle Sql*Plus, I am trying to connect in different ways as :
1).
username : dbdone
password : dbdone
Host String: etgdev

2).
username : dbdone@170.13.254.91:1521
password : dbdone
Host String: etgdev

But I am not able to connect. Please help me on this as I do not know how to login in sql * when I have IP Address.

Thanks for looking into this,
Mahi

[Updated on: Sun, 07 September 2008 23:47]

Report message to a moderator

Re: Not able to connect to Oracle [message #346259 is a reply to message #345876] Sun, 07 September 2008 23:51 Go to previous messageGo to next message
BlackSwan
Messages: 22488
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

>But I am not able to connect

my car does not go.
Please help my car go.

Since you provide us no clue or error message, You're On Your Own (YOYO)!
Re: Not able to connect to Oracle [message #346265 is a reply to message #346259] Mon, 08 September 2008 00:22 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
HI,

If I enter :
username : dbdone
password : dbdone
Host String: etgdev

The error message is :
ORA-12154: TNS : could not resolve service name

SQL> conn
Enter user-name: dbdone
Enter password: dbdone
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn
Enter user-name: dbdone@170.13.254.91:1521
Enter password: *****
ERROR:
ORA-06401: NETCMN: invalid driver designator


SQL> conn
Enter user-name: dbdone@170.13.254.91:1521:etgdev
Enter password: *****
ERROR:
ORA-06401: NETCMN: invalid driver designator


SQL> conn dbdone/dbdone@170.13.254.91:1521:etgdev
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_string>] | /
SQL> conn dbdone/dbdone@170.13.254.91:1521:etgdev
ERROR:
ORA-06401: NETCMN: invalid driver designator


I tried various combinations to connect to sql plus. PLease advice on this as I am able to connect to "Toad for Oracle" as I told earlier.

Thanks,
Mahi
Re: Not able to connect to Oracle [message #346279 is a reply to message #346265] Mon, 08 September 2008 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Neither
dbdone/dbdone@170.13.254.91:1521:etgdev
nor
dbdone@170.13.254.91:1521
Is valid syntax in SQL*PLus 9i

Regards
Michel
Re: Not able to connect to Oracle [message #346286 is a reply to message #346279] Mon, 08 September 2008 01:31 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Any suggestions please!!!
Re: Not able to connect to Oracle [message #346290 is a reply to message #346286] Mon, 08 September 2008 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Suggestion for what?

Regards
Michel
Re: Not able to connect to Oracle [message #346337 is a reply to message #346290] Mon, 08 September 2008 04:37 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi Michel,
Please tell me as how to conn the sql when I have IP address and port number.
What should I use for username and password to connect to the dbdone user as the various combinations I used didn't let me to connect the database.

Regards,
Mahi
Re: Not able to connect to Oracle [message #346352 is a reply to message #346337] Mon, 08 September 2008 05:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

I used didn't let me to connect the database.
Run "netca" network configurtion assistant and create TNS_ENTRY then try to connect with the following syntax:

USERNAME/PASSWORD@TNS_ENTRY.

how to configure TNS_ENTRY kindly refer Oracle documentation.
Re: Not able to connect to Oracle [message #346371 is a reply to message #346352] Mon, 08 September 2008 06:38 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi Taj,
There is already a TNS_ENTRY for this database.

DBDONE.SYSTIMEMBP.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 170.13.254.91)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = etgdev)
    )
  )


And I have tried connecting using :
dbdone/dbdone@etgdev

and

dbdone/dbdone@etgdev.systimembp.com


But both gives the error :
ORA-12154: TNS:could not resolve service name
Re: Not able to connect to Oracle [message #346380 is a reply to message #346371] Mon, 08 September 2008 06:55 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Check if your listener is running. Run the following command and show the results.

lsnrctl status
Re: Not able to connect to Oracle [message #346385 is a reply to message #346371] Mon, 08 September 2008 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbdone/dbdone@DBDONE.SYSTIMEMBP.COM
If the entry is DBDONE.SYSTIMEMBP.COM then using "etgdev" or "etgdev.systimembp.com" will not help.

Regards
Michel
Re: Not able to connect to Oracle [message #347520 is a reply to message #346385] Fri, 12 September 2008 00:16 Go to previous messageGo to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi All,

I finally was able to connect to the Sql*Plus using
connect dbdone/dbdone@170.13.254.91:1521/etgdev


Now I know that when one has to connect to a remote host then the connection should be as :

username/password@hostname:port/servicename



Regards,
Mahi

[Updated on: Fri, 12 September 2008 00:17]

Report message to a moderator

Re: Not able to connect to Oracle [message #347534 is a reply to message #347520] Fri, 12 September 2008 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I finally was able to connect to the Sql*Plus using

connect dbdone/dbdone@170.13.254.91:1521/etgdev

Not with a 9i SQL*Plus, as I said this is only available from 10g.

Regards
Michel
Re: Not able to connect to Oracle [message #347542 is a reply to message #347534] Fri, 12 September 2008 01:14 Go to previous message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Thanks Michel,
But I was not aware that with Oracle 10g I can connect it. I just did some trial and error like before and luckly got connected.
However I connected the Oracle 9i database through 10g Sql*Plus only.

Regards,
Mahi
Previous Topic: about listener.ora,tnsnames.ora
Next Topic: tns listener
Goto Forum:
  


Current Time: Wed Jul 23 17:33:05 CDT 2014

Total time taken to generate the page: 0.12740 seconds