From: JATHAR.PRAVIN@mahindra.com
Date: Tue Apr 29 2003 - 04:12:35 EDT
Thanks to Piotr.Kolacz,Schie, Casper van,
We got the soln, due to control file, we are unable to logged in.
----------------------------------------------------
or use internal/nopassword
-----Original Message-----
From: JATHAR.PRAVIN@mahindra.com [mailto:JATHAR.PRAVIN@mahindra.com]
Sent: Tuesday, April 29, 2003 9:01 AM
To: hpux-admin@DutchWorks.nl
Subject: [HPADM] Oracle 8 passwd (Urgent )
Importance: High
------------------------------------------------
usually after instalation you have default
system/manager
sys/changeoninstall (I don't remember very well may be it is
change_on_install)
Peter
----------------------------------------------------
Hello Pravin,
This error can only be solved by bringing the control file(s) in sync with the datafiles. The database will not open as long as the control file(s) and the datafiles does not match.
When the database is open you can logon on the database server using the internal database account and then change user system's password.
Praivn Jathar
> -----Original Message-----
> From: JATHAR PRAVIN
> Sent: Tuesday, April 29, 2003 12:31 PM
> To: hpux-admin@DutchWorks.nl
> Subject: [HPADM] Oracle 8 passwd (Urgent )
> Importance: High
>
> Dear Sir,
>
> We forgot the system user passwd of oracle. Also we tried by scoot/tiger it is not working. If you have any soluation for the same. Please let me know.
>
> See below are used commands & error.
>
> SVRMGR> shutdown normal
> ORA-01109: database not open
> Database dismounted.
> ORACLE instance shut down.
> SVRMGR> startup open
> ORACLE instance started.
> Total System Global Area 4800644 bytes
> Fixed Size 69764 bytes
> Variable Size 4247552 bytes
> Database Buffers 409600 bytes
> Redo Buffers 73728 bytes
> Database mounted.
> ORA-01122: database file 1 failed verification check
> ORA-01110: data file 1: '/d28/ora/dbs1/oradata/ordb/system01.dbf'
> ORA-01207: file is more recent than controlfile - old controlfile
>
> Thanks in advance.
> Regards,
> Pravin
>
> --
> ---> Please post QUESTIONS and SUMMARIES only!! <---
> To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
> Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
>
> Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
> http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
>
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:29 EDT