RAC & Failsafe :: Oracle Asm Packages For RHEL5.3 32 Bit?
Jul 3, 2011I am unable to locate the asm packages for rhel 5 :2.6.8-128 kernel of 32 bit.
Only 64 bit rpm are availbale on OTN.Can ayone suggeet me the URL for 32 bit>
ADVERTISEMENT
Enterprise Manager :: Oracle 11g R2 On RHEL5
Jul 23, 2010I have installed Oracle 11g R2 on the RHEL 5 platform. Once the installtion is complete we need to run two scripts:
1: orainstRoot.sh
2: root.sh
As the root user.When we run the root.sh script is ask us to overwrite three variables yes/no? we did yes.After Running these scripts we opened the database, tried to run listner as well, everything is running fine but when we are trying to run the Emterprise Manager using command:
emctl start dbconsole
we are prompted with a path to check the logs
/u01/app/oracle/product/11.2.0/db_1/localhost_orcl11g/sysman/log
I do not know which file I have to check.What could be the reason we are not able to run the EM.I need it urgently as we ahve to generate the AWR reports for the client.
Server Administration :: Upgrade Oracle 9.2.0.1.0 From RHEL4 Platform To Oracle 11g Rel 2 On RHEL5 Platform
Feb 4, 2012Can I directly upgrade Oracle 9.2.0.1.0 From RHEL-4 platform to Oracle 11g Rel 2 on RHEL -5 platform?I have the export dump and cold backup of Oracle 9.2.0.1.0 database.
View 11 Replies View RelatedServer Administration :: How To Spot Which Oracle Packages Are Installed / Licensed
Feb 22, 2011I need to figure out which Oracle Database packages are installed on a certain server.
First problem: no Enterprise Manager available. So I need some command line tools or SQL statements.
I've already found some with them I was able to spot RAC, partitioning and so on. But I'm still missing a option/command to spot
- diagnistic pack
- tuning pack
- web logic
- web server
Upgrading RHEL3 To RHEL5 Is Not Possible
Sep 23, 2011I have a virtual Linux RHEL 3 server with Oracle 9.2.0.8 DB running on VMWare. Now I need to update Linux to RHEL 5 and oracle to 11R2.upgrading RHEL 3 to RHEL 5 is not possible, so I need to install a new RHEL 5 server.
My plan is to install a new virtual server with RHEL 5and Oracle 11R2 in it. And then migrate DB there.What would be the easiest/fastest/safest way to do this? I would prefer using the DBUA method because of simplicity and my knowledge of Oracle :-)
I already tested this certainly unsupported scenario and it seemed to work:
I was unable to install Oracle 9 to RHEL 5 (not supported on RHEL5). So I just shutdown the DB on old environment and just copied everything related to Oracle from old RHEL 3 server to same locations on new RHEL 5 server. The DB started up just fine on RHEL 5 server.
So now as I had Oracle 9 DB running in RHEL 5 and also Oracle 11R2 binaries installed, I just followed DBUA instructions to do the upgrade and it seemed to succeed.
Migrate Install From RHEL4 To RHEL5
Oct 14, 2010I need to build a new server for my Oracle 10gR2 due to compatibilities with the new storage system that we have purchased, this server will run RHEL5 x64 and will replace a RHEL4 x64. Since doing an upgrade poses greater risk as the upgrade may fail, I am thinking about building a new server with RHEL5 x64 doing all the config/tuning and then simply running the same Oracle installation (after a full backup) which I was running on the RHEL4 x64.
For this to work I will just need to mount the SAN drives on the new server but and this may be a big but, considering that some versions of some libraries will change do I need to relink anything in my Oracle? I have never manually relinked anything but Oracle may have done so during the initial install.
Import Data Into A 10g Database On RHEL5?
Sep 2, 2010I am trying to import data into a 10g Database on RHEL5.
Fol are the type of TABLE_NAME's of the TABLEs on the export dump:
1.ABCD
2.A_BCD
3.XYZ_AM
4. XYZAM
My requirement is:
I need to import only tables 1 & 4. I would like to exclude tables 2 & 3.
This is what I have only par file:
EXCLUDE=TABLE:" LIKE '%!_AM' escape '!' "
EXCLUDE=TABLE:" LIKE 'A!_%' escape '!' "
When I run a query to check it works fine:
$>select TABLE_NAME from dba_tables where TABLE_NAME like 'A!_%' escape '!';
TABLE_NAME
------------------------------
A_...........
A_..............
A_...............
3 rows selected.
But when I run the import using the par file, i keep getting
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-01740: missing double quote in identifier
SQL & PL/SQL :: How To Debug The Packages
Nov 2, 2011Any ways for Debugging in PLSQL.
Ex:In a package or procedure i have thousands lines of Code how can i Debug.
SQL & PL/SQL :: Packages - Roles And Privileges?
Aug 9, 2005I'm not sure if this belong to this place. move it to the proper place.
I'm having an annoying problem: (I'm not sure if it is a problem)
- In a package body I'm trying to delete/update/insert/select the contents of a table in other schema.
- The respective synonym exists.
- I had created a role with the respective privileges over the synonym.
- I granted the role to the package's owner.
- I try to compile the package, but it keeps returning compilation errors. (Not table found)
- In standard SQL, I can delete/insert/update/select over the table.
- The only way to compile the package, without errors, is to grant the privileges directly to the package's owner.
Is it supposed to work in this way?
PL/SQL :: Display Names And Packages
Jul 17, 2013NAME package
---------- --------------
Anand basic Anand pascal Juliana cobol Kamala dbase Mary oracle Mary c Partick c++ Qadir assembly Qadir c Ramesh dbase Remitha c Remitha assembly Revathi pascal Revathi basic
SQL & PL/SQL :: Packages Component Full Details
May 19, 2011Get following output using user_source(or other) view?
Package_nameProcedure_nameline_startline_end
ABCXYZ1022
In procedure_name column it could be any procedure, function name or any object name exist in package body.
PL/SQL :: How To Know A Trigger Gets Called By Which All Packages / Procedures
Sep 11, 2012Wanted to know whether it is possible to know a trigger is getting fired due to which all packages/procedures. If it has got fired for a particular transaction say multiple times, then wanted to get details of the packages/procedures which caused an event so that trigger got fired?
View 2 Replies View RelatedORA-04068 - Existing State Of Packages Has Been Discarded
Feb 4, 2011We are experiencing an issue with ORA-04068: existing state of packages has been discarded. We're running Oracle 10.2.0.4 on Solaris 10.
I'll provide the timeline of what occurred:
1.) Last night during a maintenance window I recompiled a package and package body. I ran "create or replace" statements from a script via sqlplus to recompile both package and package body. Because I am required to do all DDL under my own login (and not the schema owner login) the scripts require that the schema name be included in the "create or replace" statements. Otherwise an object will be incorrectly created in my schema. This is what happened with the package body. I discovered this when the package body would not compile.
2.) I ran a "drop package body" statement to drop the package body from MY schema.
3.) I added the proper schema name to the script and recompiled both the spec and body under the proper schema.
4.) I ran a script to check for any invalid objects under the application user schema. There were none.
5.) During the night a batch process ran which executed the package. There were several failures with the error ORA-04068: existing state of packages has been discarded.
6.) During the early AM today the error stopped. Not knowing this at the time and believing that the issue was still occurring I began searching the internet for information regarding this issue. One site I found said this could be due to DDL being done on the object (which was the case for us) and there could be an entry in the shared pool marked as invalid which our application's session may be accessing. It recommended running "alter package recompile" for the spec and body. I did this but it seems to have triggered the event again.
I also ran utlrp.sql.
I found some information suggesting the use of DBMS_SESSION.MODIFY_PACKAGE_STATE and/or RESET_PACKAGE but I'm not seeing mention of the risks/implications.
I can verify that the object is no longer in my schema and that the proper object owner has no invalid objects. I am not sure what to do to resolve the issue or keep it from occurring again.
ORA-04068 / Existing State Of Packages Has Been Discarded
Feb 6, 2007I am trying to use dbms_jobs in Oracle 8i database.
This is the syntax I am using:
begin
dbms_job.submit(:jobno, 'SYSTEM.SHRINK_ROLLBACK_SEGS', '07-FEB-2007', NULL);
commit;
end;
i have defined the variable jobno as number!
And i am getting the error :
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_JOB" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
I then go and look at the Sys.dbms_job package and see its not compiling
I have this error:
(1): PLS-00201: identifier 'ANY_INSTANCE' must be declared
(2): PL/SQL: Item ignored
(3): PLS-00801: internal error [21076]
(4): PL/SQL: Item ignored
JDeveloper, Java & XML :: Parsing In PL/SQL Without Any DBMS_XML Packages?
Jun 15, 2012i dont have access to any Oracle XML related pacakges, however I have to pull the data from the following xml.Eg: The alternativeIdentifier.Name should be a column and the value should be the data for the column. Same applies to other tags under characteristics tag.
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:xsi="[url]http://www.w3.org/2001/XMLSchema-instance[/url]"
xmlns:SOAP-ENV="[url]http://schemas.xmlsoap.org/soap/envelope/[/url]"
xmlns:xsd="[url]http://www.w3.org/2001/XMLSchema[/url]"
xmlns:SOAP-ENC="[url]http://schemas.xmlsoap.org/soap/encoding/[/url]"
[code]....
PL/SQL :: Difference Using Cursor In Specifications And Body In Packages
Jun 24, 2013what is the difference using cursor in specifications & body in packages?
View 1 Replies View RelatedRAC & Failsafe :: Cluster In Oracle
Apr 23, 2013Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?
View 6 Replies View RelatedRAC & Failsafe :: RPM For Oracle Installation
Nov 28, 2010i need to make RAC database setup ,so where can i get the operating system Rpm like bleow
compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386
send me link for the above require rpm for linux AS4.
RAC & Failsafe :: SCAN IP For Oracle 11g R2?
Sep 1, 2011I am planning to install oracle RAC 11g R2 on RHEL 5.3. I have 2 RAC nodes and one openfiler NAS. I need to understand how will I configure SCAN IP. Do I need to configure it some where in DSN and OS level or just I need to give this IP and SCAN name while grid install and oracle will create these things?overall steps to configure this or direct me to some documentation where this thing is detailed.
View 6 Replies View RelatedRAC & Failsafe :: FAILOVER In ORACLE 10g
Dec 20, 2012My application uses below jdbc url for database connectivity. Today one of the db node was down for one hour and FAIL OVER did not happen.
<connection-url>
jdbcracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON )(ADDRESS=(PROTOCOL=TCP)(HOST=viphost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=viphost2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=serv ice_name)))
</connection-url>
SQL & PL/SQL :: Keep Logging Track Of Each Task Performed In Procedure Packages
Nov 26, 2010we have a database application which is done frequently.in these we load data throught Sql loader, we create an DB instances, we do several DML operation on the database.
now for such task in an application we need to keep an logging track of each task performed in PL/SQl procedure packages.
Cloud Service :: Adding Packages To Cart In SQL Developer
Jan 14, 2013I am really wondering about data loading to the cloud, I've just read the documentation, but regarding the packages, I have more than 100 package and I have to "add to cart" one by one the problem is that the package body is not added by default, so you have to expand the packages one by one then select the package body right click and add to cart. This task is very tedious, is there any other options.”
View 8 Replies View RelatedRAC/ASM Clusterware Installation :: 11g Release 2 Install Missing Packages?
Aug 8, 2012I'm trying to install 11g Release 2 on a CentOS (4.9) box, but the pre-req check shows that I'm missing the following packages (I had 9 to begin):
gcc-3.4.6 (X86_64)
gcc-c++-3.4.6(X86_64)
libstdc++-devel-3.4.6
Tried to use the yum command "yum install gcc" but get the following error.
Error: cannot find a valid baseurl for repo:update
I think this is due to the "CentOS-Base.repo" file, which I've tried to update by changing the mirror URL's but no success.Then tried to find the rpms online ([URL]...
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: rm -f ntcontab.*
[code]....
RAC & Failsafe :: Oracle 11gR2 RAC On Unix
Aug 8, 2011I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?
View 3 Replies View RelatedRAC & Failsafe :: Oracle Cluster 10 Installation
Oct 27, 2010Steps for installing Oracle Cluster 10?
View 9 Replies View RelatedRAC & Failsafe :: Master Node In Oracle 9i
Mar 11, 2013How to find out which node is master node in oracle 9i RAC database.
View 7 Replies View RelatedRAC & Failsafe :: Is Oracle 11G Supported On VMWARE
Jan 17, 2012Is Oracle Failsafe 11G supported on VMWARE, we plan to create a cluster of two vm servers, is it a supported configuration?
View 4 Replies View RelatedRAC & Failsafe :: Oracle 10g TAF Fails For TOAD
Oct 8, 2011We are into pre-production stage for Oracle RAC implementation. I have setup Oracle 10g 2 node RAC, currently i have been experiencing TAF failures for TOAD client. TOAD client session simply disconnects rather than failing over to the next node, It is noticed that TAF succesfully works for SQL client from the same client machine. Attached herewith are following from both nodes :
1) Listener file node1, node2
2) TNS file node1, node2
3) TNS file client
4) Output of show parameter listener from node1, node2
5) Output of lsnrctl services node1, node2
Summary of environment :
OS - Windows 2003 entp edition sp2, 32 bit
Database server - 10.2.0.5.0
RAC & Failsafe :: Oracle 11gR2 - RAC To RAC Replication Via SAN
May 11, 2011Any experience before on Oracle 11gr2 RAC to RAC via EMC SRDF setup?
View 5 Replies View RelatedRAC & Failsafe :: Memory Usage Increasing On Oracle
Jan 10, 2012After the reboots each system was using around 30 GB of memory... now that it's been up for a week memory is up to 98GB used on each system. None of the systems are swapping.
Mem: 98999084k total, 97937116k used, 1061968k free, 774900k buffers
Swap: 16779884k total, 0k used, 16779884k free, 89510312k cached