Re: internal password & init.ora

Also, you can't change the DB_BLOCK_SIZE, unless you recreate the database.

In article <35e625c0.2906369_at_news.earthlink.net>,   paulrahe_at_earthlink.net (Paul Rahe) wrote:
> You can change the INTERNAL password by using the Windows NT Instance
> manager. Be sure to use the NT Instance manager and not the Oracle
> Instance manager to change the INTERNAL password.
>
> On Tue, 18 Aug 1998 08:49:10 GMT, violin.hsiao_at_mail.pouchen.com.tw
> (Violin) wrote:
>
> >Hello,
> >I have 2 questions,maybe someone can help me again!
> >My database in Oracle7.3 on NT4.0(workgroup database!),
> >
> >Q1.How to change the internal password??
> > I found 1 files,one is strtorcl.cmd and I change it as:
> > d:\orant\bin\oradim73.exe -startup -sid ORCL -usrpwd TESTPWD
> > -starttype srvc,inst -pfile d:\orant\database\initorcl.ora
> > Then execute strtorcl.cmd,but when I connect internal,
> > the new password doesn't work(msg:insufficion privilege).
> > Internal password is still oracle.
> >
> > Then I invoke svrmgr,connect sys/password,use alter user command:
> > ALTER USER "internal" IDENTIFIED BY TESTPWD;
> > But response:ORA-01918:user "internal" not exist.
> > Please: How to change internal password?
> >
> >Q2.How to expand SGA?
> > I want to expand my SGA size,with changing initorcl.ora:
> > db_block_buffers = 6400
> > shared_pool_size = 10000000
> > processes = 100
> > log_buffer = 245760
> > db_block_size = 2048
> > Then I startup nomount; -> alter mount; -> alter open.
> > It succesfully.
> > But when I want to change the db_block to 4096,
> > startup nomount -> alter mount,there's an error:
> > ORA-00058:db_block_size ??? 2048 ( ??? 4096)
> > ORA-09241:error allocating SGA memory.
> > How to change the db_block_size to 4096??
> >
> > Then I try to expand db_block_buffers = 12800 (db_block_size=2048)
> > startup nomount -> ORA-02941:error allocating SGA memory.
> > How to measure the right value when it exceeds LARGE value?
> >
> > Please give me some tips,Thank you so much!!
> > Please Cc to : violin.hsiao_at_mail.pouchen.com.tw :)
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 28 1998 - 17:15:21 CDT