Re: Newbie: stupid problem with WebDB

Enter your hostename also in the NT \etc\host FILE Look at the sample file !!!!!

"Joseph D. Horing" wrote:

> 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 '_at_' 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 - 15:51:24 CET