Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> internal password & init.ora

internal password & init.ora

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Mon, 17 Aug 1998 09:31:32 GMT
Message-ID: <35d7ecd2.786861@news.twsc.pouchen.com.tw>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US