-
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
-
You need an equal sign in you sqlnet.ora parameter:
Code:
sqlnet.authentication_services = (ALL)
-
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
-
why do you have it set to ALL?
-
I was testing someting.
Are you saying that's why I'm getting that error?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|