This discussion is archived
3 Replies Latest reply: Nov 27, 2012 4:36 AM by Neill_R RSS

Listener working but not working for Enterprise manager oracle 11gr2 Linux.

Neill_R Newbie
Currently Being Moderated
Below are my configuration files (listner.ora,sqlnet.ora and tnsnames.ora) My domain name has been altered for my protection.
I am running Ubuntu 12.04 LTS and have installed Oracle 11gR2 which was working.

While trying to sort out another problem wiith database links between this database and another 11gR2 installed on Windows XP Sp3 I have messed up and now find I can't get access to Enterprise manager.

I can connect

sqlplus SYSTEM/????????@TNSGWORCL

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 26 14:52:23 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

but the database control page of the enterprise manager reports

Listener UNAVAILABLE


lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-NOV-2012 14:54:48

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=freds-server.i-surname.co.uk)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 26-NOV-2012 14:31:47
Uptime 0 days 0 hr. 23 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/11g/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/freds-server/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=freds-server)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=freds-server)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "GWORCL.i-surname.co.uk" has 2 instance(s).
Instance "GWORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "GWORCL", status READY, has 1 handler(s) for this service...
Service "GWORCLXDB.i-surname.co.uk" has 1 instance(s).
Instance "GWORCL", status READY, has 1 handler(s) for this service...
The command completed successfully


Control files

# listener.ora Network Configuration File: /opt/oracle/11g/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = freds-server.i-surname.co.uk)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=GWORCL.i-surname.co.uk)
(SID_NAME=GWORCL)
(ORACLE_HOME=/opt/oracle/11g)
)
)

ADR_BASE_LISTENER = /opt/oracle
LOGGING_GWORCL = OFF

# sqlnet.ora Network Configuration File: /opt/oracle/11g/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH=(TNSNAMES)

ADR_BASE = /opt/oracle
#SQLNET.INBOUND_CONNECT_TIMEOUT=10000
#SQLNET.SEND_TIMEOUT=10000
#SQLNET.RECV_TIMEOUT=10000

# tnsnames.ora Network Configuration File: /opt/oracle/11g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TNSGWORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = freds-server.i-surname.co.uk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = GWORCL)
(SERVICE_NAME = GWORCL.i-surname.co.uk)
)
)

TNSPORCL30 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = home1.i-surname.co.uk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = PORCL30)
(SERVICE_NAME = PORCL30.i-surname.co.uk)
)
)


show parameters name

NAME                    TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name                string     GWORCL
db_unique_name               string     GWORCL
global_names               boolean FALSE
instance_name               string     GWORCL
lock_name_space           string
log_file_name_convert     string
service_names               string     GWORCL.i-surname.co.uk
db_domain               string     i-surname.co.uk
  • 1. Re: Listener working but not working for Enterprise manager oracle 11gr2 Linux.
    Neill_R Newbie
    Currently Being Moderated
    FYI if needed

    Show parameters %


    O7_DICTIONARY_ACCESSIBILITY     boolean     FALSE
    active_instance_count          integer
    aq_tm_processes           integer     0
    archive_lag_target          integer     0
    asm_diskgroups               string
    asm_diskstring               string
    asm_power_limit           integer     1
    asm_preferred_read_failure_groups string
    audit_file_dest           string     /opt/oracle/admin/GWORCL/adump
    audit_sys_operations          boolean     FALSE
    audit_syslog_level          string
    audit_trail               string     DB
    background_core_dump          string     partial
    background_dump_dest          string     /opt/oracle/diag/rdbms/gworcl/
                                  GWORCL/trace
    backup_tape_io_slaves          boolean     FALSE
    bitmap_merge_area_size          integer     1048576
    blank_trimming               boolean     FALSE
    buffer_pool_keep          string
    buffer_pool_recycle          string
    cell_offload_compaction      string     ADAPTIVE
    cell_offload_decryption      boolean     TRUE
    cell_offload_parameters      string
    cell_offload_plan_display     string     AUTO
    cell_offload_processing      boolean     TRUE
    cell_partition_large_extents     string     DEFAULT
    circuits               integer
    client_result_cache_lag      big integer 3000
    client_result_cache_size     big integer 0
    cluster_database          boolean     FALSE
    cluster_database_instances     integer     1
    cluster_interconnects          string
    commit_logging               string
    commit_point_strength          integer     1
    commit_wait               string
    commit_write               string
    compatible               string     11.2.0.0.0
    control_file_record_keep_time     integer     7
    control_files               string     /home/oracle/database/oradata/
                                  GWORCL/control01.ctl, /home/or
                                  acle/database/GWORCL/control02
                                  .ctl
    control_management_pack_access     string     DIAGNOSTIC+TUNING
    core_dump_dest               string     /opt/oracle/diag/rdbms/gworcl/
                                  GWORCL/cdump
    cpu_count               integer     2
    create_bitmap_area_size      integer     8388608
    create_stored_outlines          string
    cursor_sharing               string     EXACT
    cursor_space_for_time          boolean     FALSE
    db_16k_cache_size          big integer 0
    db_2k_cache_size          big integer 0
    db_32k_cache_size          big integer 0
    db_4k_cache_size          big integer 0
    db_8k_cache_size          big integer 0
    db_block_buffers          integer     0
    db_block_checking          string     FALSE
    db_block_checksum          string     TYPICAL
    db_block_size               integer     8192
    db_cache_advice           string     ON
    db_cache_size               big integer 0
    db_create_file_dest          string
    db_create_online_log_dest_1     string
    db_create_online_log_dest_2     string
    db_create_online_log_dest_3     string
    db_create_online_log_dest_4     string
    db_create_online_log_dest_5     string
    db_domain               string     i-surname.co.uk
    db_file_multiblock_read_count     integer     16
    db_file_name_convert          string
    db_files               integer     200
    db_flash_cache_file          string
    db_flash_cache_size          big integer 0
    db_flashback_retention_target     integer     1440
    db_keep_cache_size          big integer 0
    db_lost_write_protect          string     NONE
    db_name                string     GWORCL
    db_recovery_file_dest          string     /home/oracle/database
    db_recovery_file_dest_size     big integer 3852M
    db_recycle_cache_size          big integer 0
    db_securefile               string     PERMITTED
    db_ultra_safe               string     OFF
    db_unique_name               string     GWORCL
    db_writer_processes          integer     1
    dbwr_io_slaves               integer     0
    ddl_lock_timeout          integer     0
    deferred_segment_creation     boolean     TRUE
    dg_broker_config_file1          string     /opt/oracle/11g/dbs/dr1GWORCL.
                                  dat
    dg_broker_config_file2          string     /opt/oracle/11g/dbs/dr2GWORCL.
                                  dat
    dg_broker_start           boolean     FALSE
    diagnostic_dest           string     /opt/oracle
    disk_asynch_io               boolean     TRUE
    dispatchers               string     (PROTOCOL=TCP) (SERVICE=GWORCL
                                  XDB)
    distributed_lock_timeout     integer     60
    dml_locks               integer     1088
    dst_upgrade_insert_conv      boolean     TRUE
    enable_ddl_logging          boolean     FALSE
    event                    string
    fal_client               string
    fal_server               string
    fast_start_io_target          integer     0
    fast_start_mttr_target          integer     0
    fast_start_parallel_rollback     string     LOW
    file_mapping               boolean     FALSE
    fileio_network_adapters      string
    filesystemio_options          string     none
    fixed_date               string
    gcs_server_processes          integer     0
    global_context_pool_size     string
    global_names               boolean     FALSE
    global_txn_processes          integer     1
    hash_area_size               integer     131072
    hi_shared_memory_address     integer     0
    hs_autoregister           boolean     TRUE
    ifile                    file
    instance_groups           string
    instance_name               string     GWORCL
    instance_number           integer     0
    instance_type               string     RDBMS
    java_jit_enabled          boolean     TRUE
    java_max_sessionspace_size     integer     0
    java_pool_size               big integer 0
    java_soft_sessionspace_limit     integer     0
    job_queue_processes          integer     1000
    large_pool_size           big integer 0
    ldap_directory_access          string     NONE
    ldap_directory_sysauth          string     no
    license_max_sessions          integer     0
    license_max_users          integer     0
    license_sessions_warning     integer     0
    listener_networks          string
    local_listener               string
    lock_name_space           string
    lock_sga               boolean     FALSE
    log_archive_config          string
    log_archive_dest          string
    log_archive_dest_1          string
    log_archive_dest_10          string
    log_archive_dest_11          string
    log_archive_dest_12          string
    log_archive_dest_13          string
    log_archive_dest_14          string
    log_archive_dest_15          string
    log_archive_dest_16          string
    log_archive_dest_17          string
    log_archive_dest_18          string
    log_archive_dest_19          string
    log_archive_dest_2          string
    log_archive_dest_20          string
    log_archive_dest_21          string
    log_archive_dest_22          string
    log_archive_dest_23          string
    log_archive_dest_24          string
    log_archive_dest_25          string
    log_archive_dest_26          string
    log_archive_dest_27          string
    log_archive_dest_28          string
    log_archive_dest_29          string
    log_archive_dest_3          string
    log_archive_dest_30          string
    log_archive_dest_31          string
    log_archive_dest_4          string
    log_archive_dest_5          string
    log_archive_dest_6          string
    log_archive_dest_7          string
    log_archive_dest_8          string
    log_archive_dest_9          string
    log_archive_dest_state_1     string     enable
    log_archive_dest_state_10     string     enable
    log_archive_dest_state_11     string     enable
    log_archive_dest_state_12     string     enable
    log_archive_dest_state_13     string     enable
    log_archive_dest_state_14     string     enable
    log_archive_dest_state_15     string     enable
    log_archive_dest_state_16     string     enable
    log_archive_dest_state_17     string     enable
    log_archive_dest_state_18     string     enable
    log_archive_dest_state_19     string     enable
    log_archive_dest_state_2     string     enable
    log_archive_dest_state_20     string     enable
    log_archive_dest_state_21     string     enable
    log_archive_dest_state_22     string     enable
    log_archive_dest_state_23     string     enable
    log_archive_dest_state_24     string     enable
    log_archive_dest_state_25     string     enable
    log_archive_dest_state_26     string     enable
    log_archive_dest_state_27     string     enable
    log_archive_dest_state_28     string     enable
    log_archive_dest_state_29     string     enable
    log_archive_dest_state_3     string     enable
    log_archive_dest_state_30     string     enable
    log_archive_dest_state_31     string     enable
    log_archive_dest_state_4     string     enable
    log_archive_dest_state_5     string     enable
    log_archive_dest_state_6     string     enable
    log_archive_dest_state_7     string     enable
    log_archive_dest_state_8     string     enable
    log_archive_dest_state_9     string     enable
    log_archive_duplex_dest      string
    log_archive_format          string     %t_%s_%r.dbf
    log_archive_local_first      boolean     TRUE
    log_archive_max_processes     integer     4
    log_archive_min_succeed_dest     integer     1
    log_archive_start          boolean     FALSE
    log_archive_trace          integer     0
    log_buffer               integer     6463488
    log_checkpoint_interval      integer     0
    log_checkpoint_timeout          integer     1800
    log_checkpoints_to_alert     boolean     FALSE
    log_file_name_convert          string
    max_dispatchers           integer
    max_dump_file_size          string     unlimited
    max_enabled_roles          integer     150
    max_shared_servers          integer
    memory_max_target          big integer 0
    memory_target               big integer 0
    nls_calendar               string
    nls_comp               string     BINARY
    nls_currency               string
    nls_date_format           string
    nls_date_language          string
    nls_dual_currency          string
    nls_iso_currency          string
    nls_language               string     ENGLISH
    nls_length_semantics          string     BYTE
    nls_nchar_conv_excp          string     FALSE
    nls_numeric_characters          string
    nls_sort               string
    nls_territory               string     UNITED KINGDOM
    nls_time_format           string
    nls_time_tz_format          string
    nls_timestamp_format          string
    nls_timestamp_tz_format      string
    object_cache_max_size_percent     integer     10
    object_cache_optimal_size     integer     102400
    olap_page_pool_size          big integer 0
    open_cursors               integer     300
    open_links               integer     4
    open_links_per_instance      integer     4
    optimizer_capture_sql_plan_baselines boolean     FALSE
    optimizer_dynamic_sampling     integer     2
    optimizer_features_enable     string     11.2.0.1
    optimizer_index_caching      integer     0
    optimizer_index_cost_adj     integer     100
    optimizer_mode               string     ALL_ROWS
    optimizer_secure_view_merging     boolean     TRUE
    optimizer_use_invisible_indexes boolean     FALSE
    optimizer_use_pending_statistics boolean     FALSE
    optimizer_use_sql_plan_baselines boolean     TRUE
    os_authent_prefix          string     ops$
    os_roles               boolean     FALSE
    parallel_adaptive_multi_user     boolean     TRUE
    parallel_automatic_tuning     boolean     FALSE
    parallel_degree_limit          string     CPU
    parallel_degree_policy          string     MANUAL
    parallel_execution_message_size integer     16384
    parallel_force_local          boolean     FALSE
    parallel_instance_group      string
    parallel_io_cap_enabled      boolean     FALSE
    parallel_max_servers          integer     40
    parallel_min_percent          integer     0
    parallel_min_servers          integer     0
    parallel_min_time_threshold     string     AUTO
    parallel_server           boolean     FALSE
    parallel_server_instances     integer     1
    parallel_servers_target      integer     16
    parallel_threads_per_cpu     integer     2
    permit_92_wrap_format          boolean     TRUE
    pga_aggregate_target          big integer 1172M
    plscope_settings          string     IDENTIFIERS:NONE
    plsql_ccflags               string
    plsql_code_type           string     INTERPRETED
    plsql_debug               boolean     FALSE
    plsql_optimize_level          integer     2
    plsql_v2_compatibility          boolean     FALSE
    plsql_warnings               string     DISABLE:ALL
    pre_page_sga               boolean     FALSE
    processes               integer     150
    query_rewrite_enabled          string     TRUE
    query_rewrite_integrity      string     enforced
    rdbms_server_dn           string
    read_only_open_delayed          boolean     FALSE
    recovery_parallelism          integer     0
    recyclebin               string     on
    redo_transport_user          string
    remote_dependencies_mode     string     TIMESTAMP
    remote_listener           string
    remote_login_passwordfile     string     EXCLUSIVE
    remote_os_authent          boolean     FALSE
    remote_os_roles           boolean     FALSE
    replication_dependency_tracking boolean     TRUE
    resource_limit               boolean     FALSE
    resource_manager_cpu_allocation integer     2
    resource_manager_plan          string
    result_cache_max_result      integer     5
    result_cache_max_size          big integer 832K
    result_cache_mode          string     MANUAL
    result_cache_remote_expiration     integer     0
    resumable_timeout          integer     0
    rollback_segments          string
    sec_case_sensitive_logon     boolean     TRUE
    sec_max_failed_login_attempts     integer     10
    sec_protocol_error_further_action string     CONTINUE
    sec_protocol_error_trace_action string     TRACE
    sec_return_server_release_banner boolean     FALSE
    serial_reuse               string     disable
    service_names               string     GWORCL.i-surname.co.uk
    session_cached_cursors          integer     50
    session_max_open_files          integer     10
    sessions               integer     248
    sga_max_size               big integer 160M
    sga_target               big integer 160M
    shadow_core_dump          string     partial
    shared_memory_address          integer     0
    shared_pool_reserved_size     big integer 5M
    shared_pool_size          big integer 0
    shared_server_sessions          integer
    shared_servers               integer     1
    skip_unusable_indexes          boolean     TRUE
    smtp_out_server           string
    sort_area_retained_size      integer     0
    sort_area_size               integer     65536
    spfile                    string     /opt/oracle/11g/dbs/spfileGWOR
                                  CL.ora
    sql92_security               boolean     FALSE
    sql_trace               boolean     FALSE
    sqltune_category          string     DEFAULT
    standby_archive_dest          string     ?/dbs/arch
    standby_file_management      string     MANUAL
    star_transformation_enabled     string     FALSE
    statistics_level          string     TYPICAL
    streams_pool_size          big integer 0
    tape_asynch_io               boolean     TRUE
    thread                    integer     0
    timed_os_statistics          integer     0
    timed_statistics          boolean     TRUE
    trace_enabled               boolean     TRUE
    tracefile_identifier          string
    transactions               integer     272
    transactions_per_rollback_segment integer     5
    undo_management           string     AUTO
    undo_retention               integer     900
    undo_tablespace           string     UNDOTBS1
    use_indirect_data_buffers     boolean     FALSE
    user_dump_dest               string     /opt/oracle/diag/rdbms/gworcl/
                                  GWORCL/trace
    utl_file_dir               string
    workarea_size_policy          string     AUTO
    xml_db_events               string     enable
    SQL>
  • 2. Re: Listener working but not working for Enterprise manager oracle 11gr2 Linux.
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Restart Agent if its not working use
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create
  • 3. Re: Listener working but not working for Enterprise manager oracle 11gr2 Linux.
    Neill_R Newbie
    Currently Being Moderated
    Thank you! Your solution worked purfectly. Thank you also for the advice I see you giving to others. Best Wishes

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points