initializing oracle

[Former Member]

Hello

I made a copy from \oracle\ sapdataX, X = 1 ... n, + trace + ...

it was at PRD machine, now its in DEV machine

sid of PRD machine is: BBP, DEV is BPT

I deleted whole c:\oracle\sapdataX from dev machine except \usr

then copied what file from PRD

i want to put production database online...

what i can do?

i put whole services on, but, still not working

the console is putting online the sid, but not launching the database

what i can do ???

thanks

regards

PS. How I can reset password ?

[Former Member · Accepted solution]

Hello Pheno SAP,

The process you want to use to build your DEV system is called a database refresh, or homogeneous system copy.

If you do it manually, when you copied your sapdatas, and so on, you must not start your database.

You first have to change your database SID and regenerate the control files and redo log files.

To do this you must get the database structure of your production server at the same time you took the sapdatas and so on.

The exact way to proceed is :

- Generate the structure file with SQL command "alter database backup controlfile to trace;" on PRD system

- Copy your files sapdata on DEV system

- Copy your generated file on your DEV system and modify it to insert the new SID of your DB etc...

- Regenerate your control and log files

- Open your DB

- Start your SAP systems

Regards,

Stéphan

[Former Member · Accepted solution]

Dear Mr Stephan

thanks for your reply

i dont have productio machine with me, but, before it, it was changed to new sid

"You first have to change your database SID and regenerate the control files and redo log files."

which are redo log files??

"Regenerate your control and log files "

i created new control.sql manually

and which are other log files?

thanks

Pheno SAP

SAP Jr.Administrator

[Former Member · Accepted solution]

it was missing the

set local=<sid>

then i put

sqlplus /nologs

@control.sql

FYI"

control.sql = {

connect /as sysdba

startup nomount

CREATE CONTROLFILE REUSE SET DATABASE "CRD" RESETLOGS NOARCHIVELOG

... }"

i want to know after it, something happend or not, any message or something if it was went fine or not

because after it

just come :

Total system globmal data ...

fixed side

variable siade

database buffers

redo buffers..

SQL>

its like this?

do i need to write/do something else or quit?

thanks

[Former Member · Accepted solution]

You need to enter the new SQL command :

alter database open resetlogs;

This will open the database resetting the online redo log files.

Please be sure that the old redo log files have been dropped from /oracle/SID/origlogA etc...

Regards,

Stéphan

Edit : after that, you are able to start the SAP system.

But you have to do the post refresh activities : RZ10, SE06, STMS and so on.

Edited by: Stéphan on Feb 21, 2008 5:23 PM

[former_member204746]

easiest solution, re-install SAP from scratch, it will create wall that you need to bring SAP up. when installation is finished, restore your database and rename it as per procedures supplied in your other messages.

[Former Member]

i know, but i cant install sap now

i have to do that way...

help me plz

thanks

pheno

[donald_voorhees]

You have numerous steps to complete before bringing the system up.

You simply copied the sapdata directories only? You need to have consistent control files, and database characteristics aswell. You need to bring the DB up, manually rename it using the backup control file method, recreate the appropriate ops$ users, sync the DB password with the SAP users, make sure R3trans works, then do a slew of rename activities.

If you are not intimately familiar with how to carry out these tasks, sorry to say, you are in over your head, the steps are too numerous and technical to spell out here.

You should simply reinstall, restore, or use sapinst system copy to get the system up.

[Former Member]

Hello

Thanks for your anwer, but i have to do this without a instalation.

The problem is i put the DB UP

its like being impossible putting it up

i put,

sqlplus /nologs

connect /as sysdba

its comes error:

ERROR: ORA-12560: TNS: protocol adapter error

when i put

and i did sqlplus /nologs

conn user/password@CRD.World

and its comes ORA-1034: Oracle not available

and ORA-27101: shared momenry realms do not exist

when i put

sqplus /nologs

connect interal@crd

connected to idle instance

i tried the tnsping crd, and its working well..

what i can do for put DB UP?

info: orcale 8.1.7 + win2k

thanks

[donald_voorhees]

First and foremost you seem to have an issue with the TNS environment, do you use a global or local TNS set up? In tnsnames.or and listener.ora, make sure the system is set up and under the proper ID and address.

What happens when you do a "startup immediate"?

What ora errors are present in the alert log?

[Former Member]

How can I check if im using global or local tns?

i just made tnsping sid, and the results are Ok.

about: startup immediate (with service ORACLE*Agent on)

sqlplus /nologs

startup

results: ORA-12560 : TNS protocol adapter error

if: startup immediate

SP2-0717: invalid combination of Startup Options

in the alert log, nothing is changed :S....

the database is down, i need yo make it up..

thanks.

pheno

[former_member204746]

before attempting to go into sqlplus, you must create the Oracle service in Windows:

oradim -new -sid BPT -startmode manual

then, start the service and try:

svrmgrl (or svrmgr30)

connect / as sysdba

startup

revert with results.

[Former Member]

the sid already exist and its come in the

control panel- administrative tools- componentes services-

there come ORACLESERVICEBPT

and's its already started.

the error still continue ...

:s what you suggest to do ?