Re: internal password & init.ora

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 :)
Received on Thu Aug 27 1998 - 22:38:07 CDT