Well - that's your problem isn't it? This is what I said The hostname, port or SID/SERVICE_NAME you are using are wrong or you don't have that host name in your hosts file. Oddly I have another connect which uses localhost, & I get an Error 12505 on that one - tns does not the SID -Ĭonnection Type: BasicHostname: oracleexpresssid: xe./etc/hosts:27.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 I have another connect which uses localhost, & I get an Error 12505 on that one - tns does not the SID. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0Ģ7.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 Mar 01 00:21:24 oracleexpress su: (to oracle) root on none Mar 01 00:21:24 oracleexpress oracle-xe: Starting Oracle Database 11g Express Edition instance. Mar 01 00:21:21 oracleexpress su: (to oracle) root on none Mar 01 00:21:21 oracleexpress oracle-xe: Starting Oracle Net Listener. Process: 1789 ExecStart=/etc/rc.d/init.d/oracle-xe start (code=exited, status=0/SUCCESS) Loaded: loaded (/etc/rc.d/init.d/oracle-xe bad vendor preset: disabled)Īctive: active (exited) since Wed 00:21:32 EST 2 days ago rvice - SYSV: This is a program that is responsible for taking care of I am able to ping the hostname of the box. Where do I check the TNSListener configuration - trying to find this in Oracle Docs now. I get an error when trying to establish a connection from SQL Developer - this has previously worked.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |