how change value spfile on oracle 10G
MrEthanHunt@gmail.com - 12-11-2006 00:38
how change value spfile on oracle 10G
Hi Group.....
I am new in oracle and need change the spfile parameter value on
v$parameter view, I Looked information and found the following:
The change must be done with "Alter system".
I execute:
SQL> alter system set
spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS _XE_SPFILE';
nevertheless it gives back :
alter system set
spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS _XE_SPFILE'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
¿How change the famous parameter ?
Thanks in advance.....
dap - 12-11-2006 00:38
MrEthanHunt@gmail.com wrote:
> Hi Group.....
>
> I am new in oracle and need change the spfile parameter value on
> v$parameter view, I Looked information and found the following:
> The change must be done with "Alter system".
>
> I execute:
>
> SQL> alter system set
> spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS _XE_SPFILE';
>
>
> nevertheless it gives back :
>
> alter system set
> spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS _XE_SPFILE'
> *
> ERROR at line 1:
> ORA-02095: specified initialization parameter cannot be modified
>
> ¿How change the famous parameter ?
>
> Thanks in advance.....
Holla...
You have to start oracle with normal pfile, then convert to spfile, or
from spfile to pfile.
startup
create pfile from spfile ;
or
startup
create spfile from spfile ;
startup force ;
Usually on Linux/Unix Oracle search pfile/spfile in $ORACLE_HOME/dbs, on
Windows in $ORACLE_HOME\databases (I think so).
If you have both Oracle will use spfile.
dap
--
,= ,-_-. =. gnu.org
((_/)o o(\_)) polanski.biz
`-'(. .)`-' xoops.pl
\_/
LoLe - 12-11-2006 01:29
Uzytkownik <MrEthanHunt@gmail.com> napisal w wiadomosci
news:1158934056.772145.81190@k70g2000cwa.googlegro ups.com...
Hi Group.....
I am new in oracle and need change the spfile parameter value on
v$parameter view, I Looked information and found the following:
The change must be done with "Alter system".
Example
alter system set db_cache=160M scope = spfile;
or
change the parameter in pfile and recreate spfile using this:
conn / as sysdba
create spfile="patch to spfile" from pfile="patch to pfile";
shutdown immediate;
startup;
zanotowane.pldoc.pisz.plpdf.pisz.pleffulla.pev.pl
|
Oracle, SQL, PL/SQL. Jak =?ISO-8859-2?Q?napisa=E6_zapytanie=2C?==?ISO-8859-2?Q?_kt=F3re_zwr=F3ci_nazw=EA_atrybutu=2C_kt=F3reg o?==?ISO-8859-2?Q?_warto=B6ci_spe=B3niaj=B1_zadany_warunek?=
Oracle 19g +Insert +Insert +Insert...
[oracle] zapytanie dynamiczne z =?ISO-8859-2?Q?=22dynamiczn=B1_?==?ISO-8859-2?Q?nazw=B1_tabeli=22?=
[Oracle] jak =?ISO-8859-2?Q?ograniczy=E6_pami=EA=E6_dla_se?==?ISO-8859-2?Q?rwera=3F?=
=?ISO-8859-2?Q?=5BOT=5D_Zdany_egzamin_Oracle_1Z0-007_a?==?ISO-8859-2?Q?_brak_informacji_na_stronie_Prometric_-_czy?==?ISO-8859-2?Q?_co=B6_nie_tak=3F?=
[oracle] czy da =?ISO-8859-2?Q?si=EA_z_poziomu_procedury_?==?ISO-8859-2?Q?zrobi=E6_kopi=EA_zapasow=B1=3F?=
MSSQL Express czy Oracle Express
=?iso-8859-2?q?[oracle]_Jak_sprawdzi=E6_wielko=B6=E6_tabeli_=3F=3F?=
=?ISO-8859-2?Q?Poszukjue_ksi=B1=BFki_"Oracle_?= =?ISO-8859-2?Q?optymalizacja_wydajno=B6ci"..?=
[Oracle] =?ISO-8859-2?Q?=A3=B1czenie_wierszy_z_zapytania_?==?ISO-8859-2?Q?w_jeden_string?=
zanotowane.pldoc.pisz.plpdf.pisz.plradioaktywni.htw.pl
Cytat
Decede mihi sole - nie zas³aniaj mi s³onca.
Gdy kogo¶ kochasz, jeste¶ jak stworzyciel ¶wiata - na cokolwiek spojrzysz, nabiera to kszta³tu, wype³nia siê barw±, ¶wiat³em. Powietrze przytula siê do ciebie, choæby by³ mróz, a ty masz w sobie tyle rado¶ci, ¿e musisz j± rozdawaæ woko³o, bo siê w tobie nie mie¶ci
Hoc fac - tak czyñ.
A tergo - od ty³u; z ty³u.
I czarne w³osy posiwiej±. Safona |
|
