?
Solved

Oracle Management Server - Backup & Recovery

Posted on 2003-03-26
28
Medium Priority
?
1,812 Views
Last Modified: 2008-10-13
I have installed Oracle 9i server and client on my machine.  I am able to launch the Enterprise Manager Console as "standaline".  But, when I try to do backups, it tells me that I need to login to the Oracle Managment Server (OMS).

Does anyone know how to go about it?

I have tried putting in the default userid (sysman) and default password (oem_temp) and <SID>.<SERVER> as the management server.  But, I get this error -

VTK-1000 : Unable to connect to the management server <SID>.<SERVER>.  Please verify that you have entered the correct host name and the status of the Oracle Management Server.

Any help would be greatly appreciated!  Thanks.
0
Comment
Question by:pbisht
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 16
  • 11
28 Comments
 

Author Comment

by:pbisht
ID: 8213060
oops... there's a mistake in my above description:

"standaline" is actually "standalone"

Thanks!
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8213990
Without OEM you have to run your exports/backups manually using scripts for EXP.exe or RMAN.exe.

'Oracle Enterprise Manager' OEM is a 3-tier application available in the Product : Oracle9i Management and Integration. You have to create an OEM repository in a database, followed by installing the 'Oracle Management Server' (OMS) on the same or any other server that talks to the repository. Then you have to install the client part called 'Console' on your desktop that talks to the OMS.

Since you have the Database Server and Client on the same machine, I believe you would load the OMS on this machine too. Once you have it installed, you will see a service called 'OracleManagementServer'. Start the OMS from a command prompt by typing:
  oemctrl start oms
The default login name and password for the OMS is:
  sysman/oem_temp

Then start the console and connect to the repository database.

0
 

Author Comment

by:pbisht
ID: 8218080
Thanks for your response.  I will try your suggestion and let you know soon.  I'm fairly new to Oracle and pretty clueless!  I'll keep you updated.  Thanks.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:pbisht
ID: 8225831
Hi SDutta,

I got OMS working and created a respository.  However, when I was trying to create a backup, I got error messages like "insufficient privileges" and "missing or invalid preferred credentials".  I started working on that, and now I seem to have lost the sysman password.  I had to change it from oem_temp to something else when I first logged in.  I logged in several times with the new password, but now it doesn't accept it any more.  Do you know how I can reset the password back to oem_temp or change it something else?

Thanks for your help and patience!

- Puja
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8225941
Hi Puja,

Unless you have already noticed, SYSMAN is not defined as a user to Oracle, it is just inside OEM. If you created another OEM user with super admin rights, you can just login with that user and change sysman's password.

Otherwise, you must follow these steps:

* Start SQL*Plus and connect to EM repository database with the EM repository user (this is the schema owner of the repository) :
<emrepository>/<emrepository-pwd>@<em-repository>

* Once connected run :
execute smp_maintenance.reset_sysman();
The password will be changed back to oem_temp

Hope this helps.
SDutta
0
 

Author Comment

by:pbisht
ID: 8226524
Thanks for responding so promptly!


Before I read your message, I tried to shutdown and startup the database.  The shutdown was taking a long time and was terminated abnormally (via Task Manager>End Task).  When I tried to startup, this is the error message I get -

ORA-01081 Cannot start ORACLE that is already running - shut it down first

It seems to think that the shutdown is still in progress.  It does not let me resume shutdown process, either!


Also, when I try your suggestion to log on to SQL*Plus and connect as repository and try to reset the sysman password, I get this message:

SQL> execute smp_maintenance.reset_sysman();
BEGIN smp_maintenance.reset_sysman(); END;

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


Looks like I am getting myself deeper and deeper...

-Puja
0
 

Author Comment

by:pbisht
ID: 8226586
Thanks for responding so promptly!


Before I read your message, I tried to shutdown and startup the database.  The shutdown was taking a long time and was terminated abnormally (via Task Manager>End Task).  When I tried to startup, this is the error message I get -

ORA-01081 Cannot start ORACLE that is already running - shut it down first

It seems to think that the shutdown is still in progress.  It does not let me resume shutdown process, either!


Also, when I try your suggestion to log on to SQL*Plus and connect as repository and try to reset the sysman password, I get this message:

SQL> execute smp_maintenance.reset_sysman();
BEGIN smp_maintenance.reset_sysman(); END;

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible


Looks like I am getting myself deeper and deeper...

-Puja
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8226717
Hi Puja,

You should never end your oracle session from Task Manager. If you shutdown from SQLPlus and just say SHUTDOWN, it will wait for all connected sessions to terminate. You should do a SHUTDOWN IMMEDIATE or SHUTDOWN ABORT, the first one is a clean shutdown and the next is not. In your case you can still connect using SQLPlus and do a SHUTDOWN ABORT. The next time you do a STARTUP, recovery will be done and the database will come up cleanly.

0
 

Author Comment

by:pbisht
ID: 8227452
I am back up again.  I promise to myself - I'll never use Task Manager on Oracle again!

Situation right now is -
- Oracle Management Server is not started
    I tried to start it from Control Panel>Services
    and got this error:
    Could not start <Oracle Home>Management Server service
    Error 2140 : .. Windows NT internal error

- Obviously, I cannot log on to the Management Server

- I tried to reset sysman password from SQL*Plus
    Got this error while login:
    SQL> execute smp_maintenance.reset_sysman();
    BEGIN smp_maintenance.reset_sysman(); END;
 
    *
    ERROR at line 1:
    ORA-06553: PLS-213: package STANDARD not accessible

Any suggestions?  Thanks for all your help.
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8227530
At this point, I would suggest this :

1. From SQL Plus SHUTDOWN IMMEDIATE your database.
2. Change the service OracleManagementServer to startup manually.
3. Reboot your machine.
4. Check that the service OracleService<sid> is started.
5. From SQL Plus connect as SYS 'AS SYSDBA' and STARTUP your database.
6. Rerun $ORACLE_HOME/rdbms/admin/catalog.sql and catproc.sql as the SYS user. This will recreate your standard system packages.
7. execute smp_maintenance.reset_sysman();
8. From a DOS session : oemctrl start oms

and so on ...

0
 

Author Comment

by:pbisht
ID: 8247268
I did the steps thru step#5.

At step#6, I tried to run $ORACLE_HOME/rdbms/admin/catalog.sql and catproc.sql as the SYS user

The way I did that is -
run $ORACLE_HOME/rdbms/admin/catalog.sql
and
run $ORACLE_HOME/rdbms/admin/catproc.sql

In either case, I got this error message:
SP2-0103: Nothing in SQL buffer to run.

I still went ahead and tried the next step -
exec smp_maintenance.reset_sysman();

...got this error message...
BEGIN smp_maintenance.reset_sysman(); END;

*
ERROR at line 1;
ORA-06553: PLS-213: package STANDARD not accessible


Am I doing anything wrong?  Any suggestions?  Thanks a ton for all this help and patience!

- Puja
0
 

Author Comment

by:pbisht
ID: 8247278
In case you were wondering...
I did replace $ORACLE_HOME with the Oracle home directory path on the server.

- P :o)
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8247755
Hi Puja,

You cannot RUN a .sql script. Once you connect to sqlplus as SYS you can run the scripts like this :

C:\>sqlplus /nolog
Copyright info ....
SQL>connect sys@server as sysdba
Enter password:
Connected.
SQL>@c:\oracle\ora92\rdbms\admin\catalog.sql
....output....
SQL>@c:\oracle\ora92\rdbms\admin\catalog.sql
....output....

SQL>exec smp_maintenance.reset_sysman();

That should do it!
0
 

Author Comment

by:pbisht
ID: 8248378
Thanks ... I am going through it.

It looks good so far... will update you by tomorrow on full status!

Thanks a billion!
0
 

Author Comment

by:pbisht
ID: 8248795
Hi again, SDutta!

I was finally able to submit backup jobs, but the jobs are continuously failing.  I see the failures in the Jobs > History tab.  The reason for failure is:

VNI-2015 : The Node preferred credentials for the target node are either invalid or do not have sufficient privileges to complete the operation.
On Windows platforms, the Node credentials specified for the Windows target should have the "Logon as a batch job" privilege.

I have entered the preferred credentials for Database as well as Node as SYS/password.  Also, I am logged on as a domain administrator and I have checked to make sure that I have "Logon as a batch job" privilege.

What am I missing?

Thx!
Puja :o)
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8248913
There are two separate privileges involved here. Windows privilege and Oracle privilege.

Windows requires "Logon as a batch job" be granted to the user which connects through OEM. The username for this is setup through the Console.

After connecting to the console, go to : System > Preferences > Preferred Credentials

In ServiceType NODE setup the usercode and password for Windows. In ServiceType DATABASE setup the usercode and password for Oracle.

You can now reschedule your jobs and events.
0
 
LVL 10

Accepted Solution

by:
SDutta earned 200 total points
ID: 8249080
There are two separate privileges involved here. Windows privilege and Oracle privilege.

Windows requires "Logon as a batch job" be granted to the user which connects through OEM. The username for this is setup through the Console.

After connecting to the console, go to : System > Preferences > Preferred Credentials

In ServiceType NODE setup the usercode and password for Windows. In ServiceType DATABASE setup the usercode and password for Oracle.

You can now reschedule your jobs and events.
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8249111
By the way, connecting as a Domain administrator does not give you "Logon as a batch job" privilege. You have to grant it specifically from the "Administrative Tools" > "Local Security Settings" under "Local Policies" > "User Rights Assignment".

To make it simpler, you can grant it to the local administrators group which will also pass it on to a Domain administrator.

0
 

Author Comment

by:pbisht
ID: 8253769
I think I did that, but I will try again.  Thanks.  Will update you again.

- Puja :o)
0
 

Author Comment

by:pbisht
ID: 8264174
I was able to schedule a backup successfully.  However, when it starts running

1. If the Enterprise Manager (EM) console is open at the time when backup begins, I get a message that says ...

"The console was disconnected.. "

My choices are to -
"Relaunch Console" or "Cancel"

2. If I do not have EM console open when the backup begins, I do not get the message.

In both cases - the OMS service stops itself after backup is complete.  I have to start the service again and then log on to the EM console.  Also, I can see a new file in the location where I wanted to store the backups.  The process to backup doesn't take very long in case 1, but the sizes of the backup files are about equal (730MB) in both cases.

==========

Is that normal?  What if I have more than one job scheduled one after another?  If the OMS stops after one job is complete, how will the next job be executed?  Also, is it preferable to have the EM console closed while backups are going on?

Curiously,
Puja

0
 

Author Comment

by:pbisht
ID: 8271023
SDutta's comments were an immense help in getting this far!  Thanks a ton!

- Puja :o)
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8271114
Hi Puja,

Your console will be disconnected anytime the OMS goes down. But the OMS should never go down by itself. You can keep connected to the console irrespective of how many jobs you have submitted. I can't really tell why your backup completion is causing the OMS to go down. There may be trace files etc., being produced which may point you to the reason. Also since you PAQ'd this question you could ask this as a separate question so that others may be able to answer it too.

Thanks
SDutta
0
 

Author Comment

by:pbisht
ID: 8271500
I will put that issue (OMS shutting itself down) up as a separate question.  

Do you have any advice on how I can check to see if the backups that have been created recently are actually good?  I could try and restore from one of the backups, but that would probably overwrite my existing data.  How could I test the backup without affecting my current data?

- Puja
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8271700
You are correct in assuming that you can't really test the backups until you restore. And yes when you restore, it will overwrite your current database. For testing purposes you could install the same version of Oracle on another server and restore your backup there.
0
 

Author Comment

by:pbisht
ID: 8271838
Hmm... thanks.

That does make sense.  I will do that.  Thanks for all your help, SDutta.

- Puja :o)
0
 

Author Comment

by:pbisht
ID: 8328889
Hi SDutta,

Sorry to bug you... but, the topic is relevant and I cannot afford to wait for answers at this point.  Can I use the Export and/or Import utility if OMS is not installed and running?  I know that I don't need OEM to run Export or Import, but I don't think I can do it without OMS.  Am I right about this?

Also, there was a question about OMS at this site, maybe you would be interested in helping that person -
http://www.experts-exchange.com/Databases/Q_20584882.html

Thanks for all your help!

- Puja
0
 
LVL 10

Expert Comment

by:SDutta
ID: 8329305
Export and Import are standalone Oracle utilities and do not need any other software (OEM or OMS) to run. Only the database has to be up and running. Both these utilities are documented in Oracle Server Utility User's Guide.

You can run EXP.EXE or IMP.EXE directly from a windows command prompt. If you want to see the online help, enter parameter -h.

0
 

Expert Comment

by:srinika
ID: 8813775
Hi SDutta / Puja!
I have the same Q as Puja had earlier. I Posted my Q in this forum but didn't get a perfect answer!!
Can any one of u help me.
I'm sure Puja may now in a position to help me after going through the hard journey

I'm a newbie to Oracle DBA
I installed Oracle 9i in my machine (Win 2k). I created 2 databases in the machine called SriOra & SriOra3. I tried to do a backup. Unsuccessful.

But I went through a Q & A in this site of SDutta & Puja and followed that.

Still I'm wondering about the way to perform Backup using the WIZARD.
       (I don't want it to be done by RMAN or EXP)
========================================
I tried to do Backup by using the Wizards ( In Menus of OEM & OMS )
Try 1.  OEM - Standalone - Network - Database (By right clicking)- BackupManagement
           - Stopped giving the msg : ... connect to OMS before launcing wizard ....
Try 2.  Launched OMS (by -- oemctl start oms sysman/p -- in cmd prompt) and Started and
           Logged on to OMS (by sysman/p as UN/Pwd). Then Opened another OEM session
          OEM - Standalone - Network - Database (By right clicking)- BackupManagement
           - Stopped giving the msg : ... connect to OMS before launcing wizard ....
          -----  SAME RESULTS OF TRY 1 -----
Try 3.  Launched OMS (by -- oemctl start oms sysman/p -- in cmd prompt) and Started and
           Logged on to OMS (by sysman/p as UN/Pwd). Then Used OMS and tried to do the
           backup from there (by means of logging to database and right clicking and getting
           the Backup Management ...)
          -- Still Not Working --

The above tries were done with the all of the following for the 2 databases (that I created)
- system/manager,    system/p (the pswd  to which I changed )
- sys/change_on_install,    sys/p (the pswd  to which I changed )
- sysman/oem_temp,    sysman/p (the pswd  to which I changed )
- srinika/xxx, [The Win2k username & pswd in my machine]

- At one stage I tried to create a repository by Enterprise Manager configuration assistant
  (not sure what it has to do)

- In one publication I read about  -- not to change the sysman password from oem_temp or
   not to change the sys password from change_on_install -- - Is that correct ?

Thanking again for ur presious time
Regards
Srinika
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question