12-14-2005
Quote:
Originally Posted by tt155
I have move an oracle db from old server to a new server ( solaris 5.9 is the operating system ) my problem is that to new server the datafile ( *.dbf ) are in a different path .....
example
old : /export/home/data/blobs ...........
new /oracle/data/blobs.......
how i can change into it into the oracle schema ?
which are all the path of the datafile that I must change?
Since you have moved the Oracle database, you certainly can't start it since the data files are not where the control files says that they are. Hopefully you haven't clobbered your old database server so you can run the commands necessary (makes you life much easier).
A little background: Oracle requires that online redo logs and datafiles to be located where the control file indicates. Your control file (and its backups) cannot be edited with a text editor so Oracle has provided you a method for creating an SQL script that can be edited. Your task will be to rebuild the controlfile using the modified SQL script on your new server.
This
FAQ shows you the steps required for performing this operation. Follow them carefully because you can render the copied database irrevocably damaged. Also, it is imperative that your database was shut down when you copied the data files. You will not succeed in recreating the controlfile unless the database was copied in a consistent state. Oracle performs checkpoints at regular intervals and keeps an internal number for managing data consistency. If Oracle's SCN does not agree with the physical data files, your database will not restart.
Good luck.
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
Does anyone know of an ascii to dbf converter for sco
unix? Or any flavor of unix for that matter.
Thanks!
Georgio (1 Reply)
Discussion started by: gseyforth
1 Replies
2. Shell Programming and Scripting
Hi guys, my supervisor has asked me to solve the problem in 7 days, I've taken 3 days to think about it but couldn't figure out any idea.
Please give me some thoughts with the following problem,
I have index.database that has only index date:
1994
1995
1996
1997
1998
1999
I have... (6 Replies)
Discussion started by: onthetopo
6 Replies
3. Shell Programming and Scripting
Hi all,
I am new to shell scripting.
I have dbf file and I need to convert it into csv file.
OR, can i read the fields from a .dbf file and OR seprate the records in dbf file and put into .csv or txt.
Actually in the .dbf files I am getting , the numbers of fields may vary in very record and... (6 Replies)
Discussion started by: gauara
6 Replies
4. Shell Programming and Scripting
Dear All,
Please help in this subject..
my requirement is list the files in directory and out of that list make the different set and each should set contains 10 files and assign to variable and start zipping in background. pick the second set files and same to be repeat the commands parallel.
i... (3 Replies)
Discussion started by: nmadhuhb
3 Replies
5. Shell Programming and Scripting
Hi,
I have two files:
first input file is having 7-8 columns,
and second data file is like
I want to arrange my datafile1 in the order given in second data file, by comparing the seconddatafile with the second column of first file and print the entire line....also if any... (2 Replies)
Discussion started by: CAch
2 Replies
6. Shell Programming and Scripting
This is not a valid command, but you get the idea: "cp *1.dbf *2.dbf"
I need to change the 1 to 2 on many file names.
Using csh. Any ideas?
MM (3 Replies)
Discussion started by: MartMX
3 Replies
7. UNIX for Dummies Questions & Answers
Okay, I search around and couldn't find what I needed, so here goes:
I have a series of ArcGIS point shapefiles. If I open them in Excel I can save as an Excel or text file and get a 2 column list:
POINTID | GRID_CODE
1 | 2.34234
2 | 4.3425
3 | 6.32456
etc...
The problem is that I... (3 Replies)
Discussion started by: jbrandt1979
3 Replies
8. UNIX for Advanced & Expert Users
Hi all,
Could anyone please share ideas or logic on how to automate add/resize datafile in Oracle ASM Storage for Oracle RAC/Single Node databases when any tablespace space alert is trigerred by OEM?
Thanks for your help and time on it!
Thanks®ards,
a1_win
Please DON'T use CODE tags... (0 Replies)
Discussion started by: a1_win
0 Replies
LEARN ABOUT DEBIAN
apache::session::store::oracle
Apache::Session::Store::Oracle(3pm) User Contributed Perl Documentation Apache::Session::Store::Oracle(3pm)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.10.1 2010-10-18 Apache::Session::Store::Oracle(3pm)