| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> internal password & init.ora
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 Tue Aug 18 1998 - 03:49:10 CDT
![]() |
![]() |