How to Include Line in Spfile

[ricardofazu]

Environment information:
* Oracle version: 10g
* Operating system: Centos
I need to include the line: 07_DICTIONARY ACCESSIBILITY scope=TRUE But I can not remember how to include? I also do not remember if it is in spfile or init.ora

[gilbertoca]

[url=http://www.orafaq.com/parms/parm8.htm]Que parametro é esse!
[url=http://en.glufke.net/oracle/viewtopic.php?p=15000#14989]Como verificar e ajustar

Do tb a forum search, there is much more information here!

Gilberto

[ricardofazu]

When I go to SQLPlus by Shel and Digito Conn Sys from this error:

Select all

Enter user-name: sys 
Enter password: 
ERROR: 
ORA-12154: TNS:could not resolve the connect identifier specified

But I have already inserted this line, the problem now is that I can not give the EXP UserID command ........ The error appears:

Select all

[oracle@cmaaora1 ~]$ exp userid=sys/senha@banco owner=usuario file=/u01/nome_do_arquivo.dmp full=y 
 
Export: Release 10.2.0.1.0 - Production on Wed Jan 14 13:46:02 2009 
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved. 
 
 
EXP-00056: ORACLE error 12154 encountered 
ORA-12154: TNS:could not resolve the connect identifier specified 
EXP-00000: Export terminated unsuccessfully

But when I give the Exp.

Select all

array.....4096 
user=fulano

The dump wheel beauty

can help me

[ricardofazu]

Correcting, I do not give the Exp UserID command .... in SQLPLUS and yes in the direct shel

[gilbertoca]

This problem is connection! In the DBA room, it has a topic [url=http://en.glufke.net/oracle/viewtopic.php?t=2439]fixo that gives tips on how to get around / understand connection problems with Banco Oracle.

Gilberto

[ricardofazu]

Okay, thanks for the guidance.

[dbacesar]

Good morning,

to change the spfile you need to change the pfile and recreate the spfile from the pfile.

Select all

create spfile from pfile;