ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
--------
My listener service is running. Listener.ora is:
---------
# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit) Delphi 2010 Professional Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. The error I keep getting is:
Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.
Here's what I've done:
1. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator. - Data source name: bt_user - TNS Server Name: localhost/xe - user bt_user - Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC) - Set database name to "bt_user". - Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form. - Select "connection string" and open the dialog. - Click "build string". - Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection. - In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1) - Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
I've been told by management this weekend I will be required to perform a complete patch of our Oracle 11g database.
Problem is I really have never installed / patched Oracle. I'm able to access pretty much any database here and interact with it from a SQL stand point so since I'm the only person in my entire office who knows SQL, they decided I can become their full blow DBA.
Currently the database is running a unpatched version:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Once I download the latest patch (11.2.0.2.0) files from Oracle & perform a complete backup using RMAN:
RMAN> backup full as compressed backupset database plus archivelog;
How exactly does one properly patch / update Oracle 11g to the latest version?
Does we need to apply the patches in sequence. i installed oracle 11g r2 today only, then which patch i can install. if i like to install CPU, then does i need to install all the previous or only the latest one. if only latest one only, then how can i find the CPU patch number.
of course, instead of cpu i can install psu patch, then which one has to install. only latest one or all previous also. if latest one only how to find latest psu patch that has to apply.
We recently upgraded from 11.2.0.1 to 11.2.0.3.We completed db upgrade sucessfully. We got the follwoing error While applying PSU patch. It shows the patch 13923374 failed.But when i check in opatch lsinventory,it shows that patch is applied.
I read on the oracle site that Windows 8 support will come with Oracle version 11.2.0.4 and higher. Without a maintenance contract I see only 11.2.0.3. What version of Oracle is now the latest, is patch 11.2.0.4 out?
I have a "pure" client / server environment with forms/reports 6i (NO form server architecture) and my necessity is to retrieve data from Web Service Call within Forms.
Do you have any simple example for realize this? Javaimporter is the right solution or not?
I am trying to patch 10.2.0.3 to 10.2.0.5.I run the runInstaller, it was not successful because it was pointing to a wrong home name and path.Then I changed according to working condition. Then the installation was successful.Then I run the catupgrd.sql. It was also successful with no errors.Then I run utlrp.sql, it was also successful with no error.I did a shutdown and startup.
When I query: select * from v$version;
It is giving the output as the oldversion as 10.2.0.3
I am reffering to one off patch "10402264" .I have to apply tihs patch to my 11.2.0.2.4 database.Is there any chart oracle provide to check if 10402264 is covered in any PSUs? or i have to go to each PSU readme and check "Bugs fixed" ?
i wish i could get somthing like this
11.2.0.2 One-off# PSU4 PSU5 11.2.0.3.0 10402264 NO YES YES
identify the latest Critical Patch Update for 10g RAC. My DB server is 10g RAC 2 node cluster running on IBM Aix Pseries servers. The version is 10.2.0.3.
We need to apply the the 11.2.0.2 database server patch and this is a 12i Ebusiness suite env. Do we need to take any precautions(other than stopping the apps) on the APPS side when we are applying the patch on the database?
We're thinking of moving from 10.2.0.3 to 10.2.0.5 in our production Oracle RAC. The 10.2.0.5 patch is quite new and I was wondering if any of you have upgraded to this patch in any of your environments and if you experienced any issues afterwards?
I applied this patch in our development environment. After validation, I need to apply the same in production, training and publication environments. The detailed information follows :
PowerPC_POWER5 / aix 5300-12 OPatch utility used : 11.2.0.3.0 OUI version : 11.2.0.2.0 Prereq "checkConflictAgainstOHWithDetail" passed. Composite patch 13923804 successfully applied. OPatch Session completed with warnings.
I encountered problems when installing Oracle 11g. The problem comes from Enterprise Manager. After searching online, I find there is an official solution path patch 8350262 for this. But I cannot find how to download or get that patch.
I installed Oracle 10.2.0.1.0 in RH Linux 4.5. After that applied patch for 10.2.0.4.0. Everything went smoothly, but at the last steps I unknowingly clicked next button. I dont know whether some scripts is to be run as I did during installation of 10.1.0.4.0. If it is to be done I didn't do that.
How can I proceed now? If some scripts to be run where is the location? Will it cause any issue if I running it after completing the update?
I am trying to apply patch 16619892 on 11.2.0.3.0 to upgrade it to 11.2.0.3.7.
I hope this is a straight forword stuff i beleive, but i am getting the following errors and log details.
$ cd /noracle/patch/16619892/ xxxx@xxxx$ /noracle/home/oracle/product/11.2.0.3/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved.
I need to apply this Critical Patch in my databases but I have a doubt about if the component that I find out in the documentation is the component where the fix has to be applied or doesn't matter and I have to apply this fix on all my installations.
CVE# Component
CVE-2012-1740 - Oracle Application Express Listener CVE-2011-3192 - Apache CVE-2012-1737 - Enterprise Manager for Oracle Database CVE-2012-1745 - The vulnerability affects Microsoft Windows platforms only. CVE-2012-1746 - The vulnerability affects Microsoft Windows platforms only. CVE-2012-1747 - The vulnerability affects Microsoft Windows platforms only. CVE-2012-3134 - The vulnerability affects Microsoft Windows platforms only. CVE-2011-4885 - PHP
I have installed Crystal reports server 2008 VI on a Windows 2008 64bit OS. I have added Crystal reports that connects to Oracle database through CMC. I then installed Oracle 10g client 32bit on the server and created and tested the required DSNs using ODBC 32bit. All the testings are successfull.
Now when I try to run my Oracle report through CMC it prompts for the parameters and when I enter them and click ok, gives me the following error: Failed to open the connection. Details: Database Vendor 12154.
I reported the above issue to SAP and they mentioned that this is a bug with Oracle and install the latest patch for my Oracle client software. My current Oracle client 10g 32bit version is: 10.2.0.1.0
I downloaded the patch 4923768 for Oracle client 10g. In the installation instructions, it mentions to apply the patch using OPatch. I already see the OPath folder in the C:\oracle\product\10.2.0\client_1 directory, but I am not sure how to enter the command to apply the patch using OPatch. Do I have to do it using DOS window or any other tool? I don't have an Oracle admin in our company, so I am trying to figure out how to apply this patch on client workstations.
Yesterday I was installing 11.2.0.2 patch to our Oracle 11gR2(11.2.0.1.0) Two node RAC cluster on OEL 5.4 x86 Linux.Before installing I have read [URL] support note which says "Note: All Oracle Grid Infrastructure patch set upgrades must be out-of-place upgrades, in which you install the patch set into a new Grid home. In-place patch set upgrades are not supported. "
During Installation I found following Installation Option :
1) Install and configure Oracle grid Infrastructure for a cluster
2) Configure Oracle Grid Infrastructure for a Standalone Server
3) Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management
4) Install Oracle Grid Infrastructure Software Only
where i can download the patch documentation. Is it available in the metalink (my oracle support)? if yes then is there any other way i can get hold of it?
can we apply 11.1.0.7 Patch Set on a 10.2.0.3 database server? i mean are patch sets cumulative or do i have to install the patch specific to my release the issue is i have the below error with rman: RMAN-03009: failure of delete command on ORA_DISK_1 channel at ORA-19633: control file record is out of sync with recovery catalog