Database configuration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Database configuration

  1. #1
    Join Date
    Nov 2002
    Posts
    16

    Database configuration

    Just created an Oracle Database on windows XP, Oracle 817 and I am having problems connecting to this through SQLplus, TNSPING. Receiving error message TNS:could not resolve service name. All configuration looks ok.

    # TNSNAMES.ORA Network Configuration File: d:\Ora817\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    DSDXP01 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DSD_LAPTOP)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = DSDXP01)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DSD_LAPTOP)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = DSDXP01)
    (PRESENTATION = http://admin)
    )
    )




    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )


    ********************************************
    # SQLNET.ORA Network Configuration File: d:\Ora817\NETWORK\ADMIN\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.INITIAL_RETRY_TIMEOUT = 2

    NAME.DEFAULT_ZONE = world

    NAMES.DEFAULT_DOMAIN = world

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

    ***********************************************

    # LISTENER.ORA Network Configuration File: d:\Ora817\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENERORA8 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DSD_LAPTOP)(PORT = 1521))
    )

    SID_LIST_LISTENERORA8 =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = d:\Ora817)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = DSDXP01)
    (ORACLE_HOME = d:\Ora817)
    (SID_NAME = DSDXP01)
    )
    )

    *************************
    Services running

    Oracleservice for dsdxp01
    Listener

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    The fully qualified name is DSDXP01.WORLD.

    If you are using NAMES.DEFAULT_DOMAIN, the value should match the domain name of your local environment. For example, suppose you use a domain name of company.com. A fully qualified net service name for a database named kfm would be kfm.company.com.

    If you are connecting remotely (and you can do this on the server by going thru the network), the connect descriptor is username/password@kfm. What Oracle Net8 does is take "kfm" and add the value for NAMES.DEFAULT_DOMAIN to it (i.e., kfm.company.com) and then looks for an entry of kfm.company.com in your tnsnames.ora file. If Net8 does not see kfm.company.com in the file, you get an
    error.

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    In short just # out the entry 'NAMES.DEFAULT_DOMAIN' in sqlnet.ora
    or add .world with the service name in tnsnames.ora
    Vinit

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    stecal,

    Thanks for that - It answers the question, but I think it is only half the story?

    Please, do you know of a ref to a CLEAR COMPLETE explanation of how the names in Net8 (or equivalent) work. The Net8 book seems intent on hiding all the horrid details! On top of that, there is complete confusion (at least in my mind, and those of my colleagues) beween db_name, SID name, global_name, service names, connection strings - all compounded with the ability to specfiy domain names in the init.ora and sqlnet.ora (can't the domain name be picked up from the internet value in the local environment as well?)!

    Quite happy to RTFM, if I can find the right one!

    Lewis Carrol had something about: the poem, the name of the poem, what the poem was called, what the name of the poem was called, etc etc.
    Last edited by DaPi; 12-19-2002 at 02:00 PM.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  5. #5
    Join Date
    Nov 2002
    Posts
    16

    Error ora-27101shared memory realm does not exist

    I commented out the entry 'NAMES.DEFAULT_DOMAIN' in sqlnet.ora and can now tnsping the database but when I try to connect to the database I receive the message

    ORA-01034: Oracle not available
    ORA-27101: shared memory realm does not exist

    My operating system is windows xp oracle 817

  6. #6
    Join Date
    Oct 2000
    Posts
    467
    Start/Open the Database. I assume the service is running.
    At command prompt type the foll.

    svrmgrl
    connect internal;
    startup ;
    Vinit

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    O'Reilly's "Oracle Net8 Configuration and Troubleshooting"

    http://www.bookpool.com/.x/mzsi5geiq...qs=oracle+net8

    $22.95

    http://download-west.oracle.com/docs...a96580/toc.htm

    free

  8. #8
    Join Date
    Nov 2002
    Posts
    16

    ora-01078 failure in processing system parameters

    when starting database from svrmgrl i receive the following message:-


    LRM-00116: syntax error at 'location' following 'd:\ora817\oradat'
    LRM-00113: error when processing file 'd:\ora817\admin\DSDXP01\pfile\initDSDXP01.ora'
    ORA-01078:failure in processing system parameters.

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    Your init.ora file has an error. What did you specify with the "location=" line (or lines)?

  10. #10
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Thanks stecal
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width