1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

sqldeveloper-oracle databasw connection issues reg

Discussion in 'SQL PL/SQL' started by laxman, Dec 31, 2009.

  1. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    dear all,
    If you could help me with one problem i am facing while establishing connection between sqldeveloper and my local oracle database running on window xp(32 bit).
    i have followed this steps mentioned below:

    step 1: Installed successfully sqldeveloper tool in my personal pc where oracle database is already running on.

    step 2: Executed the sqldeveloper.exe file successfully.

    step 3: In the pop up window under connection option i choose CREATE LOCAL DATABASE CONNECTION

    step 4: after following step 3 i found my local database name available under connection option.
    it is something like this
    UNDER CONNECTION OPTION:
    AUTO-GENERATED LOCAL CONNECTION
    + / AS SYSDBA
    + SYSTEM-LAXORA
    Now the problem arises here, when i am clicking the "SYSTEM-LAXORA" option one pop window is displaying with username as system and the i am giving the password for user SYSTEM which is valid password for my local database.but the moment i am giving password and pressing ok button, one pop windiow is getting display with warning message mentioned below.
    Error message: AN ERROR WAS ENCOUNTERED PERFORMING THE REQUESTED OPERATION;
    IO EXCEPTION: THE NETWORK ADAPTER COULD NOT ESTABLISH THE CONNECTION
    VENDOR CODE:17002

    Any solution for this problem will be highly appreciable

    Thanks n regards
    Laxman
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You do have a valid Oraclie client software installation on this pc? You can tnsping this database successfully? You can ping the server on which this database runs successfully? These are checks that must be made before attempting to proceed further.
     
  3. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    Dear sir,
    firstly Thanks for your valuable information. actually sir, what you are suggesting is for client-server based system but for your kind information i am trying in my personal home PC, that means both the application(oracle database and sqldeveloper) is running in single system.
    Now with this kind of scenario what are necessary checks i should do to rectify this problem.
    kindly do the needful.

    Thanks n regards
    Laxman
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The advice doesn't change as sql-developer needs a valid tnsnames.ora file to connect to a database. If you cannot tnsping your local database you need to correctly configure your local tnsnames.ora file so you can.
     
  5. laxman

    laxman Forum Expert

    Messages:
    144
    Likes Received:
    0
    Trophy Points:
    230
    Location:
    MUMBAI
    ok sir let me verify the configuration of tnsnames.ora file

    Thanks n regards
    Laxman
     
  6. SudeepShakya

    SudeepShakya Active Member

    Messages:
    33
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Kathmandu,Nepal
    i also have some sort of connection problem
    when i tried to connect the database in sql developer using the sysdba as the user with a valid password
    invalid usr/password is displayed/ logon denied
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    SYSDBA is not a user, it's a privilege level. SYS is the user, SYSDBA is the privilege level:

    SQL> connect sys as sysdba
    Enter password:
    Connected.
    SQL>

    or if you're logged in to the database server as 'oracle':

    SQL> connect / as sysdba
    Connected.
    SQL>

    Remotely:

    SQL> connect sys@... as sysdba
    Enter password:
    Connected.
    SQL>