Init<SID>.sap File missing

[Former Member]

I am using old version 4.6C NW for testing purpose.. I couldn't found init<SID>.sap file in any folder, where may I get it ???

Thanks

[JPReyes · Accepted solution]

That is located on the oracle database (dbs in UNIX) directory

Look under <ORACLE_HOME>\database for Windows or <ORACLE_HOME>/dbs for UNIX

Regards

Juan

[Former Member · Accepted solution]

Hi Juan,

I have widnows env.

I found out initMTD.sap file in oracle folder... thanks

Created new 2 folder in 😧 drive which i want to save backup... D:\mybackup and D:\saparch

when I run Brtools and I am getting this error message:

screen shot here:

http://www.flickr.com/photos/38842895@N04/4641886185/sizes/o

This is my initMTD.sap file paramaters

-

---

backup_mode = all

backup_type = online

backup_dev_type = disk

backup_root_dir = D:\mybackup

stage_root_dir = C:\oracle\DBD\oraarch

compress_cmd = "C:\usr\sap\MTD\SYS\exe\run\mkszip -c $ > $"

uncompress_cmd = "C:\usr\sap\MTD\SYS\exe\run\uncompress -c $ > $"

compress_dir = C:\oracle\DBD\sapreorg

archive_function = save

archive_copy_dir = D:\saparch

archive_stage_dir = D:\saparch

volume_archive = (DBDA01, DBDA02, DBDA03, DBDA04, DBDA05,

DBDA06, DBDA07, DBDA08, DBDA09, DBDA10,

DBDA11, DBDA12, DBDA13, DBDA14, DBDA15,

DBDA16, DBDA17, DBDA18, DBDA19, DBDA20,

DBDA21, DBDA22, DBDA23, DBDA24, DBDA25,

DBDA26, DBDA27, DBDA28, DBDA29, DBDA30)

volume_backup = (DBDB01, DBDB02, DBDB03, DBDB04, DBDB05,

DBDB06, DBDB07, DBDB08, DBDB09, DBDB10,

DBDB11, DBDB12, DBDB13, DBDB14, DBDB15,

DBDB16, DBDB17, DBDB18, DBDB19, DBDB20,

DBDB21, DBDB22, DBDB23, DBDB24, DBDB25,

DBDB26, DBDB27, DBDB28, DBDB29, DBDB30)

expir_period = 30

Edited by: AngelinePurnama on May 26, 2010 7:00 PM

[Former Member · Accepted solution]

Hello Angeline,

From the screen shot it is purely a permission issue.

Check the ownership and permission of the folder C:\mybackup\sapbackup

Also, please check the brtools permissions.

Thanks,

Nick S

[former_member227283 · Accepted solution]

Hi,

As per you screenshot , backup is trying to happen on C drive.

but as per your init<SID>.sap , the backup should happen on D drive

backup_mode = all
backup_type = online
backup_dev_type = disk
backup_root_dir = D:\mybackup
stage_root_dir = C:\oracle\DBD\oraarch
compress_cmd = "C:\usr\sap\MTD\SYS\exe\run\mkszip -c $ > $"
uncompress_cmd = "C:\usr\sap\MTD\SYS\exe\run\uncompress -c $ > $"
compress_dir = C:\oracle\DBD\sapreorg

Check why backup is going on C drive.

IF you have to backup on C drive, then create folder MYBACKUP on C drive.

Thanks

Anil

[Former Member · Accepted solution]

Ok here is summary:

1. I create 2 folders in "C" drive mybackup and saparch

2. Give "C" for all permission full control

3. I am getting same error again... I think I know the problem is sql user and password

I am loging sql

/@dbd as sysdba

SQL> alter user system identified by ******** ;

SQL> commit;

when I try to connect system user I got an error:

Warning: You are no longer connected to ORACLE.

ORA-12560: TNS:protocol adapter error

How to change or reset password for system ? or how can I put /@dbd as sysdba in brtools ????

please any idea ?

Thanks

[Former Member · Accepted solution]

Thanks you so much for all your responsed

Problem has been resolved.... due to OS level user... basically I have to login mtdadm user and chagne oracle system user password... now its fixed

Thanks again

[Former Member]

HI,

If its oracle it should be there in

Oracle_home/dbs or oracle_home/database

/Oracle/SID/<Oracle_version>/dbs

or

<d:/>/Oracle/SID/<Oracle_version>/database.

Regards,