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
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks