Red Hat / Fedora :: Unable To Start Oracle Database?

Sep 16, 2010

i am installing oracle database 10g2 in my fedora12 with the help of this link ORACLE-BASE - Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora 7 (F7)Now i am start my Database using sqlplus:[oraclelocalhost ~]$ sqlplusSQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 16 10:53:47 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter user-name: /as sysdbaConnected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes

[code]...

View 4 Replies


ADVERTISEMENT

Red Hat / Fedora :: Unable To Stop Oracle Database Services

May 23, 2009

Currently using oracle 9i with 3 database(maindb,arist,samp) in redhat 5.3 server .I want to stop 2 database "maindb" and "samp" manually ( in XP or Vista we can stop service oraclemaindb and oraclesamp ), but in redhat i dont know how to stop services and how to see currently running oracle services.

View 1 Replies View Related

Ubuntu :: ORACLE - Nothing Happens When Clicking On "Start Database"

Jan 14, 2011

I've installed Oracle XE yesterday (forcing architecture, cause i am using amd64), it was working fine until i reboot my computer.

At the beginning i wasn't able to start because i was getting an error:

- "Operation failed. my_user is not a member of 'dba' group."

So, i went to System -> Administration -> Users and Groups -> Manage Groups -> (selected 'dba') -> Properties, and checked my user.

But now, when i click on "Start Database", the cursor stay 'waiting' and after some time it goes back to the pointer and nothing happens. On "Run SQL Command Line" i get "SP2-0640: Not connected" and in "Go To Database Homepage": - "Firefox can't establish a connection to the server at 127.0.0.1:1234"

(When installing i chose port 1234)

Now i cant uninstall it (I've installed it through dpkg for forcing architecture, and opening the .deb package i don't get the "uninstall" button)

View 9 Replies View Related

Red Hat / Fedora :: Starting Oracle Database Via Dbora Failing?

Jun 21, 2011

I have a dbora script that i've been having fits with. Running RH EL 5.

#!/bin/sh -x
# chkconfig: 345 95 10
# description: Oracle auto start-stop script.

[code]...

View 1 Replies View Related

General :: Unable To Start Xclock For Oracle Reports For Bar Code Printing

Apr 15, 2011

When I do xhost + also it hangs.Without the xclock I am not able to run oracle reports in production for bar code printing as I am not able to start a standalone reports server. Help needed to start xclock and where to look for any help

View 2 Replies View Related

General :: Copying Tables From One Database To Another In Oracle?

Apr 8, 2011

translationables,i.e,camp_generic_transcamp_generic_trans_defcamp_generic_trans_epcthese tables exist in cntr1/cntr1@camABC1I have to copy these tables from here to staging environment.I need to first check if any of the tables exist in staging.If yes,then delete and create new.There are 4 staging env from 5 to 8.I have to pass the staging environment as parameter to ask the user which environment does he want the tables to be copied

View 1 Replies View Related

Software :: How To Connect OpenOffice 3 To Oracle Database?

Mar 14, 2009

I'm using Kubuntu 8.04 and now I've installed OpenOffice 3, both in Spanish.I have oracle client installed and can connect to Oracle databases with clients like tora.What I try:

- Open Database and select connect to an existing database.
- Select Oracle JDBC.
- Next
- DatabaseName: I put the sid of the database of oracle. (orcl)
Server URL: The name of the server containing the database. It's resolved by a ping. (database.organization.es)
Port: 1521
- Oracle JDBC Driver:
oracle.jdbc.driver.OracleDriver
But I press the test button, I receive an error: JDBC Driver can't be loaded (really, the message is in spanish).

View 2 Replies View Related

Programming :: Error Connecting To Oracle Database From PHP

Oct 12, 2010

I've just installed the Oracle Instant client using this: https://help.ubuntu.com/community/PHPOracle

The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:

PHP Code:

Code:

How to troubleshoot.

View 2 Replies View Related

Programming :: Unix Script For Oracle Database?

Apr 7, 2011

creating the below unix script to run in oracle database .I need a script which should do the following things.

1. The script should insert row count of a table from one database(A) into table (AB) in another database(B).

2. The script should update tow count of the similar table and tablespace from database (B) in to a table AB.

3. The script should update the status column of the table AB as: 'Y' if the rowcount of the table@A and rowcount of the table@B matching. or else it should update 'N'

View 4 Replies View Related

Fedora :: Automatic Start Stop Script For Oracle 11g?

Aug 28, 2010

i finished installing oracle 11g r2 with EM but i cant find any good script that will close the database completely before rebooting they all start it correctly but for the shutdown they don't wait and the database restart in recovery mode

View 3 Replies View Related

Networking :: Iptables Or Reverse Proxy For Oracle Database?

Feb 15, 2010

I'm trying to access my oracle database (port 1521) from the outside.What I have:Outside -----> Proxy ----> DatabaseWhat I try is to configure a reverse proxy or iptables for accepting connections on port 1521 and transfer them to database. Only one computer of the outside will have access to the database.I suppose than this can be done with iptables or another way.In the real environment proxy will have two nicut for test purposes my computer will have only one (for test purposes, the tree computer will be in the same net)

View 11 Replies View Related

General :: Cannot Run Auto Shutdown Script For Oracle Database

Mar 18, 2010

in order to do full backup system, i have to shutdown the oracle database. My backup software can stop the services by running the shutdown script. But in order to shutdown the oracle database, the script must be run under oracle privilege. The conflict is our backup system which is reside under root privilege cannot run the oracle shutdown script which is needed to triggered by oracle privilege.

View 1 Replies View Related

General :: Compare Oracle Database Table Contains Using Scripts?

Dec 26, 2010

How to compare oracle database table contains using (Perl/Shell)scripts.

View 4 Replies View Related

Programming :: Connecting To Remote Oracle Database Using Perl?

Jan 27, 2010

How to connect to remote oracle database using perl?

This is what I tried.

Code:

But I am unable to connect.

View 4 Replies View Related

Ubuntu Installation :: Can SQL 2008 Open Database Made From Oracle

Feb 17, 2010

My DataBase Teacher wants us to install SQL 2008 cause on 3 days i gotta practice for the big test But the requirements are a ton "Visual Basic 2008 with service pack 1 & IIS" but thats just a tiny part of the problem.! My Windows 7 crashed.! So iam thinking can linux oracle be the answer of my ugly problems.?!Can SQL 2008 open database made from linux Oracle?

View 3 Replies View Related

Networking :: Configure A Reverse Proxy For Oracle Database Connections?

Mar 4, 2010

I'm trying to configure a reverse proxy for Oracle Database connections. What I have:

Host outside --> Reverse proxy --> Oracle Database

The "Revese proxy" has two IP, one for local and another for outside.I've tried with iptables, but unable.Now I'm trying with "redir".When I do a tnsping database, it works and says OK. But executing sqlplus user/pass@database, it tries to connect but time later I receive a timeout. What i do is a redir from port 1521 in "Reverse proxy" to 1521 in "Oracle database" why this doesn't work or any other way to do it?

View 1 Replies View Related

General :: Check With Nagios An Oracle Database That Is Located On A Server?

May 4, 2011

I need to check with nagios an oracle database that is located on a server. There are a lot of plugins that are provided, the problem is that the database is located on a remote server (i have an hostaddress) and then i need to log on the database (i have username and pass)So i only need to have a plugin that connects to that hostaddress and logs on, but i can't find any plugin which does that

View 14 Replies View Related

General :: Configure Autostart Of Oracle Database / Soa Suite On Bootup?

Jan 24, 2011

I need to configure autostart of oracle database 11g & oracle soa suite 11g after successful OS startup. Linux: Redhat version 5. I have commands needed for startup, but not sure on where to keep the file.

View 2 Replies View Related

Server :: Oracle Database - Mountpoint Read And Writable After Reboot

Jan 7, 2010

We have a Dell PE6600 with a QLA2460 FC HBA in it. Server is running RedHat AS 4.7 (kernel 2.6.9-78), FC driver used is the file qlafc-linux-8.02.23-3-install.tar downloaded from the QLogic website. On this server is an Oracle database running (11.1.0.6). Files for the Oracle database are located in mountpoint /u02. The SAN is an iQStor 2880. Since several weeks we suddenly have problems with the Oracle database after a reboot of the server. After a reboot the mountpoint /u02 is readable and writable (tested by creating, opening and removing files).

However, when we try to start the database we get an error which give you the idea that the database is corrupt. The Oracle error is quite a general error. After doing a lot of testing we found out that if we unmount /u02 and mount it again (using mount -a so it reads the /etc/fstab), the database can be started after all. So the database is not corrupt but for some weird reason we have to remount /u02 first before the Oracle database can use it. We don't know if it's a linux issue, fibre issue, san issue or an oracle issue.

View 1 Replies View Related

Red Hat :: Oracle 10g Database Installation Procedures In Redhat Enterprise Server 5?

Jan 13, 2011

I have installed Redhat Enterprise Linux Server 5 on my laptop. I want to install Oracle 10g database on RHEL5 server. I want to know whether any additional rpm's need to install before installing the Oracle 10g.

View 1 Replies View Related

General :: Configure UnixODBC On Rehat EL 5 32 Bit To Connect To An Oracle 10g Database Server?

Mar 28, 2010

I'm trying to configure unixODBC on Linux rehat EL 5 32 bit to connect to an Oracle 10g database server. But when I retest the connection after the configuration then The error occurs:

# isql -v oralab4_dns vonphot vonphoto
isql: symbol lookup error: /usr/lib/libreadline.so.3: undefined symbol: PC

I have searched on Google.com for 2 days but I can't resolve the problem.

View 3 Replies View Related

Ubuntu Servers :: MySql Database Won't Start - How To Make It Start

May 4, 2011

I have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?

View 9 Replies View Related

Networking :: Database Error: Unable To Connect To Database:The MySQL Adapter "mysql" Is Not Available

Jun 16, 2011

I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.

[code]...

View 10 Replies View Related

Programming :: START And STOP Oracle Automatically On System Startup And Shutdown?

Aug 17, 2009

I have installed Oracle 11g on 5.3. Now, I am trying to START and STOP oracle automatically on system startup and shutdown. I am following this link To have this effect, I have created /etc/init.d/dbora

Code:

#!/bin/sh
# chkconfig: 345 99 10
ORA_HOME=/oracle/app/oracle/product/11.1.0/db_1

[code]....

View 4 Replies View Related

Red Hat :: Start Oracle Enterprise Manager On Redhat 5.2 On Dell Inspiron 1525?

Apr 17, 2010

I have dell inspiron 1525.I installed Redhat linux 5.2 and then Oralce 10g R2.I can not start Oracle enterprise manager(EM) on redhat.Except EM oracle is working properly.Why is so ?

View 2 Replies View Related

Ubuntu :: Unable To Install The Oracle And Sql*plus

Mar 11, 2011

here's my setup: 32 bit Ubuntu 10.10 with an AMD 2.7GHz processor, and 2GB of RAM.I get Oracle 11G R2 installed, except two things fail near the end of the installation (I think they're both Oracle Net services or something. I broke a cardinal rule by not writing them down. ) I try to use sqlplus through Terminal, but the system can't find sqlplus. I'm assuming it isn't installed. I'm unable to connect to it through JDeveloper.

View 2 Replies View Related

Software :: Unable To Connect Oracle?

Apr 15, 2011

I have installed oralce-xe 10g on CentOs. I am facing error while connecting it

SQL> connect
Enter user-name: HR
Enter password:

[code]...

View 1 Replies View Related

OpenSUSE :: Unable To Install Oracle Virtualbox

Mar 16, 2011

Added the repo and installed Virtualbox.

Added user as vboxusers group

Added the following packages according to the error log

- make gcc kernel-source dkms

Finally /etc/init.d/vboxdrv setup reports an error

Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel

[Code].....

View 4 Replies View Related

General :: User For Oracle,tried To Install Oracle 10g On Redhat 5 But Gettinh The Same Error Message?

Nov 27, 2010

I'm a new user for oracle,tried to install oracle 10g on redhat linux 5 but gettinh the same error message.response/ runInstaller[oracle2@localhost database_10201]$ sh runInstaller _runInstaller: line 54:/tmp/database_10201/install/.oui: Permission denied_Doany one plz help me how to give full set of permisions to an user in linux to access a folder??

View 2 Replies View Related

Ubuntu :: Installing Oracle - /etc/init.d/oracle-xe Configure Command Missing?

Jul 24, 2011

I've AMD64 system with Ubuntu 11.04 installed. It's been rough ride for me to install oracle-xe-universal. I've already spent more than 2 days on this. Still unsuccessful.

1) First I downloaded the packages libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb

2) Then I ran

sudo apt-get install bc (ran fine)
sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb (ran fine)
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb

(gave me dependency error for libc6 (>= 2.3.2), I modified the control file to remove dependency and rebuilt the package) (now worked fine) Oracle xe is now installed. Then I tried to start the DB it started but it's HTTP client never started. So I decided to uninstall the oracle-xe=universal. None of the sudo apt-get remove oracle-xe-universal command's didn't worked for me. So i went for manual uninstallation directions as per oracle link.

I ran the following command-

--Manually uninstalling Oracle 10g--
sudo rm -rf /usr/lib/oracle /etc/oratab /etc/init.d/oracle-xe /etc/sysconfig/oracle-xe /usr/share/doc/oracle_xe /usr/share/doc/oracle_xe_client

Then I again ran the following command to install oracle-xe

sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb

See below what I got as the output-

rocky@ubuntu:~/git/mygit/edas2/libaio$ sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
dpkg: warning: overriding problem because --force enabled:
package architecture (i386) does not match system (amd64)

[code]....

Even in applications menu I don't see the if oracle has been installed. So i conclude first time installation was ok but somehow http client didn't worked. After manual uninstallation, second installation didn't even loaded/installed the oracle-xe in init.d directory.

View 1 Replies View Related







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