Home » RDBMS Server » Server Administration » Value of parameter from V$parameter
Value of parameter from V$parameter [message #227113] Tue, 27 March 2007 06:19 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
When i am selecting value for parameter user_dump_dest from v4parameter i am getting some value but when i am seeing value of this parameter in init.ora file it is some other value and i dont have spfile also i m using pfile only.
Re: Value of parameter from V$parameter [message #227116 is a reply to message #227113] Tue, 27 March 2007 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the query you've done and its result.
Post the same query with v$system_parameter instead of v$parameter.
Post the result of "grep user_dump_dest $ORACLE_HOME/dbs/init${ORACLE_SID}.ora" or any other init.ora file you used.

Btw, post your Oracle version (should be a minimum when someone post a question).

Regards
Michel
Re: Value of parameter from V$parameter [message #227129 is a reply to message #227116] Tue, 27 March 2007 07:11 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

A good idea is probably that you read about the relationships between v$parameter, v$spparameter, pfile etc.

"Google"
Re: Value of parameter from V$parameter [message #227143 is a reply to message #227129] Tue, 27 March 2007 07:39 Go to previous messageGo to next message
kukreja
Messages: 33
Registered: February 2007
Member
I am not using spfile I have only one pfile i.e init.ora file and value of parameter in v$parameter and init.ora is not matching. if I am querying v$spparameter it is blank.
Re: Value of parameter from V$parameter [message #227144 is a reply to message #227143] Tue, 27 March 2007 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And you don't have any answer on my questions?

Re: Value of parameter from V$parameter [message #227147 is a reply to message #227143] Tue, 27 March 2007 07:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
There are three files,


TYPE     SPFILE BINARY FILE
NAME     SPFILE<SID>.ORA 
LOCATION $ORACLE_HOME/DATABASE/

TYPE     PFILE ASCII FILE
NAME     INIT<SID>.ORA
LOCATION $ORACLE_HOME/DATABASE/

TYPE     PFILE TEXT FILE
NAME     INIT.ORA
LOCATION $ORACLE_BASE/ADMIN/PFILE/



Now which file are you looking...

regards
Taj
Re: Value of parameter from V$parameter [message #227159 is a reply to message #227116] Tue, 27 March 2007 08:03 Go to previous messageGo to next message
kukreja
Messages: 33
Registered: February 2007
Member
Sorry sir for late reply
select value from v$parameter where name='user_dump_dest'

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
user_dump_dest string
/SLOTS/slot05/appmgr/app/appmg
r05/product/11.1.0/db_1/log/di
ag/rdbms/prodr12/PRODR12/trace

same value is given when i query v$system_parameter
Actually this database was first at 10g and then we upgraded it to 11G so in init.ora it is showing the location of 10G structure
/SLOTS/slot05/appmgr/ProdR12/db/tech_st/10.2.0/admin/ProdR12_ap6020rt/udump
Re: Value of parameter from V$parameter [message #227162 is a reply to message #227159] Tue, 27 March 2007 08:07 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

To 11G ??
Re: Value of parameter from V$parameter [message #227163 is a reply to message #227162] Tue, 27 March 2007 08:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

To 11G ??
Actaully i also surprised but may be it is Oracle Application.
Re: Value of parameter from V$parameter [message #227164 is a reply to message #227163] Tue, 27 March 2007 08:12 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Mohammad Taj wrote on Tue, 27 March 2007 15:11
To 11G ??
Actaully i also surprised but may be it is Oracle Application.


Better be Razz
Re: Value of parameter from V$parameter [message #227200 is a reply to message #227159] Tue, 27 March 2007 09:10 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe you are not starting the database with the init.ora file you think.
How do you start it?

Regards
Michel*
Previous Topic: problem in sending mails through oracle
Next Topic: deleted record
Goto Forum:
  


Current Time: Fri Dec 09 03:55:43 CST 2016

Total time taken to generate the page: 0.14158 seconds