Standby instance: Ora-01033 when changing passwort
CasimirMay 26 2008 — edited May 27 2008Hello
I build up an standby instance which I would like to as^dd in Grid Control. As you know, the standby instances is mounted, but not opened.
This state leads to an error when trying to change dbsnmp's password:
----------------------------------------
oracle@sksta90271 [IARTSBY]:~> sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Mon May 26 09:13:36 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> alter user dbsnmp identified by test;
alter user dbsnmp identified by test
*
ERROR at line 1:
ORA-01109: database not open
SQL>
----------------------------------------
I need to set dbsnmp's password to add the instance in Grid control. How to do this?
Thanks Casi