Not able to connect to Oracle [message #345876] |
Fri, 05 September 2008 03:30  |
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 #346258 is a reply to message #346077] |
Sun, 07 September 2008 23:46   |
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 #346265 is a reply to message #346259] |
Mon, 08 September 2008 00:22   |
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 #346337 is a reply to message #346290] |
Mon, 08 September 2008 04:37   |
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 #346371 is a reply to message #346352] |
Mon, 08 September 2008 06:38   |
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 #347520 is a reply to message #346385] |
Fri, 12 September 2008 00:16   |
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 #347542 is a reply to message #347534] |
Fri, 12 September 2008 01:14  |
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
|
|
|