|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Client cannot connect to Oracle10g
I have installed Oracle 10g on redhat 2.1asu4. everything seems to be working, but once i try an odbc connect for a windows client, i get the ora-12541 error. when i run the lsnrctl i get the following, which it seems that my instance is up.
LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 19-MAY-2004 13:15:01 Copyright (c) 1991, 2004, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lbqoracle)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.1.0.2.0 - Production Start Date 19-MAY-2004 09:50:34 Uptime 0 days 3 hr. 24 min. 27 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/oracle/product/10.1.0/db_1/network/admin/listener.ora Listener Log File /home/oracle/product/10.1.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lbqoracle)(PORT=8080))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lbqoracle)(PORT=2100))(Presentation=FTP)(Session=RAW)) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "test" has 1 instance(s). Instance "test", status READY, has 1 handler(s) for this service... Service "testXDB" has 1 instance(s). Instance "test", status READY, has 1 handler(s) for this service... The command completed successfully The instance "test" is what im trying to connect to. Here are my other network files. I am on a network without dns with static ip's. Note-I have tried changing the hostnames with ip's in these network files and it still doesnt work. tnsnames.ora # tnsnames.ora Network Configuration File: /home/oracle/product/10.1.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = lbqoracle)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) ) listener.ora # listener.ora Network Configuration File: /home/oracle/product/10.1.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home/oracle/product/10.1.0/db_1) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = lbqoracle)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) Any help would be appreciated. Thanks |
|
#2
|
|||
|
|||
|
this is WAY off in left field and from Oracle 8 but.....
ORA-12451 format mask for TO_LABEL or TO_CHAR function is invalid Cause: The format mask that you specified did not contain valid format codes for label conversion. Action: Check the Trusted Oracle7 Administrator's Guide for valid format codes. Correct the format mask and reattempt the operation. http://www.csee.umbc.edu/help/oracl...7785/e12400.htm you may try typing oerr ORA 12451 at the cmd prompt... from a 9i instance so there may be something wrong with the application. 12451, 00000, "label not designated as USER or DATA" // *Cause: A label is either a DATA label, a USER label, or both DATA and // USER. // *Action: Enter TRUE for at least DATA or USER. |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Client cannot connect to Oracle10g |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|