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:
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:
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
Version: #1 Thu Jun 2 22:55:56 EDT 2005
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.