copy the init.ora
look at the size of the redo logs, size of the datafiles.
make all the directories on the new machine.
Wait, how did you create the first database? I'm 99% sure you didnt type create database.
use the same scripts
and oh yes READ THE DOCUMENTATION.
Most of the people here will help the newbies BUT DAMN take some of your own initiative.
If you'd like to know how I learned oracle 11+ years ago, read on otherwise delete now.
I start at a large insurance firm as a C programmer/Unix SA. First day on the job, they asked me what I knew about Oracle, I said nothing, which was the truth. They said can you load it for us on this sun box, I said "sure does it come with an installation guide?", they had no idea since the box was still sealed. I opened it up and started reading.
Today its a easier, you can use database creation assistants, all of this GUI crap, creating a Database is damn baby's work nowadays. Back in version 5 days, the docs sucked, support sucked, we had to figure it out on our own.
Spend some time reading the docs, experimenting, learning instead of having everyone bottle feed you. You can almost be a decent DBA by not doing anything except using GUI tools, so my question is why all of the questions, if you've not eeven read the administrators guide. Take some initiative.
That is all.
joe
Santosh Varma wrote:
i am using oracle 8.1.7
and have a product ready for release to the customer in my office.
in the client's place, only the oracle is installed.
next step i presume is database creation to which my application will interact .. right ??
how do i make sure that the database i create is the same as the database in my office..
and could anyone of u give me the exact parameters for create database which are necessary.
Thanks and regards,
Santosh
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
