Cold Backup/Restore Oracle database and Oracle 10g Enterprise Manager Landing issues

enterprise|oracle| Backup | data | database | problem

Cold Backup/Restore Oracle Database
by Kayuk

1. Backing Up the database

Backs up all dbf, CTL, log files in the ORADATA\DB2 (the folder that the database DB2 stores).

Back up the Initdb2.ora file in the database. (database?? Backup Files init??. Ora

2. Restore the database process

A. Delete the original database

Connect sys/ora123 as Sysdba
Startup Mount Restrict
Drop database
Shutdown

B. Restoring database files

Restores the backed-up files to the previously stored folder.

Posted On:mon, 2006 4:09 PM

Oracle 10g Enterprise Manager Landing issue
by Kayuk

After installing Oracle 10g, open http://dbserver:5500/em/and fill in "Host ID" and "Identity Certificate of target database", always error: RemoteOperationException:ERROR:Wrong Password for user. Host identity is the administrator, the database using the SYS, the password is not wrong, why not even on?

Solution steps:

In the local security policy--"User Rights Assignment"--"Log on as a batch job" to add an administrator user to this computer

1. Click on start => Programs => administrative Tools => Local security Policy (or also via start => settin GS => Control Panel => Administrative Tools)
    Open the Controls panel--"Administrative Tools"--"local Security Policy"
2. Under local Policies on the left, select User Rights Assignment Folder
    Select the "Native Policy"--"User Rights Assignment"
3. Look in the right side of the windows and scroll down to the "Logon as Batch Job" privilege and select it.
Log on as a batch job
on the right side of the     select 4. Either select Action from the menu bar then security or right-click to the "Logon as a Batch Job" privilege security.
5. Select the Add button which evokes a select Users/groups box.
   Click "Add User or group"
6. From the ' Look in ' field, select the local workstation/server.
   Click "Location" to select the local computer.
7. Select the User administrator.
    Click "Advanced"-"Find Now" and select Administrator
8. Select Add then OK.