Re: internal password & init.ora

On Mon, 17 Aug 1998 09:31:32 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?
>

You could try this.

 From the command prompt or from RUN you will need to run the password manager and set the database password

\ORANT\BIN\ORAPWD73 FILE=\ORANT\DATABASE\PWD<ORACLE_SID>.ORA PASSWORD=< Your Password >

Hope it works...!!

Ananth
ananth_at_mtc.com.kw
>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 Mon Aug 17 1998 - 23:50:16 CDT