In Oracle, how we can make database file?

Connecting MySQL to Oracle 11g on Windows-7 Home Premium 64-bit Machine?

• I'm trying to make a connection to MySQL database from Oracle. Oracle database runs on windows 7 64 bit machine and version is 11.1.0 my init<dname>, listner and tnsnames looks like this.. SystemDSN: mysql1 initmysql1.ora ------------------------------------ # This is a sample agent init file that contains the HS parameters that are # needed for the Database Gateway for ODBC HS_FDS_CONNECT_INFO = mysql1 HS_FDS_TRACE_LEVEL = OFF listener.ora --------------------------------------… # listener.ora Network Configuration File: C:\app\Administrator\product\11.1.0\db_1… # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (PROGRAM = extproc) (SID_NAME = orcl) (ORACLE_HOME = C:\app\Administrator\product\11.1.0\db_1… ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Abhi-HP)(PORT = 1521)) ) ) SID_LIST_LISTENERmysql1 = (SID_LIST = (SID_DESC = (SID_NAME = mysql1) (ORACLE_HOME = C:\app\Administrator\product\11.1.0\db_1… (PROGRAM = extproc) ) ) LISTENERmysql1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = PNPKEY)) (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1524)) ) ) tnsnames.ora ----------------------------------- # tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.1.0\db_1… # Generated by Oracle configuration tools. ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Abhi-HP)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1524)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) mysql1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST=localhost) (PORT=1524)) (CONNECT_DATA = (SID = mysql1)) (HS=OK) ) Listener Status --------------------------------- C:\>lsnrctl status mysql1 LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 13-MAY-2012 18:51 :06 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOS… ONNECT_DATA=(SID=mysql1))(HS=OK)) STATUS of the LISTENER Alias LISTENERmysql1 Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ ction Start Date 13-MAY-2012 17:54:03 Uptime 0 days 0 hr. 57 min. 5 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File C:\app\Administrator\product\11.1.0\db_1… Listener Log File c:\app\administrator\diag\tnslsnr\Abhi-H… Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(P… (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(H… Services Summary... Service "mysql1" has 1 instance(s). Instance "mysql1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfuly Then I created database link as create database link mysql1link2 connect to root identified by 1234 using 'mysql1'; Then I tried a query SQL> desc customer@mysql1link2; ERROR: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from mysql1link2

• Answer:

  Yahoo truncated much of the text you pasted in, so it's hard to diagnose where the problem lies. See link for a discussion and possible solutions to a similar problem, and check your listener.ora file to make sure you have the correct value of ORACLE_HOME.