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

Home -> Community -> Usenet -> c.d.o.misc -> Re: INIT.ORA - UTL_FILE_DIR parameter...

Re: INIT.ORA - UTL_FILE_DIR parameter...

From: Van Messner <vmessner_at_netaxis.com>
Date: Mon, 22 Nov 1999 20:01:12 -0500
Message-ID: <lIl_3.38242$YI2.1910099@typ11.nn.bcandid.com>


Your init.ora file is just a text file. Once you locate it you can change it with any text editor. Then shut down the database and restart it. Your new parameters will be used on restart. You can check them using v$parameter in SQL*Plus.

Van

Michael Rosadino <mrosadino_at_yahoo.com> wrote in message news:81cmnm$5s9_at_news1.snet.net...
> Hey Folks:
> Can you tell me what needs to be done to change the setting for the
> UTL_FILE_DIR initialization parameter? As I understand it, this parameter
> requires a database shutdown under version 8.0.4. Unfortunately, I can't
> seem to shut down the database using my "SYS" or "SYSTEM" user accounts
due
> to "insufficient privileges" so I must use the "internal/password" login
to
> do so through the command line server manager, i.e., SVRMGR30. So I shut
> down using this user account. But then the problem becomes that of
changing
> the parameter setting, and using the Enterprise Instance manager I'm not
> able to connect using the "internal/password" login so therefore I can't
> change the parameter setting. So what is the solution?
> Thanks in advance for any help you can provide,
> =================================
> Michael Rosadino
> Email (w): mrosadino_at_med-ecom.com
> Email (h): mrosadino_at_yahoo.com
>
>
Received on Mon Nov 22 1999 - 19:01:12 CST

Original text of this message

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