Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Newbie: stupid problem with WebDB

Newbie: stupid problem with WebDB

From: Joseph D. Horing <jdh_at_itconsulting.it>
Date: Wed, 09 Feb 2000 07:25:17 +0100
Message-ID: <38A1084C.D939D64C@itconsulting.it> 





After installing on my NT machine both Oracle 8i and WebDB, when I try to access
WebDB through Netscape, I get a "TNS: cannot resolve service name" error
message.



I am posting this because I believe this is caused by a misconfiguration in some
.ora file that I cannot detect because I am newbie with Oracle.



Thank you in advance.



Computer name: jdhoring


Single processor Intel Pentium, 128MB physical RAM, Windows NT4.0 workstation SP
6, IE5 installed.



Following are some .ora files and setup data, if anything else is needed, let me
know.




Oracle 8i:


Orale installation directorycomp.databases.oracle.server: E:\Oracle
ORACLE_HOME for Oracle 8i: E:\Oracle\Ora81
Global DB Name: O8I.jdhoring


SID: O8I



E:\Oracle\Ora81\DATABASE\initO8I.ora follows:
IFILE='E:\Oracle\admin\O8I\pfile\init.ora'
END initO8I.ora




E:\Oracle\ADMIN\O8I\pfile\init.ora follows


#


# Copyright (c) 1991, 1998 by Oracle Corporation


#


##############################################################################


# Example INIT.ORA file


#


# This file is provided by Oracle Corporation to help you customize


# your RDBMS installation for your site.  Important system parameters


# are discussed, and example settings given.


#


# Some parameter settings are generic to any size installation.


# For parameters that require different values in different size


# installations, three scenarios have been provided: SMALL, MEDIUM


# and LARGE.  Any parameter that needs to be tuned according to


# installation size will have three settings, each one commented


# according to installation size.


#


# Use the following table to approximate the SGA size needed for the


# three scenarious provided in this file:


#


#                     -------Installation/Database Size------


#                      SMALL           MEDIUM           LARGE



#  Block         2K    4500K            6800K           17000K


#  Size          4K    5500K            8800K           21000K


#


# To set up a database that multiple instances will be using, place


# all instance-specific parameters in one file, and then have all


# of these files point to a master file using the IFILE command.


# This way, when you change a public


# parameter, it will automatically change on all instances.  This is


# necessary, since all instances must run with the same value for many


# parameters. For example, if you choose to use private rollback segments,


# these must be specified in different files, but since all gc_*


# parameters must be the same on all instances, they should be in one file.


#


# INSTRUCTIONS: Edit this file and the other INIT files it calls for


# your site, either by using the values provided here or by providing


# your own.  Then place an IFILE= line into each instance-specific


# INIT file that points at this file.


#


# NOTE: Parameter values suggested in this file are based on conservative


# estimates for computer memory availability. You should adjust values upward


# for modern machines.


#


###############################################################################





db_name = O8I



db_domain = jdhoring



instance_name = O8I



service_names = O8I.jdhoring



db_files = 1024  # INITIAL


# db_files = 80                                                       # SMALL


# db_files = 400                                                      # MEDIUM


# db_files = 1500                                                     # LARGE





control_files = ("E:\Oracle\oradata\O8I\control01.ctl",
"E:\Oracle\oradata\O8I\control02.ctl")



max_enabled_roles = 30 # webdb ne vuole min. 25 /jdh/



db_file_multiblock_read_count = 8  # INITIAL


# db_file_multiblock_read_count = 8                                   # SMALL


# db_file_multiblock_read_count = 16                                  # MEDIUM


# db_file_multiblock_read_count = 32                                  # LARGE





db_block_buffers = 8192  # INITIAL


# db_block_buffers = 100                                              # SMALL


# db_block_buffers = 550                                              # MEDIUM


# db_block_buffers = 3200                                             # LARGE





shared_pool_size = 15728640  # INITIAL


# shared_pool_size = 3500000                                          # SMALL


# shared_pool_size = 5000000                                          # MEDIUM


# shared_pool_size = 9000000                                          # LARGE





java_pool_size = 20971520



log_checkpoint_interval = 10000


log_checkpoint_timeout = 1800



processes = 59  # INITIAL


# processes = 50                                                      # SMALL


# processes = 100                                                     # MEDIUM


# processes = 200                                                     # LARGE





parallel_max_servers = 5  # SMALL


# parallel_max_servers = 4 x (number of CPUs)                         # MEDIUM


# parallel_max_servers = 4 x (number of CPUs)                         # LARGE





log_buffer = 32768  # INITIAL


# log_buffer = 32768                                                  # SMALL


# log_buffer = 32768                                                  # MEDIUM


# log_buffer = 163840                                                 # LARGE





#audit_trail = true  # if you want auditing


#timed_statistics = true  # if you want timed statistics


max_dump_file_size = 10240  # limit trace file size to 5M each



# Uncommenting the line below will cause automatic archiving if archiving has


# been enabled using ALTER DATABASE ARCHIVELOG.


# log_archive_start = true


# log_archive_dest_1 = "location=E:\Oracle\oradata\O8I\archive"


# log_archive_format = "%%O8I%%T%TS%S.ARC"





# If using private rollback segments, place lines of the following


# form in each of your instance-specific init.ora files:


# rollback_segments = (r01, r02, r03, r04)





# If using public rollback segments, define how many


# rollback segments each instance will pick up, using the formula


#   # of rollback segments = transactions / transactions_per_rollback_segment


# In this example each instance will grab 40/5 = 8


# transactions = 40


# transactions_per_rollback_segment = 5





# Global Naming -- enforce that a dblink has same name as the db it connects to


global_names = true



# Edit and uncomment the following line to provide the suffix that will be


# appended to the db_name parameter (separated with a dot) and stored as the


# global database name when a database is created.  If your site uses


# Internet Domain names for e-mail, then the part of your e-mail address after


# the '@' is a good candidate for this parameter value.


# db_domain = us.acme.com  # global database name is db_name.db_domain





# Uncomment the following line if you wish to enable the Oracle Trace product


# to trace server activity.  This enables scheduling of server collections


# from the Oracle Enterprise Manager Console.


# Also, if the oracle_trace_collection_name parameter is non-null,


# every session will write to the named collection, as well as enabling you


# to schedule future collections from the console.


# oracle_trace_enable = true





oracle_trace_collection_name = ""


# define directories to store trace and alert files


background_dump_dest = E:\Oracle\admin\O8I\bdump
user_dump_dest = E:\Oracle\admin\O8I\udump



db_block_size = 2048



remote_login_passwordfile = exclusive



os_authent_prefix = ""



# The following parameters are needed for the Advanced Replication Option


job_queue_processes = 2


job_queue_interval = 10


open_links = 4



distributed_transactions = 500


mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"


# Uncomment the following line when your listener is configured for SSL


# (listener.ora and sqlnet.ora)


# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"





mts_servers = 1


compatible = 8.1.0


====END init.ora




E:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora follows


# E:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration


File:E:\Oracle\Ora81\network\admin\tnsnames.ora


# Generated by Oracle Net8 Assistant





O8I =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = JDHORING)(PORT = 1521))

    )


    (CONNECT_DATA =



      (SERVICE_NAME = O8I.JDHORING)



    )


  )



EXTPROC_CONNECTION_DATA =



  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )


    (CONNECT_DATA =


      (SID = PLSExtProc)
      (PRESENTATION = RO)




    )


  )


====END tnsnames.ora (for Oracle 8i)




E:\Oracle\Ora81\NETWORK\ADMIN\listener.ora follows


# E:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration


File:E:\Oracle\Ora81\network\admin\listener.ora


# Generated by Oracle Net8 Assistant





LISTENER =



  (DESCRIPTION_LIST =



    (DESCRIPTION =


      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = jdhoring)(PORT = 1521))
      )




    )


    (DESCRIPTION =


      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = jdhoring)(PORT = 2481))


    )


  )



SID_LIST_LISTENER =



  (SID_LIST =



    (SID_DESC =


      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\Oracle\Ora81)
      (PROGRAM = extproc)




    )


    (SID_DESC =


      (GLOBAL_DBNAME = O8I.jdhoring)
      (ORACLE_HOME = E:\Oracle\Ora81)
      (SID_NAME = O8I)




    )


  )


====END listener.ora



WebDB:


ORACLE_HOME for WebDB: E:\Oracle\Ora81W
E:\Oracle\Ora81W\NET80\ADMIN\tnsnames.ora follows:
O8I =


  (DESCRIPTION =



    (ADDRESS_LIST =



      (ADDRESS = (PROTOCOL = TCP)(HOST = JDHORING)(PORT = 1521))

    )


    (CONNECT_DATA =



      (SERVICE_NAME = O8I.JDHORING) (SID = O8I)

    )


  )


Beq-local.world =


  (DESCRIPTION =



    (ADDRESS_LIST =


        (ADDRESS =
          (PROTOCOL = BEQ)
          (PROGRAM = oracle80)
          (ARGV0 = oracle80ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )




    )


    (CONNECT_DATA = (SID = ORCL)



    )


  )


Tcp-loopback.world =


  (DESCRIPTION =



    (ADDRESS_LIST =


        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )




    )


    (CONNECT_DATA = (SID = ORCL)



    )


  )


TcpExample.world =


  (DESCRIPTION =



    (ADDRESS_LIST =


        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = Production1)
          (Port = 1521)
        )




    )


    (CONNECT_DATA = (SID = ORCL)



    )


  )


SpxExample.world =


  (DESCRIPTION =



    (ADDRESS_LIST =


        (ADDRESS =
          (PROTOCOL = SPX)
          (Service = Server_lsnr)
        )




    )


    (CONNECT_DATA = (SID = ORCL)



    )


  )


NmpExample.world =


  (DESCRIPTION =



    (ADDRESS_LIST =


        (ADDRESS =
          (PROTOCOL = NMP)
          (Server = FinanceServer1)
          (Pipe = ORAPIPE)
        )




    )


    (CONNECT_DATA = (SID = ORCL)



    )


  )


CMExample.world =


  (DESCRIPTION=(address_list=

      (ADDRESS=
          (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
      (ADDRESS=
          (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
      (CONNECT_DATA=(SID=ORCL))
         (SOURCE_ROUTE=yes)




  )


extproc_connection_data.world =


  (DESCRIPTION =



    (ADDRESS =


        (PROTOCOL = IPC)
        (KEY = EXTPROC1)




    )


    (CONNECT_DATA = (SID = extproc)


    )


  )


====END tnsnames.ora (for WebDB)



E:\Oracle\Ora81W\NET80\ADMIN\sqlnet.ora follows:
TRACE_LEVEL_CLIENT = OFF



#sqlnet.authentication_services = (NONE)


names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world


name.default_zone = world


automatic_ipc = off


====END sqlnet.ora (for WebDB)



Received on Wed Feb 09 2000 - 00:25:17 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US