Testing 9i On Virtual Machine Under RHEL 4.8

Sep 1, 2010

I work as a Sys. Admin. for several RHEL 3.8 servers, most of them are clusters of 2 machines. All these servers are running Oracle 9.2.0.7 database. They are running fine on a separate filesystem. So everytime the system has to be formatted for some particular reason, there is no need to re-install the database.

I am trying to make some tests by running the same filesystem containing the oracle database in a fresh Red Hat Enterprise Linux 4.8 X86_64 Install. This task has become impossible, and I'm not quite sure why.

I installed all the compat- packages required for a fresh oracle 9 install in a RHEL4 machine, but at the time of stating the STARTUP sentence, it gives me the next error:

CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.
CMCLI ERROR: OpenCommPort: connect failed with error 2.

After this error (repeated) it says something like: Cannot start an already running database.... But if i stat a shutdown sentence, it says that the instance has not been initialized....

I don't know whether i have to re-install all the oracle software in order to make a clean install in the new kernel version or not, i tried to apply a patch, and the oracle installer recognized the installation i had.

I think it might be because the original system is configured to work as a cluster, and i'm running it on only a virtual machine.

View 6 Replies


ADVERTISEMENT

Windows :: Oracle 10g On Virtual Machine 2003 X64

Jul 9, 2010

Does already installed Oracle 10g (10.2.0.1) on a windows 2003 server x64? Do you notice strange behaviors, any errors after the installation?

Does already installed Oracle 10g on a windows virtual machine? Are there any prerequisites?

View 9 Replies View Related

RAC & Failsafe :: Using One EC2 Machine To Host Several Linux VMs Using Virtual Box

Dec 22, 2010

How to get a RAC running in an EC2 environment?

It isn't possible to use one EC2 machine for each RAC node because EC2 can't handle the virtual IPs, but I had thought that I could use one EC2 machine to host several Linux VMs using Virtual Box (the same way that I use Virtual Box on a Windows host). But I can't get Virtual Box working on EC2. The only relevant advice I can find on this is comments to the effect that running any virtualization product with a Xen machine as host is not a good idea.

I do realize that this isn't a 100% Oracle question, but if set up a RAC on an Amazon Cloud machine,

View 1 Replies View Related

Accessing Oracle On VirtualBox From Host Virtual Machine?

Jul 18, 2013

I have a Host system of windows 8, installed the Virtual Box Latest edition.The guest OS is the oracle Linux that came with the Pre-Built Developer VMs from Oracle.The VM is set to HOST ONLY network setting. Now, the thing is that i want to access the Oracle in the guest machine from my windows host machine.the guest OS shows the IP address as 192.168.56.101. I can ping the IP address from the HOST machine, but cannot connect theSQL developer to the oracle in the guest OS from the host machine. It keeps on saying the Network adapter cannot connect. do not say that install the oracle in window itself. I actually want to do the same on my macbook pro as that is my primary machine.

View 10 Replies View Related

Netca - Unexpected Error Has Been Detected By HotSpot Virtual Machine?

Sep 17, 2013

solving the error below?

[oracle@localhost Desktop]$ netca
Oracle Net Services Configuration:
# An unexpected error has been detected by HotSpot Virtual Machine:
# SIGSEGV (0xb) at pc=0xa23ae762, pid=7422, tid=3075933888
# Java VM: Java HotSpot™ Server VM (1.5.0_17-b02 mixed mode)
# Problematic frame:
# C [libclntsh.so.11.1+0x429762] snlinGetAddrInfo+0x1b2

An error report file with more information is saved as hs_err_pid7422.log

#If you would like to submit a bug report, {URL}...

/u01/app/oracle/product/11.2.0/db_1/bin/netca: line 178: 7422 Aborted (core dumped) $JRE $JRE_OPTIONS -classpath $CLASSPATH oracle.net.ca.NetCA $*

View 1 Replies View Related

Installation :: 11gr2 Setup Shows Error On Virtual Machine

Jun 4, 2013

I have a virtual machine which have Windows Server 2008 R2 Datacentre 64-bit.

When I install Oracle Database 11gR2 and click on "SETUP" file, a message box namely JAVA VIRTUAL MACHINE LAUNCHER and display below error;

_"Could not find the main class. Program will exit."_

Same setup runs successfully on my server with Windows Server 2008 Enterprise.

Is it 11gr2 supports a virtual machine which have Windows Server 2008 R2 Datacentre 64-bit ? or some other?

View 4 Replies View Related

Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database

Mar 21, 2012

i have oel installed on my parallel Virtual machine.

i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.

my os is windows7 32 bit.

View 13 Replies View Related

Installation :: Oracle Database 11gR2 On Virtual Box on Windows 32bits Machine

Oct 31, 2013

I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.

View 6 Replies View Related

Oracle 11g - Java Virtual Machine Could Not Find Main Class Program Will Exit

Jul 26, 2013

In my Organization I am trying to install oracle ODTwithODAC112030 but one Error showing that is java virtual machine could not find main class program will Exit. 

Server Configuration Dell power Edge r510 Windows 2003 64 bit serv PAck 2 Citrix Presentation server 4.5 .

View 1 Replies View Related

Installation :: 10gr2 On 32 Bit RHEL 5 OS

Aug 1, 2012

I am trying to install 10gr2 on a 32 bit RHEL 5 OS. One of the packages that's need to be installed is elfutils-libelf-devel-0 according to metalink.

Now, when I try to install it i get the following error:

error: Failed dependencies:
elfutils-libelf-devel-static-i386 = 0.137-3.el5 is needed by elfutils-libelf-devel-0.137-3.el5.i386

Now i tried to install the said dependency and i got this error:

error: Failed dependencies:
elfutils-libelf-devel-i386 = 0.137-3.el5 is needed by elfutils-libelf-devel-static-0.137-3.el5.i386

I saw a somehow similar solution in

[URL].........

I have to install both the packages in the same rpm command according to the link and i got the following:

[root@MCISMACAMDB Server]# rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:elfutils-libelf-devel-s########################################### [ 50%]
2:elfutils-libelf-devel ########################################### [100%]

The ..static package didn't seem to have installed completely. I tried checking if elfutils-libelf-devel-i386 = 0.137-3.el5 was really installed:

[root@MCISMACAMDB Server]# rpm -q elfutils-libelf-devel-0.137-3.el5.i386.rpm
package elfutils-libelf-devel-0.137-3.el5.i386.rpm is not installed

So i tried installing it again then the system prompted that it is already installed:

[root@MCISMACAMDB Server]# rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
package elfutils-libelf-devel-0.137-3.el5.i386 is already installed

Did i make the right steps? Can i go on now? I don't know if what I did was correct and ok and that I should already consider that package as installed.

View 3 Replies View Related

Installation :: Compatibility Of Oracle 11g R2 On RHEL 5.7?

Aug 30, 2012

Is Oracle Database 11g Release 2 (11.2.0.2.0) compatible on Red hat enterprise linux 5 update 7 ( RHEL 5.7 ) ?

View 5 Replies View Related

Real Application Clusters :: Oracle 11g.2 Rac With ASM RHEL 5

Nov 13, 2012

oracle 11g.2 rac with asm RHEL 5

ora.gsd
OFFLINE OFFLINE ccbs01
OFFLINE OFFLINE ccbs02

why it's offline , what this means , what the useuage of this? did have any affect on database availability? the below it's from OEM

[Critical]      ABSNL     Cluster     Resource State     State Change     
     ora.gsd has instances in OFFLINE State      Nov 12, 2012 12:15:03 PM
[Warning]      ABSNL     Cluster     Resource State     State Change     
     ora.abs.db has instances in OFFLINE State      Nov 12, 2012 12:15:03 PM

View 5 Replies View Related

Oracle Database 11.2.0.3 On RHEL 6.1 - OS Network Configuration

Jul 11, 2012

we are running Oracle database 11.2.0.3 on RHEL 6.1.

Should we join the above machine to an existing Windows 2003 (Active Directory) Domain? or Configure it as a standalone Server?.

View 9 Replies View Related

RAC & Failsafe :: Installing Oracle 10g Clusterware On RHEL-ES-4 Using Vmware?

Apr 16, 2011

I am trying to install Oracle 10g RAC clusterware on RHEL-ES-4 using vmware. everything works properly till the time root.sh on second node.

I am getting the below error.

Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
Failure at final check of Oracle CRS stack.
10

After googling this topic, I found I have to check this first below

This particular case is caused by the OS init system does not working.

" Failure at final check of Oracle CRS stack.10" means CRS daemon did not startup during 600 seconds period.In the root.sh script, it adds CRS related entry in /etc/inittab, run "init q" and expect 3 CRS related daemon processes to start, eg:

init.cssd
init.crsd
init.evmd

With init system problem, none of these daemon processes are spawned, this causes CRS process startup failure as they rely on the CRS daemon processes to start first.

This can be verified by adding a simple entry in /etc/inittab:

test:2:once:/usr/bin/echo "HELLO TEST" > /tmp/test.log

run "init q" as root user. If the init is working, then there should be a file /tmp/test.log generated.

According to above I am not able to generate this file.

View 8 Replies View Related

Accessing Oracle Database From Windows Into RHEL (Linux)

Nov 12, 2012

We have a scenario where Oracle Database R1 is installed on Windows System and the Client is present on Linux. Both the system is on same network. We can access Windows -2-Windows using TNS entry.

I am unable to connect to this scenario where Database is on Windows and Client is on Linux.

View 8 Replies View Related

DB Query Load Testing?

Apr 12, 2013

10.2.0.5 on Solaris 10.

We need to do load testing on our DB before going live. Mainly with 5 queries which are mainly used in our web interface to pull data from the database. For example. I need to send morethan 400-500 sessions to our database using this 5 queries (with different values) and to note down the time taken with every 50 number of users..

View 2 Replies View Related

Query Testing For Null Value In IN

Nov 1, 2013

Oracle 10.2.0.4 I belive the following query is incorrect in my opinion. (there is an index on col but NULLS are ignored? 

SELECT COUNT(*) from <TABLE>

where col in (null,'a','b','c') this works (no errors) and returns pretty quick. However I think the correct query would be SELECT COUNT(*) from <TABLE> where col IS NULL OR col in ('a','b','c') This one takes a long time. As I see it it does a table scan for NULL part and uses the index for the rest as the index cannot be used for NULL values. explanation on this, especially why Oracle accepts the first query "where col in (null,'a','b','c')" without any issue. 

View 3 Replies View Related

Testing Fields With Multiple Paths?

Jan 18, 2007

My task is to test a field in a certain database. We shall refer to the field as ship_to. There is an algorithm for which the field ship_to is populated and higher up in the algorithm, a variable we shall call X is created. The algorith states that I should assign the variable to ship_to unless X is = -1. If X is = -1, the algorithm continues with multiple joins and assignments. What would be the best way to go about coding this solution. There are 4 individual paths. I have only described the first path, but they are similiar in structure. I was thinking of using either Case's or decodes?The field ship_to is a number. I have already created a statement to test the sum of the Target, but now I need to test the entire algorithm to see if it too sums the Target.

View 1 Replies View Related

SQL & PL/SQL :: Add A Not Null Constraint On A Collection For Testing?

Nov 19, 2010

I am trying to add a not null constraint on a collection for testing. It not allowed null values as below

pointers@ORCL> declare
2 type test_type is table of number not null;
3 t_test test_type;
4 begin
5 t_test := test_type(2,4,null); --null is being added
6 dbms_output.put_line('Type variable is initialized and the first element value is '||t_test(1));

[code]....

But what I observed is, i can add, null elements by using 'EXTEND' routine though 'not null' constraint is used for that type.

The below is the example.

pointers@ORCL> ed
Wrote file afiedt.buf
1 declare
2 type test_type is table of number not null;
3 t_test test_type;
4 begin
5 t_test := test_type(2,4);

[code]....

View 6 Replies View Related

Unable To Open Physical Database For Testing?

Jun 13, 2011

I have problems in opening the database of the physical standby in read- write mode/ read only mode. I have a primary server which is running on 2 node RAC and the standby on a seperate single server being used as DR. I recently got this server and my aim was to isolate the standby server from primary server and perform few test. As it has never been tested even once.

Primary Database spec: (2 Node Rac on ASM)
Oracle Version : 10.2.0.3.0
O/s : HP-UX B.11.23

Standby Database spec: (Single Node)
Oracle Version : 10.2.0.3.0
O/s: HP-UX db01 B.11.23

Error:

--------------------------------------------------------------------------------

alter database recover managed standby database cancel;

Database altered.

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/dprod/datafile/system01.dbf'

--------------------------------------------------------------------------------

Parameters :

log_archive_dest_2 string SERVICE=PROD1 LGWR ASYNC VALID
_FOR=(ONLINE_LOGFILES,PRIMARY_
ROLE) DB_UNIQUE_NAME=PROD
remote_archive_enable string true
fal_client string DPROD
fal_server string PROD1, PROD2

Steps tried so far:
Changed log_archive_dest_2 = DEFER on both the primary nodes

Standby :

startup nomount
alter database mount standby database;
alter database recover managed standby database disconnect;
alter database recover managed standby database cancel;
alter database open/readonly (tried both)
Same error.

On Primary:
SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)

--------------------------------------------------------------------------------
55702

on Standby:

MAX(SEQUENCE#)

--------------------------------------------------------------------------------
33289

Primary Database:

SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME NEXT_TIME

--------------------------------------------------------------------------------

55700 13-JUN-11 13-JUN-11
55700 13-JUN-11 13-JUN-11
55701 13-JUN-11 13-JUN-11
55701 13-JUN-11 13-JUN-11
55702 13-JUN-11 13-JUN-11

60824 rows selected.

Standby Database:

SEQUENCE# FIRST_TIME NEXT_TIME

--------------------------------------------------------------------------------

55698 13-JUN-11 13-JUN-11
55699 13-JUN-11 13-JUN-11
55700 13-JUN-11 13-JUN-11
55701 13-JUN-11 13-JUN-11

15206 rows selected.

Additional Information : There is a delay of 20 minutes before the logs get applied. which has been intentional set by team. Dataguard broker is not configured as well.

View 7 Replies View Related

Workflow :: Run Procedure Manually For Testing Purpose

Oct 23, 2012

i want to run this procedure manually for testing purpose

procedure Reject_Doc(itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out NOCOPY varchar2 )

what are the possible values for the variables itemtype,itemkey, actid,funcmode?

View 3 Replies View Related

SQL & PL/SQL :: Testing Nested Blocks But Logic Is Apparently Not Correct?

Apr 9, 2013

I am testing nested blocks, but my logic is apparently not correct.

I am running this script:

DECLARE
v_one number(1) := 1;
v_two number(1) := 2;

[Code]....

I receive the output from only one of the nested blocks:

bad
PL/SQL procedure successfully completed.

SQL>

I understand that I don't need nested blocks for the example above, but this was just a condensed version of what I'm trying to do. I think nesting blocks will be easier to read and maintain, instead of having a huge CASE statement.

How can I execute only the nested block for which the condition is true and ignore the nested blocks that follow?

Are nested blocks not the correct answer here? Should I be looking at invoking procedures/functions instead?

View 8 Replies View Related

Clone Testing Database From X86 To X64 Using DBCA Clonic Templates

Sep 14, 2012

I'm using Oracle Database 11g R2 for study purposes.Currently I'm learning about the DBCA clonic templates.I have an Oracle DB 11g R2 X86 running properly in Ms Windows XP Professional SP 3 X86, using DBCA I created the seed template file .dbc and the .CTL and .DBF files, later I copied those files to a server running Oracle DB 11g R2 X86 in Ms Windows 7 Ultimate X86. Again, using DBCA I successfully created the source database through the seed template file, everything was ok.

Now, I formatted my testing server and I installed Ms Windows 7 Ultimate X64 and Oracle Database 11g R2 X64. I copied the seed template file .dbc and the .CTL and .DBF files to "assistantsdbca emplates" directory. Well, I started DBCA to try create the source database and when the DBCA is creating and starting the Oracle instance it shows the errors:

ORA-00604: error occurred at recursive SQL Level 1
ORA-06553: PLS-801: Internal error [56327]

Is it possible to clone my testing DB from X86 to X64 using DBCA clonic templates?

View 8 Replies View Related

Networking And Gateways :: Testing Private Database Link With Same Name As Public

Oct 13, 2010

We are currently replacing all public database links with private db links in our prod environment. The requirement is

1) private db link name should be same as public
2) Need to create and test out private db links before we can drop public db links.

How can we test out private db links while public db links are still there with the same name?

when I execute SELECT * FROM DUAL@DBLINK from user who created this private db link, which db link it will be using- public or private?

View 9 Replies View Related

Performance Tuning :: How To Clear Cache For Testing Tuned Code

Jul 4, 2011

i am testing a proc after tuning it but the problem is, it is taking a very very less time which it shouldn't. I know that it is because of the buffer cache and the shared pool. that why i need to clean the cache to retest it.

I cannot bounce the database as other schemas are part of it. so is there any way to clean the cache for that particular schema i.e bouncing any particular schema(i know that the term is not appropriate).

View 4 Replies View Related

Database Auto Start With Machine On And Shutdown With Machine Shutdown

Sep 2, 2012

i install oracle 10g on linux on perform the following step but my database is not auto start with the machine

Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.

The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut

Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.

-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.

In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.

If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.

Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.

Automate Startup/Shutdown of Oracle Database on Linux

Step 01: Be sure that oratab file is correct and complete.

Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.

Database entries in the oratab file have the following format:

$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.

If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.

Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.

a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.

# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.

[Code].....

View 1 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related

PL/SQL :: Virtual Column In 11g?

Aug 19, 2013

I m migrating from 10g to 11g.I have doubt on virtual column.whether function based index and virtual column are same? if no means what difference between then.What are difference in their performance??

View 5 Replies View Related

Connect To DB On Virtual Box Using Toad?

Sep 27, 2013

Im getting this error when trying to connect toad to my test database using virtualbox. This is my first time trying to do this on a Mac as well:

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

The settings in toad are correct as far as host, port #, and sid. My listener is up, and it is registered with the database. My tnsnames.ora file is correct. No firewall. I can ping my virtualbox from my local machine. I placed my tnsnames.ora file on my local machine, and tried to connect that way as well. I have no clue what else the Network adapter is looking for.

View 1 Replies View Related

Windows :: OEL Installation Using VM Virtual BOX On Win 8

Feb 5, 2013

I have a new laptop with windows 8 installed. I tried installing Oracle Virtual Box. But I am unable to install OEL on top of that. How to do installations on Windows 8. If so, what are the compatible versions of OEL and Virtual Box?

View 2 Replies View Related







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