| How to make new Database connection through the SQL Developer [message #350908] |
Sat, 27 September 2008 06:36  |
Nadine
Messages: 2
Registered: July 2000
|
Junior Member |
|
|
Hi,
I'm new into Oracle, I have installed Oracle 11g
I have set the environment variable
ORACLE_HOME = C:\oracle\product\11.1.0\db_1
Path = C:\oracle\product\11.1.0\db_1\bin
Now I'm trying to use the SQL Developer to make new Database Connection
I have three inqueries
1) When I open the Oracle SQL Developer it gives an error message stating
Error while registering Oracle JDBC Diagnosability MBean
How can I resolve this?
2) How can I make new Database Connection?
I opened the C:\oracle\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora and added the following
DEV3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DEV3)
(SERVER = DEDICATED)
)
)
Now when I try to make new Database Connection using Basic Connection type and test it
it says:
Failure-Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. The Connecion descriptor used by the client was:localhost:1521:DEV3
Is there any missing steps I should have been done before creating new Database Connection?
3) when making new Database Connection should I specify any user name and password, or should they be configured somewhere else?
Any help?
|
|
|
|
| Re: How to make new Database connection through the SQL Developer [message #353574 is a reply to message #350908] |
Tue, 14 October 2008 04:03  |
amul
Messages: 252
Registered: April 2001
Location: Chennai
|
Senior Member |
|
|
3) First create a username and password to be able to connect to the server, you have to use these while logging in using SQLPLUS client
2)In the following TNS Entry use IP address of your server
HOST = 192.168.1.1
1)try connecting using the sqlplus client installed in your system first.
USERNAME:Scott
PASSWORD:Tiger
HOSTNAME:DEV3
|
|
|
|
| Re: How to make new Database connection through the SQL Developer [message #379767 is a reply to message #353574] |
Wed, 07 January 2009 22:09 |
mastmaal
Messages: 1
Registered: January 2009
Location: canada
|
Junior Member |
|
|
Hey, I've just installed oracle 11g and im having the same problem, that is, when i open sql developer it gives me the following error:
Error while registering Oracle JDBC Diagnosability MBean.
i tried making a connection with sql plus and then starting developer, but i have the same problem. if someone could please help me out, that would be awesome.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
