10g Startup Mount

[robertbalmer]

OS: WIN2000
DB:10G 1

I want to move(copy) my undo datafile to another location.

As you know I need to do a shutdown,copy to new location, open in mount,alter database .... and backup controlfile to trace.

The problem is when I mount the database I get this "FRIKKEN LASER BEAM ON A SHARP" error
---------------------------------------------------------------
SQL> STARTUP MOUNT PFILE=C:\Oracle\product\10.2.0\admin\10GTEST\pfile\INIT.ORA.2
29200611850
ORACLE instance started.
ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA

SQL> CONN SYS/SYS@10GTEST AS SYSDBA
ERROR:
ORA-01017: invalid username/password; logon denied

-----------------------------------------------------------------
"It seems that this is a common error on 10G if you do a shutdown immediate - startup mount." -http://ora-600.ora-code.com/bbs/View?grp=Oracle_List&msg=2b9bf082b76e7d6f539e1826c6e2b0b4

I really need to startup in MOUNT mode as you cannot take the UNDO offline.

Is there someting I'm

missing here. The sys password is sys!!


Thanks for your assistance in advance

[oracli]

You don't need to do backup controlfile to trace. You just do:

1. shutdown immediate
2. move the file
3. startup mount
4. alter database rename file '' to '';
5. alter database open

in you statement for startup with pfile it seems you are using some other version of the ini file? what exactly are you doing?

[KenCunningham]

Can't you simply sqlplus "/ as sysdba"?

[robertbalmer]

BACKUP CONTROLFILE TO TRACE is beside the point.
If I'm in MOUNTED mode -see my error - I loose connection/authentication to Oracle. I want to solve that problem.

I cannot ALTER DATABASE if i loose connection and cannot connect again.
A normal STARTUP MOUNT I get the same problem.

[robertbalmer]

Ken

If the database is open then i have no problem. I can conn as sys/sys or / .
Working from MOUNTED mode I just cant get in???

[oracli]

Kill the oracle process and start from scratch.

sqlplus / as sysdba (use this to eliminate any problem you might experience with the password file)
startup mount

[robertbalmer]

I actually killed everything including all developers and hardware managers.

As this is a test database I have some freedom.

Thanks 4 your assistance

[KenCunningham]

"I actually killed everything including all developers and hardware managers."

Excellent - what method of execution did you use? There are a few developers and managers around here I would like to exterminate too!!

[robertbalmer]

HEHE

The middle finger method!!

I resolved the problem. My problem was my listener config that was corrupted. I used my old 9i2 listener configuration to duplicate the listener.ora. However,I still do not know the reason why 10G could not configure it correctly using the UI.