1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

oracle username,password

Discussion in 'Software Development' started by punjabian263, Apr 1, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. punjabian263

    punjabian263 Thread Starter

    Joined:
    Mar 13, 2003
    Messages:
    358
    i have installed oracle9i, when i open the sqlplus editor, and give username and pass as

    username=scott
    password=tiger

    it gives error as "PROTOCOL ADAPTOR ERROR"
    if i give hoststring

    host string=localhost

    it says, "could not resolve service name"

    any help is welcome
     
  2. coderitr

    coderitr

    Joined:
    Oct 12, 2003
    Messages:
    3,015
    You have to specify the name of the database server in the host name parameter as defined in the tnsnames.ora file.
     
  3. punjabian263

    punjabian263 Thread Starter

    Joined:
    Mar 13, 2003
    Messages:
    358
    here is my tnsnames.ora file struc

    ------------------struc of tnsnames.ora----------------

    # This file contains the syntax information for
    # the entries to be put in any tnsnames.ora file
    # The entries in this file are need based.
    # There are no defaults for entries in this file
    # that Sqlnet/Net3 use that need to be overridden
    #
    # Typically you could have two tnsnames.ora files
    # in the system, one that is set for the entire system
    # and is called the system tnsnames.ora file, and a
    # second file that is used by each user locally so that
    # he can override the definitions dictated by the system
    # tnsnames.ora file.

    # The entries in tnsnames.ora are an alternative to using
    # the names server with the onames adapter.
    # They are a collection of aliases for the addresses that
    # the listener(s) is(are) listening for a database or
    # several databases.

    # The following is the general syntax for any entry in
    # a tnsnames.ora file. There could be several such entries
    # tailored to the user's needs.

    <alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have
    # one or more descriptions
    # If there is just one description, unnecessary ]
    (DESCRIPTION=
    [ (SDU=2048) ] # Optional, defaults to 2048
    # Can take values between 512 and 32K
    [ (ADDRESS_LIST= # Optional depending on whether u have
    # one or more addresses
    # If there is just one address, unnecessary ]
    (ADDRESS=
    [ (COMMUNITY=<community_name>) ]
    (PROTOCOL=tcp)
    (HOST=<hostname>)
    (PORT=<portnumber (1521 is a standard port used)>)
    )
    [ (ADDRESS=
    (PROTOCOL=ipc)
    (KEY=<ipckey (PNPKEY is a standard key used)>)
    )
    ]
    [ (ADDRESS=
    [ (COMMUNITY=<community_name>) ]
    (PROTOCOL=decnet)
    (NODE=<nodename>)
    (OBJECT=<objectname>)
    )
    ]
    ... # More addresses
    [ ) ] # Optional depending on whether ADDRESS_LIST is used or not
    [ (CONNECT_DATA=
    (SID=<oracle_sid>)
    [ (GLOBAL_NAME=<global_database_name>) ]
    )
    ]
    [ (SOURCE_ROUTE=yes) ]
    )
    (DESCRIPTION=
    [ (SDU=2048) ] # Optional, defaults to 2048
    # Can take values between 512 and 32K
    [ (ADDRESS_LIST= ] # Optional depending on whether u have more
    # than one address or not
    # If there is just one address, unnecessary
    (ADDRESS
    [ (COMMUNITY=<community_name>) ]
    (PROTOCOL=tcp)
    (HOST=<hostname>)
    (PORT=<portnumber (1521 is a standard port used)>)
    )
    [ (ADDRESS=
    (PROTOCOL=ipc)
    (KEY=<ipckey (PNPKEY is a standard key used)>)
    )
    ]
    ... # More addresses
    [ ) ] # Optional depending on whether ADDRESS_LIST
    # is being used
    [ (CONNECT_DATA=
    (SID=<oracle_sid>)
    [ (GLOBAL_NAME=<global_database_name>) ]
    )
    ]
    [ (SOURCE_ROUTE=yes) ]
    )
    [ (CONNECT_DATA=
    (SID=<oracle_sid>)
    [ (GLOBAL_NAME=<global_database_name>) ]
    )
    ]
    ... # More descriptions
    [ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not
     
  4. punjabian263

    punjabian263 Thread Starter

    Joined:
    Mar 13, 2003
    Messages:
    358
    where is my database server name coderitr
     
  5. coderitr

    coderitr

    Joined:
    Oct 12, 2003
    Messages:
    3,015
    Unfortunately, I'm not familiar with the structure of the tnsnames.ora file. I work with Oracle as a user and recognize the message you're getting as a problem resolving the host name you entered to a database location in tnsnames. Someone more familiar with Oracle from an adminstration level would be more able to answer your question.
     
  6. punjabian263

    punjabian263 Thread Starter

    Joined:
    Mar 13, 2003
    Messages:
    358
    no problem coderitr, thanks
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/216477

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice