Listener startup's error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Listener startup's error

Hybrid View

  1. #1
    Join Date
    May 2006
    Posts
    12

    Listener startup's error

    Hi

    I've created a database manually on 10gR2 on Fedora Core 4.
    When I try to start listener, I get this error:


    Starting /u01/app/oracle/product/10.2.0/oraHome/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 10.2.0.1.0 - Production
    System parameter file is /u01/app/oracle/product/10.2.0/oraHome/network/admin/listener.ora
    Log messages written to /u01/app/oracle/product/10.2.0/oraHome/network/log/listener.log
    Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    TNS-12560: TNS: protocol adapter error
    TNS-00583: Valid node checking: unable to parse configuration parameters


    Listener failed to start. See the error message(s) above...


    I'm not connecting to the server remotely and here is my listener.ora:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.16)(PORT=1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = testDb)
    (ORACLE_HOME = /u01/app/oracle/product/10.2.0/oraHome)
    )
    )

    and sqlnet.ora (just in case):

    sqlnet.authentication_services(ALL)

    and also the PFILE:

    testDb.__db_cache_size=67108864
    testDb.__java_pool_size=4194304
    testDb.__large_pool_size=4194304
    testDb.__shared_pool_size=88080384
    testDb.__streams_pool_size=0
    *.audit_file_dest='/u01/app/oracle/admin/testDb/adump'
    *.background_dump_dest='/u01/app/oracle/admin/testDb/bdump'
    *.compatible='10.2.0.1.0'
    *.control_files='/u01/app/oracle/oraData/testDb/control01.ctl','/u01/app/oracle/oraData/testDb/control02.ctl','/u01/app/oracle/oraData/testDb/control03.ctl'
    *.core_dump_dest='/u01/app/oracle/admin/testDb/cdump'
    *.db_block_size=8192
    *.db_domain='TestSys'
    *.db_file_multiblock_read_count=16
    *.db_name='testDb'
    testDb.instance_name='testDb'
    *.open_cursors=300
    *.pga_aggregate_target=16777216
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=167772160
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS'
    *.user_dump_dest='/u01/app/oracle/admin/testDb/udump'


    Any Idea, please?

    Thanks in advance
    Amir Gheibi

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    You need an equal sign in you sqlnet.ora parameter:

    Code:
    sqlnet.authentication_services = (ALL)

  3. #3
    Join Date
    May 2006
    Posts
    12
    ebrian,

    Thanks, Now I can start the Listener. (Oh god, that was so obviouse!)

    But I got another problem when I tried to login with the sys user like this:
    "sys@testDb as sysdba"

    The error is:

    ORA-12641: Authentication service failed to initialize

    I turned on sqlnet tracing by adding the lines bellow to the sqlnet.ora:

    TRACE_TIMESTAMP_SERVER = ON
    TRACE_LEVEL_SERVER = 16
    TRACE_UNIQUE_SERVER = ON

    and what I found in the Trace file was:

    /u01/app/oracle/admin/testDb/udump/testdb_ora_13823.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /u01/app/oracle/product/10.2.0/oraHome
    System name: Linux
    Node name: TestSys
    Release: 2.6.11-1.1369_FC4
    Version: #1 Thu Jun 2 22:55:56 EDT 2005
    Machine: i686
    Instance name: testDb
    Redo thread mounted by this instance: 1
    Oracle process number: 15
    Unix process pid: 13823, image: oracletestDb@TestSys

    opiino: Attach failed! error=-1 ifvp=(nil)

    I can login with OS user as sysdba (/ as sysdba). So I think it's about the sys user.
    I use password file. I've even created it again. Didn't work.

    Dose anyone underestand anything from that error?

    Thanks in Advance
    Amir Gheibi

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why do you have it set to ALL?

  5. #5
    Join Date
    May 2006
    Posts
    12
    I was testing someting.
    Are you saying that's why I'm getting that error?

  6. #6
    Join Date
    May 2006
    Posts
    12
    It is the reason.
    You are right.

    Thanks

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