The data source alias, hostname/IP, port, and database service name in the tnsnames.ora should be modified appropriately. If the TNS entries in the ORACLE_HOME\network\admin\tnsnames.ora file are not recognized by the Oracle client, create a ORACLE_HOME\oracle.key file using any text editor and type in the following line:
download oracle 9i database windows xp
Viewed 100K+ times! This question is You Asked i'm running oracle on standalone computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i do?please help.. (scott/tiger) and Tom said...sounds like the database is not up. you probably restarted your machine and the instance is not set to autostartC:\Documents and Settings\tkyte>sqlplus scott/tigerSQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsscott%ORA10GR1> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsC:\Documents and Settings\tkyte>net stop oracleserviceora10gr1The OracleServiceORA10GR1 service is stopping.........The OracleServiceORA10GR1 service was stopped successfully.C:\Documents and Settings\tkyte>sqlplus scott/tigerSQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.ERROR:ORA-12560: TNS:protocol adapter errorEnter user-name:ERROR:ORA-12560: TNS:protocol adapter errorEnter user-name:ERROR:ORA-12560: TNS:protocol adapter errorSP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*PlusC:\Documents and Settings\tkyte>net start oracleserviceora10gr1The OracleServiceORA10GR1 service is starting..........The OracleServiceORA10GR1 service was started successfully.C:\Documents and Settings\tkyte>sqlplus scott/tigerSQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsscott%ORA10GR1>in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Rating (129 ratings)Is this answer out of date? If it is, please let us know via a Comment Comments Comment Another methodArangaperumal G, September 10, 2007 - 3:15 am UTC
Hello Room,I am using Phprunner 5.3 build 7474 with Oracle 9i database on Windows xp. My problem is that I upload a pdf file which is around 10 kb in size. I uploaded such several files. They all get uploaded ok. but the problem is starting when i visit list view and try to download the same file. it is not showing me the file name but instead of filename a "download.php" file is trying to get downloaded. I am stumped. As this problem is with certain files only and not all.Please let me know what is the problem. I need to do this urgently.Please help me.
Hello Room,Anybody, Please help me. This is urgent. I have uploaded .doc files now, some of the files I am able to download but for some files it is showing error as given below and is downloading download.php. What I am perplexed is that why is it downloading some of the word files as it is and why not other is in question. when i opened the downloaded file download.php in word i see below file as image and the screenshot of which I am copying below.Error type 2Error description feof() expects parameter 1 to be resource, boolean givenURL 192.168.1.214/srm/download.php?table=Copy_of_SCOTT_CHALPRODSRM&field=FILENAME&key1=19&key2=&key3=&key4=I0697Error file H:\xampp\htdocs\srm\include\phpfunctions.phpError line 190SQL query SELECT "CO", "CODE", "DOCNO", "ITEMID", "FILENAME", "CUSTID", "GRN", "PARTYINVNO", "HODEKFILENAME", "QTY" FROM SCOTT.CHALPRODSRM where (CO=19 and CODE is null and DOCNO is null and ITEMID='I0697') and (CUSTID='A2038') Anybody, Please help me, I am really desperate to go through this.Thank you in advance.Hello Room,I am using Phprunner 5.3 build 7474 with Oracle 9i database on Windows xp. My problem is that I upload a pdf file which is around 10 kb in size. I uploaded such several files. They all get uploaded ok. but the problem is starting when i visit list view and try to download the same file. it is not showing me the file name but instead of filename a "download.php" file is trying to get downloaded. I am stumped. As this problem is with certain files only and not all.Please let me know what is the problem. I need to do this urgently.Please help me.
The minimum kernel parameter values recommended by Oracle to run Oracle 9i and 10g with a single database instance on Linux can be set using the orarun*.rpm package referred to in the above Novell documents. You can download this package from: -9/ 2ff7e9595c
Comments