Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 Mon Aug 17 1998 - 04:31:32 CDT
![]() |
![]() |