This content has been marked as final. Show 4 replies
I tried creating SYSTEM in all caps, to try to force a duplicate id error, but SQL Developer took it.
I keep getting "The Network Adapter could not establish the connection Vendor Code 20" when I try to connect. Therefore, something is missing somewhere, but I'm not sure what.
Once I connect to the Network Adapter, will the default ids show up?
Once I connect to the Network Adapter, will the default ids show up?The SQL Developer Help says (and I believe this procedure works even if you cannot "connect" to the local database):
Next, if this what you are actually asking, and you have a local database installed, then you need to make sure your database listener is up and running. Open a command line and try these commands:
To create (automatically generate) a database connection for each unlocked user account in the Oracle database instance on the local system, right-click the Connections node and select Create Local Connections. The connections are placed in a folder named Auto-Generated Local Connections. Note that for these autogenerated connections (except for the one named system-<database-name>), you will always be prompted for the password when you connect, and you cannot edit the user name or password in the connection properties dialog box.
lsnrctl statusIf it is not already started, either start it with
lsnrctl startor otherwise from your Windows Administrator Tools -> Services -> Oracle<home>Listener (right-click: Start)
Hope this helps,
Right-clicking the Connections node and selecting Create Local Connections worked. I now have "/ as sysdba", "SYSTEM", and "system-orcl" under Auto-Generated Local Connections. Thanks.
However, I still have the problem "Network Adapter could not establish the connection" when I try to create a new connection.
Edited by: PaulK on Apr 25, 2013 9:26 PM