Connect To 10g After Patch Set 3

Mar 24, 2011

Had 10.2.0.3 on Win Server 2003 and ran patch set 3. Now have 10.2.0.4 but cannot login. Here is what I get along with other info.
-------
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 24 14:27:31 2011
Copyright © 1982, 2007, Oracle. All Rights Reserved.

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.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = W2K3-TX-ORA)(PORT = 1521))
)
)
-----------
Running TNSPING:

C:\oracle\product\10.2.0\db_1\network\ADMIN>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 24-MAR-2011 14:35:35
Copyright © 1997, 2007, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = W2K3-TX-ORA)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= ORCL)))
OK (60 msec)

View 3 Replies


ADVERTISEMENT

Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer

Jul 7, 2012

I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....

sqlplus username/password@IPAddress:port/ServiceName

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.

View 3 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

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?

View 2 Replies View Related

How To Patch Oracle 11g

Apr 19, 2012

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?

View 6 Replies View Related

CPU Patch Apply

Jun 17, 2012

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.

View 4 Replies View Related

PSU Patch While Dbupgrade From 11.2.0.1 To 11.2.0.3

Oct 21, 2012

Version : 11.2.0.1
Os : Aix 6

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.

root@ppseelm-ax2041:/u01/app/oracle/11.2.0.3/product/ginfra/grid_home/OPatch: ra/grid_home/OPatch/ocm/bin/ocm.rsp <
Executing /usr/bin/perl ./crs/patch112.pl -patchdir /backup/11203_softwares -patchn patch -ocmrf /u01/app/oracle/11.2.0.3/product/ginfra/grid_home/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/oracle/11.2.0.3/product/ginfra/grid_home/crs/install/crsconfig_params
opatch auto log file location is /u01/app/oracle/11.2.0.3/product/ginfra/grid_home/OPatch/crs/../../cfgtoollogs/opatchauto2012-10-21_10-39-53.log
Detected Oracle Restart install
[code]....

View 7 Replies View Related

Patch 11.2.0.4 Windows 8

Nov 20, 2012

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?

View 5 Replies View Related

Web Service On Forms 6i (Patch 17)

Oct 16, 2010

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?

View 1 Replies View Related

Oracle Patch Not Successful?

Dec 20, 2010

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

View 2 Replies View Related

Server Administration :: One-off Patch?

Jan 24, 2012

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

Or any other best practive

View 1 Replies View Related

Security :: How To Identify Patch No

Apr 12, 2013

Quote:Every patch or patch set also has a patch number to identify it

All patch and patch set releases carry version numbers.

For ex : Oracle 10g Release 10.2.0.1, then an available patch set might be 10.2.0.2 , .... , 10.2.4.0 , 10.2.5.0

My QUES is : How can i identify Patch no ? How it is differ from patchsets no ?..

View 27 Replies View Related

Latest Critical Patch Update?

Oct 14, 2010

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.

View 1 Replies View Related

Apply 11.2.0.2 Database Server Patch In EBS 12i Env?

Jul 20, 2012

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?

View 2 Replies View Related

Windows :: How To Find Oracle Patch

Apr 20, 2012

how can i find the oracle patch on os window. oracle 10.2.0.1

i m using sql>opatch lsinventory but cant work.

View 10 Replies View Related

Server Administration :: Oracle 10.2.0.5 Patch

Aug 19, 2010

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?

View 2 Replies View Related

Server Administration :: 11.2.0.2.3 GI Patch Set Update?

Sep 12, 2011

I installed oracle 11.2.0.2 RAC and want to apply the PSU patch. I would like to know whether its better to apply the April 2011 PSU or July release.

View 1 Replies View Related

Patch 13923804 Warnings When Applied

Jul 26, 2012

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.

Stderr output:

ld: 0711-224 WARNING: Duplicate symbol: p_xargc
ld: 0711-224 WARNING: Duplicate symbol: p_xargv
ld: 0711-224 WARNING: Duplicate symbol: .kghalf
ld: 0711-224 WARNING: Duplicate symbol: .kghalp
ld: 0711-224 WARNING: Duplicate symbol: .bcopy
ld: 0711-224 WARNING: Duplicate symbol: .kghgrw
ld: 0711-224 WARNING: Duplicate symbol: .kghfrf

[code]....

OPatch completed with warnings.

As they are harmless ? Whether I need to rollback ?

View 2 Replies View Related

Installation :: Where To Download Patch 8350262

May 17, 2013

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.

View 2 Replies View Related

Server Administration :: Applying Patch (10.2.0.1.0 To 10.2.0.4.0)

May 19, 2011

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?

View 1 Replies View Related

Patch And Non-Standard Block Size

Apr 14, 2013

1) When might one choose non-standard block sizes?
2) Why do we need to apply patch? Just to fix bugs?

View 3 Replies View Related

Upgrade :: Applying Patch Set Update 11.2.0.3.7 On 11.2.0.3.0

Aug 18, 2013

Database = 11.2.0.3.0

Operating System : Solaris 11 sparc 64.

applying PSU patch : 16619892

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.

[Code].....

View 8 Replies View Related

Oracle Critical Patch Update

Jul 18, 2012

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

View 3 Replies View Related

Oracle Client 10g - How To Install Patch 4923768

Nov 17, 2010

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.

View 7 Replies View Related

Restoring Oracle Home Patch Fails

Apr 29, 2011

[URL]......

The oracle documents mentions this file

$ORACLE_HOME/.patch_storage/<patch-id_timestamp>/restore.sh

But what I find in that directory is

$ORACLE_HOME/.patch_storage/<patch-id_timestamp>/rolback.sh

Where is the restore.sh file that the document is talking about.

View 1 Replies View Related

Forms :: Download Patch 17 For Oracle Developer 6i

May 20, 2005

i want to download the patch 17 for oracle developer 6i for. any link that i can download this patch from it?

View 5 Replies View Related

RAC & Failsafe :: 11.2.0.2 Patch For Oracle 11gR2 RAC Cluster?

Sep 29, 2010

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

Which option should I have to choose here ?

View 1 Replies View Related

Server Administration :: Download Patch Documentation?

Oct 27, 2011

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?

View 6 Replies View Related

Server Administration :: Apply Oracle Patch 10.2.0.5?

Nov 22, 2010

I want to upgrade 10.2.0.1 to 10.2.0.5.

Can I straightly apply 10.2.0.5 or need to sequentially apply one by one?

View 2 Replies View Related

Server Administration :: Apply 11.1.0.7 Patch Set On 10.2.0.3 Database?

Mar 25, 2010

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

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved