Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [oracle10g]

Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle10g** are assumed to be specific to this version or features introduced in this version.

110 questions
0
votes
1 answer

oracle sql developer and sql server

What should I input the connection name there? I have a database called Stack Overflow... I tried the hostname as localhost and it didn't work
EquinoX
  • 357
  • 3
  • 10
  • 26
0
votes
4 answers

Oracle 10g to SQL server 2008/ migration

We have a reasonably heavy Oracle 10G database (~ 120 GB space occupied). The database consists of tables, packages, materialized views, procedures etc. We are planning to decommission Oracle and migrate to SQL server 2008. Can you provide your…
HVS
  • 143
  • 1
  • 2
  • 6
0
votes
2 answers

Oracle 11g: Why doesn't "grant create session" allow user to log in?

I'm working on an Oracle 11g database, and simply need to create a user and log in with it. I successfully create the user, but after running the second line below, I still can't log in. Is there something I'm missing? create user "oskar" identified…
oskar
  • 103
  • 1
  • 3
0
votes
1 answer

Problem with binding php 5 on Apache 2 on Windows 7 to Oracle 10

I'm tring to use oci_connect() function, but get error: PHP Fatal error: Call to undefined function oci_connect() in ... I unzipped Instant Client to "C:\instantclient_11_2" and updated system PATH. I'm uncommented extension=php_oci8.dll line in…
Rodnower
  • 179
  • 3
  • 12
0
votes
2 answers

Convert an Oracle 10g RAC database to single instance

In an attempt to reduce the complexity of a solution, I've been asked to convert a two node Oracle 10g RAC production database to single instance. The database is running on RHEL5 with ASM on SAN. I imagine at least the following steps will be…
Roy
  • 4,256
  • 4
  • 35
  • 50
0
votes
3 answers

How to move Oracle database to another PC without restoring backup?

Take this scenario: Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle. How to move the data and other files and attach to…
RPK
  • 215
  • 1
  • 5
  • 12
0
votes
1 answer

Cannot install Oracle Application server

After succesfull installation of database 10g server, I cannot run install file for application server - it closed unexpectly. How can be problem investigated? Log file contains: Checking installer requirements... Checking operating system version:…
ziftech
  • 131
  • 6
0
votes
2 answers

Issues Installing Oracle Xe 10g on CentOs 4.6

Help! Trying to re-install Oracle XE 10g on my CentOS 4.6 Machine from RPM and cannot complete the installation, prompting the following error: error: unpacking of archive failed: cpio: lstat failed - Input/output error I have searched for options,…
DaveCol
  • 26
  • 4
0
votes
1 answer

Is it possible to run a mixed Red Hat O/S version Oracle RAC Cluster

I have a client who is currently running a 4 node Oracle RAC Database cluster. They want to add new hardware for 2 new nodes. The current nodes are running Red Hat 4.4 Oracle RAC and Database software for Oracle 10g R2 patched up to date. The new…
user51047
0
votes
2 answers

How I can upload an oracle ddl file of 15M

I have a file of 15 mb and i need run the sql of that file in oracle, but when I try load the file, I have a error: The file exceeds the maxim limit When I can change that limit or how I can run that sql file?
diegueus9
  • 117
  • 5
0
votes
3 answers

How to restore an oracle database

I am very new to Oracle and customer gave us their oracle database files. ARC00016_0724940467.001 initVISUAL.ora VISUAL.2010-07-22-1637.log VISUAL-trace.sql SYSAUX01.DBF SYSTEM01.DBF UNDOTBS01.DBF USERS01.DBF I am running Oracle personal edition. I…
nalin-spc
0
votes
1 answer

Configure oracle in debian testing

I have installed oracle10 in debian, in the web ui i can use the database, but this doesn't work with sqlplus, where i can configure this? updated: when i run sqlplus in command line, ask me for login and password, i digit the same of web interface…
diegueus9
  • 117
  • 5
0
votes
2 answers

Migration from Oracle 10gR2 to Oracle XE

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc. I want to migrate to Oracle XE. Can this edition serve as the primary database for a server? Also, i am unclear, about is…
M.N
  • 337
  • 3
  • 7
  • 15
0
votes
1 answer

Connecting SQL 2005 to Oracle 10g

Environment: - Oracle 10g database over a windows 32bit 2003 server - SQL 2005 database over a windows 32 bit 2003 server. I am trying to connect the above databases through heterogeneous services. I have updated the following files: TNSNames.ora,…
Lorn
0
votes
1 answer

Oracle on windows cluster with online/offline IPs

I have a windows cluster (on windows 2008 server) with nodes in different subnets. So cluster has two IPs, one for each node (I'm talking not about node IP, but about cluster IP). One is online, the other is offline. Is it possible to run Oracle…
yzador
1 2 3 4 5 6
7
8