×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

Thanks. Please check detail inside

1. tnsping service name, and result?
tnsping is OK. But TNSPing doesn't mean the listner is ok.

2. what errror message when you try to ster listener
Error message:
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
--Looks like Oracle instance did started correct.

3. what parameter did you changed
SGA paramters like shared pool size, buffer cache ..... Before all are zeroes. I changed them to 64M.

4. are you sure the oracle instance is started?
In enterprise manager ( Web based) it shows instance is not up.

Thanks
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / 紧急求助:在Enterprise Manger 里修改了ORACLE 10g SGA 的几个内存配置,ORACLE INSTANCE起来LISTNER连不上了。 没有备份。有办法回复吗? 几个星期的心血呀,全没了!万分感谢!
    • 在DB服务器上进入SQLPLUS不需要LISTENER,所以你可以进去改参数作备份等。你还可以运行lsnrctl去启动LISTENER
      • It looks like that the instance is not right.
        I can't connect to DB even from the server. When I started it it didn't have any error message and the service status is started. But when I started listner it complained that instance status is unknown. I think I need to change the setting for SGA. Any comments. Thanks a lot.
        • 检查alert log看里面记载了什么错误;如果仅仅是参数修改还可以用指定的PFILE启动数据库
          • I tried PFILE and it didn't work. Can I copy a PFILE from anywhere else? Please provide a PFILE if you have one and I will try . Thanks. It is windows2000.
          • How can I check Alter log? I am not a DBA. Thanks
      • what evnironment? you can set hte oracle_sid environment variable first from OS level and then sqlplus as sysdba. then do whatever you want. 10g can do self registration for the listener...
    • post you tnsnames and listner file from DB server, plus
      1. tnsping service name, and result?
      2. what errror message when you try to ster listener
      3. what parameter did you changed
      4. are you sure the oracle instance is started?
      • Thanks. Please check detail inside
        1. tnsping service name, and result?
        tnsping is OK. But TNSPing doesn't mean the listner is ok.

        2. what errror message when you try to ster listener
        Error message:
        ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
        --Looks like Oracle instance did started correct.

        3. what parameter did you changed
        SGA paramters like shared pool size, buffer cache ..... Before all are zeroes. I changed them to 64M.

        4. are you sure the oracle instance is started?
        In enterprise manager ( Web based) it shows instance is not up.

        Thanks
      • init.ora
        本文发表在 rolia.net 枫下论坛#
        # $Header: init.ora 25-jul-01.18:03:38 rajayar Exp $
        #
        # Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved. */
        #
        ##############################################################################
        # 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, use the
        # same file for all instance. Place all instance-specific parameters
        # at the end of the file using the <sid>.<parameter_name> = <value> syntax.
        # 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 differently for each instance, 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.
        ###############################################################################

        # replace "clustdb" with your database name
        db_name = clustdb
        compatible=9.0.0

        db_files = 1024 # INITIAL
        #INITIAL
        #db_files=80
        #SMALL
        #DB_files=400
        #MEDIUM
        #db_files=1000
        #LARGE

        control_files = ("\\.\clustdb_control1", "\\.\clustdb_control2")

        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

        #Datawarehouse
        db_block_size=8192
        # Transaction processing
        # db_block_size=4096

        open_cursors=300

        #Transaction processing
        #sort_area_size=524288
        #Datawarehouse
        sort_area_size=1048576
        large_pool_size=1048576 #Transaction processing, Datawarehouse
        db_cache_size=50331648 #Datawarehouse, Transaction processing
        java_pool_size=67108864 #Datawarehouse, Transaction processing


        # db_block_buffers = 200 # INITIAL
        # db_block_buffers=100 #SMALL
        # db_block_buffers =550 # MEDIUM
        # db_block_buffers=3200 #LARGE

        #shared_pool_size = 52428800 # INITIAL
        shared_pool_size = 67108864 # datewarehouse, transaction processing

        log_checkpoint_interval = 10000

        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 = 8192 # INITIAL
        #log_buffer = 8192
        #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 10 K 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 = %ORACLE_HOME%/admin/clustdb/arch
        # log_archive_format = "%%ORACLE_SID%%T%TS%S.ARC"

        # If using private rollback segments, place lines of the following
        # form at the end of this file:
        # <sid>.rollback_segments = (name1, name2)

        # 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/10 = 4:
        # transactions = 40
        # transactions_per_rollback_segment = 10

        # 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

        # define directories to store trace and alert files
        background_dump_dest=%ORACLE_HOME%/admin/clustdb/bdump
        user_dump_dest=%ORACLE_HOME%/admin/clustdb/

        db_block_size = 4096

        remote_login_passwordfile = exclusive

        # text_enable = TRUE

        # The following parameters are needed for the Advanced Replication Option

        job_queue_processes = 2
        # job_queue_processes = 4 #datawarehouse

        # job_queue_interval = 10
        # job_queue_keep_connections = false

        distributed_transactions = 5

        open_links = 4

        # The following parameters are instance-specific parameters that are
        # specified for two instances named clustdb1 and clustdb2

        undo_management=AUTO # For automatic undo management
        # = MANUAL For manual/RBS undo management
        cluster_database= true
        cluster_database_instances=2
        remote_listener=LISTENERS_CLUSTDB

        # First instance specific parameters
        clustdb1.thread=1
        clustdb1.instance_name=clustdb1
        clustdb1.instance_number=1
        clustdb1.local_listener=listener_clustdb1
        clustdb1.remote_login_passwordfile = exclusive
        # Comment out clustdb1.undo_tablespace and uncomment clustdb1.rollback_segments
        # when undo_management=MANUAL
        clustdb1.undo_tablespace = UNDOTBS1
        # clustdb1.rollback_segments = (rbs1_1,rbs1_2)

        # Second instance specific parameters

        clustdb2.thread=2
        clustdb2.instance_name = clustdb2
        clustdb2.instance_number = 2
        clustdb2.local_listener = listener_clustdb2
        clustdb2.remote_login_passwordfile = exclusive
        # Comment out clustdb2.undo_tablespace and uncomment clustdb2.rollback_segments
        # when undo_management=MANUAL
        clustdb2.undo_tablespace = UNDOTBS2
        # clustdb2.rollback_segments = (rbs2_1,rbs2_2)更多精彩文章及讨论,请光临枫下论坛 rolia.net
      • tnsnames.ora (server side)
        # tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
        # Generated by Oracle configuration tools.

        ORCL =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dw)(PORT = 1521))
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = orcl)
        )
        )

        EXTPROC_CONNECTION_DATA =
        (DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        )
        (CONNECT_DATA =
        (SID = PLSExtProc)
        (PRESENTATION = RO)
        )
        )
      • listner.ora
        # listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\listener.ora
        # Generated by Oracle configuration tools.

        SID_LIST_LISTENER =
        (SID_LIST =
        (SID_DESC =
        (SID_NAME = PLSExtProc)
        (ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
        (PROGRAM = extproc)
        )
        )

        LISTENER =
        (DESCRIPTION_LIST =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        (ADDRESS = (PROTOCOL = TCP)(HOST = dw)(PORT = 1521))
        )
        )
      • is the oem installed on the seperate machine?
        I find it's too hard to interact like this, why don't we talk on phone? check your PM
        • Instance is up now. Thanks a lot to all of you, especially to 东流水( I sent you an email, please check)