erros when i connect to my database [message #336583] |
Mon, 28 July 2008 05:10 |
alwosaby
Messages: 26 Registered: November 2007
|
Junior Member |
|
|
I install oracle10g on Unbreakable oracle RHEL5.2.
after that I type some comands to make testing for my database by tnslsnr or tnsping or lsnctrl
the document contains all errors
[oracle@sameer ~]$ lsnrctl
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2008 23:33:20
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting /u01/app/oracle/product/oracle10g/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
L
SNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL> quit
[oracle@sameer ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 26 23:34:45 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@sameer ~]$ tnsping mydb
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2008 23:36:02
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/oracle10g/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
[oracle@sameer ~]$ tnslsnr
Unable to resolve address for localhost:6113
ONS runtime exiting
[oracle@sameer ~]$
|
|
|
|
|
|
|