Server Administration :: Pfile Very Small

Jun 26, 2011

When creating manually a pfile from an spfile

create pfile ='mypfile.ora' from spfile;

I noticed that many parameters are missing in the generated pfile, there are just some 20 parameters instead of 250 ! where are the others ?

View 3 Replies


ADVERTISEMENT

Server Administration :: DBname Changed From Pfile?

Apr 17, 2013

I am having few confusion on dbname, sid & tnsname.

rman target sys/oracle@suman auxiliary /

In the above command, "suman" is SID or Tnsname or dbname?

Bimistake, in my test database, i tried to change the DBname to suman from sumandb in pfile. After changing, i tried to startup database in nomount pfile but oracle through error that, unable to locate control file. Then, i remove the control files and tried to start database with nomount. Oracle through error about the control file.

This database, i had installed through DBCA. I want to know, where are all places where DBname reside?

Can i start database through pfile even if it is created through DBCA?

View 4 Replies View Related

Server Administration :: Creating Spfile From Pfile Error

Jun 25, 2011

whenever i tried to create spfile from pfile i got this error...oracle not available and shared memory realme does not exist.

View 10 Replies View Related

Server Administration :: Switch Database From Pfile To Spfile

Sep 29, 2011

I have a database started using pfile and spfile parameter shows NULL from command prompt as below:

******************************************************************
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
*****************************************************************

Now when I want to change/switch database to start using SPFILE, can I do it with out restarting (shutdown and startup)the database.

View 2 Replies View Related

Server Administration :: Database To Startup With PFile - Failure In Processing System Parameters

Feb 8, 2011

I successfully created a DB manually with PFILE.

I want the DB to startup with SPFILE at next login.So i fired the below command.

CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.

But it shows the error as below:

ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.

View 20 Replies View Related

Server Administration :: Value Of Sga-target Too Small?

Jun 8, 2013

How can i increase the sga_target in this case.Im unable to create a pfile.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-00821: Specified value of sga_target 2048M is too small, needs to be at least 4112M
SQL> startup nomount

[code]...

The $ORACLE_HOME/dbs location has a spfile.

more initQR01MRA1.ora
SPFILE='+DB_DATA/QR01MRA/spfile'

View 2 Replies View Related

Server Administration :: ARC File Size Too Small?

Oct 2, 2012

I noticed my DB is generating a lot of "small" .arc files and I am usure why. As you can see from the v$log query my log file size is set to 50MB. But yet BLOCKS*BLOCK_SIZE never adds up to 50MB.

Is there anything else I can look into to see how to make the .arc files larger?

SQL> select group#, thread#, bytes from v$log;
GROUP# THREAD# BYTES
---------- ---------- ----------
1 1 52428800
2 1 52428800
3 2 52428800
4 2 52428800

select blocks, block_size, blocks*block_size from v$archived_log where sequence# between 63876 and 72851 and thread# = 1

BLOCKS BLOCK_SIZE BLOCKS*BLOCK_SIZE
---------- ---------- -----------------
28 512 14336
28 512 14336
28 512 14336
55 512 28160

[code]...

View 18 Replies View Related

Server Administration :: Rollback Segment Too Small ORA-01555

Jan 19, 2012

One of the users received the error
ora-01555: rollback segment too small

I have read about the error and saw that it is caused by transactions made upon same data, filling to maximum one of the UNDOTBS rollback segments.It happens only once in a while, each time on a different Rollback Segment.

I've read that i should do a few things to enlarge those segments, such as bring a 1. segment offline, 2. drop it and then 3. create it with a bigger size & possibly a bigger extent setting

i've also read that those actions aren't relevant if you have the parameter UNDO_MANAGEMENT set on AUTO, which is actually the case.is that why when i execute ALTER ROLLBACK SEGMENT RB_SEG_NAME_11$ OFFLINE;

1. How do i solve my issue with the Rollback segment being too small to contain the snapshot with the requested SCN?

2. what does the parameter UNDO_MANAGEMENT mean? should i change it, in order to adjust my Rollback Segments attributes, to prevent my error of re-occurring?

View 10 Replies View Related

Server Administration :: Big Datafile Vs Multiple Small Datafiles

Jun 17, 2010

what's the difference between having BIG datafile (32GB) vs many small datafiles (4GB) replacing a Big one.

View 3 Replies View Related

Normal Pfile With Many Parameters In Pfile That Can Be Changed

Jan 22, 2013

I have issued to create pfile from spfile. When I run the create command it is done successfully but in my pfile content has only one parameter of *.SPfile='D:apporacleproduct11.2.0dbhome_1databaseSPFILEORCLE1.ORA'

I want to have a normal pfile with many parameters in the pfile that it can be changed.

View 17 Replies View Related

Pfile And Spfile - Getting Error?

Jan 28, 2013

Suppose my Prod Database is up and accidentally my pfile deleted. what will happen to my prod database whether it wil fail the instance or any error . as per concept that i know pfile accessed when we nomount the database for initialization of database.(11g)

in case of SPFILE

Suppose my spfile deleted and previously my database was in up condition. what will happen to my instance if i am working in a OLTP/DSS environment.(i dont have backup also how to recover and work in 11g if instance failed)

View 12 Replies View Related

Enterprise Manager :: Unable To Bring Up OEM When Using Different Pfile

Jun 5, 2010

what is missing in this pfile that would cause enterprise manager not to appear ?

In the Oracle Database 10g: Administration Workshop II The chapter 8 excercise calls for the database to be started using the pfile init_sgalab.ora . The purpose of this I suppose is to simulate a memory error.

When I get to the part where I need to use OEM to fix the problem, OEM does not come up. The contents of init_sgalab.ora are :
--------------------------------------------
background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
compatible='10.2.0.1.0'
control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl /control03.ctl'
core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
db_block_size=8192
[code].......

I am not sure what is missing in this file to be able to bring up OEM.

Also, I looked at the logs and this is the only error message I found that might be relevant in

/u01/app/oracle/product/10.2.0/db_1/jhlinux.home.com_orcl/sysman/log/emoms.log

2010-06-04 23:33:59,809 [HttpRequestHandler-8546123] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://jhlinux.home.com:3938/emd/main)(ERROR = INTERNAL_ERROR)

View 24 Replies View Related

Setting Memory Parameter Values In Pfile

Nov 24, 2012

If I have to create a database on server which has already 5 databases running , how will I set the memory (pga,sga) values . AFAIK it depends on o/s is linux and database version is 10g and 11g .

1)free avaialble memory on server .
2)kernel parameters .

what else has to be considering while initialize memory parameters .

View 6 Replies View Related

SQL & PL/SQL :: Query To Check Database Running Using Spfile Or Pfile

Nov 23, 2011

provide me the query to check our database is running using spfile or running using pfile.

View 2 Replies View Related

Enable / Disable Archive Mode From The Pfile In Oracle 10g?

Jul 12, 2012

I am using oracle 10g. Is there any mechanism to / parameter to enable or disable archive log mode? can I enable arching directly from pfile without touching the startup process?

View 2 Replies View Related

Pinning Small Tables In SGA?

Aug 23, 2010

I have a 10g database and on a specific day of everymonth, a query appears to cause a performance issue. As i have analyzed, there are two small tables of 11MB in size and the query goes for higher number of executions/gets/reads/elapsed time etc. So as the tables are very small in size, i am planning to pin both of these tables in SGA buffer pool keep memory. I need few clarifications...

*These tables are Dynamic in nature and the row data tends to change everyday. If i pin these objects in Keep buffer pool, will this dynamic changes to the table made also be reflected in the pinned buffer pool?

*Will this have any adverse effect?

*My SGA_TARGET is set equal to SGA_MAX_SIZE which is 1532MB. Do i need to change any memory setting before pinning these objects?

*On every restart of the database, do i need to again execute the pin commands for these objects.

View 1 Replies View Related

SQL & PL/SQL :: Retrieve Host Name For Small App

May 12, 2010

I have a cluster setup, and i want to retrieve host name for my small app.Is there any query which gives me the HOSTNAME where oracle is running??

View 14 Replies View Related

Small Extent Sizes In 11.2.0.3

Aug 12, 2013

I did some google searches about large number of extents and ASSM. I see bits and pieces on the web. This is something I need to look at while testing an application. Not looking to go into 'why' I would use smaller extents, I just want to make sure I have what I need to look for during testing..Issues with massive numbers of extents: 

1. DBA_EXTENTS query is really slow.
2. issues truncating tables (due to having to read lots of extents)
3. issues splitting maxvalue partitions and with dropping partitions.
4. if I stay away from ASSM, would this reduce these issues?  Are there any other performance issues or other issues I need to know about to check when I do tests?

Any issues with query or insert wait time? The tables that would get smaller events would have thousands of partitions/sub-partitions . Most of these sub-partitions will be rather smaller.I  just want to test for a variety of different cases. The 'why' will come out during testing.

View 3 Replies View Related

Support Dram SSD For Small Database

Mar 15, 2011

I read the Website URL....and searching now for an alternative way for a small Oracle DB around 120 - 250 GB Data.I cant find any DRAM SSD that seems to suite the needs of such a small amount of data to a valuable price.

The only Hdd i found is URL... but im not sure if thats the right thing and if its possible to still buy such a device.where do we get such a device in Europe(swiss) and what would be the price for such a device?

Do i need to make a special setup within oracle (11g R2) to get the maximum out of such a DRAM SSD?

View 1 Replies View Related

SQL & PL/SQL :: Character String Buffer Too Small?

Dec 14, 2012

I'm trying to create a table with a select statement. I want to populate this new table with the aggregated value from a VIEW. Following is the code used for creating the VIEW,

create or replace view FINAL_WEB_LOG
as
select SESSION_ID,
SESSION_DT,
C_IP,
CS_USER_AGENT,
tab_to_string(CAST(COLLECT(web_link) AS t_varchar2_tab)) WEBLINKS
from web_views_tab
group by C_IP, CS_USER_AGENT, SESSION_DT;

I want to create a table with WEBLINKS and SESSION_ID which is a sequence from another table.

CREATE TABLE FINAL_WEB
AS
SELECT weblinks
FROM final_web_log
UNION
SELECT session_id
FROM WEB_VIEWS_TAB;

This now gives me the following error,

SQL Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

This has to do with the field, Weblinks, it does have longer values.

View 5 Replies View Related

SQL & PL/SQL :: Divide Sting Into Small Strings

Aug 7, 2010

I have a string:

"This is just for testing 123.
This is just for testing 45654.
This is just for testing 5567876.
This is just for testing 53456547.
This is just for testing 123423.
This is just for testing 98090.
This is just for testing 099473.
This is just for testing.
This is just for testing.
This is just for testing 3.
This is just for testing 34983245983.
This is just for testing 6432."

I need to divide this sting after every 100 characters, as the length of column to insert is 100. And i do not want to modify the column as it has great impact. I need to divide the string, such that it should be less then 100 characters also the string is not cut in between.

like:
first string: "This is just for testing 123.
This is just for testing 45654.
This is just for testing 5567876."

then 2nd string: "This is just for testing 53456547.
This is just for testing 123423.
This is just for testing 98090."

then 3rd string: "This is just for testing 099473.
This is just for testing.
This is just for testing.
This is just for testing 3."

View 6 Replies View Related

Rollback Segment Number 2 With Name _SYSSMU2$ Too Small

Nov 3, 2010

While taking backup of schema using Expdp, I got the following error on one of the tables in the schema due to which export for this table could not be done.

Re: ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too small.

Undo retention time is 14400 sec and Undo Tablespace is Auto Extensible. Table to be exported contains 100 crore rows.

View 1 Replies View Related

Export 20 Small Records From One Table In 9i Into XML File

Aug 26, 2008

I need to export 20 small records from one table in Oracle 9i into an xml file. Each record has 4 fields. what the command would be in sql plus.

View 1 Replies View Related

ORA-06502 Character String Buffer Too Small When Called From C# App

Apr 26, 2007

I have researched this problem and checked my variable sizes over and over again. I have tested the procedure within the Oracle Express environment and it works fine; HOWEVER, when the procedure is called from my C# app it produces the ORA-06502 error.

The stored procedure signature looks like this...

Original - SQL Code

create or replace save_new_project (p_custorgid in number,
p_title in varchar2,
p_AOIName in varchar2,
p_description in varchar2,
p_receiveddate in date,
p_deadlinedate in date,
p_startdate in date,

[code]....

The OracleParameter in my C# app for the last out param is defined as such...

cmd.Parameters.Add(new OracleParameter("p_statustypedescrip", OracleDbType.Varchar2, 30, ParameterDirection.Output));

As I said at the beginning of this post, the procedure works fine in the Oracle environment. So why is it not working by simply calling it from C#? I've tried changing the OracleDbType to CLOB which eliminates the error but it returns a bizarre result. It returns this string, "Oracle.DataAccess.Types.OracleClob".

Since CLOB doesn't really work either I switch back to Varchar2 and specify a size of 5000 (in the database the field I am querying is defined as Varchar(30)). I still get the ORA-06502 error.

I am clueless as to what the problem is. It should work and it does if I run a series of SQL statements in an Oracle SQL Command window. The test that works fine looks like this...

Original - SQL Code

declare
v_projid projects.projectid%type;
v_statustypedescrip projectstatustypes.type%type; /* this is a varchar(30) */
begin
save_new_project(2, 'Some input text goes here', 'More input text', 'And more again','26-APR-2007','26-APR-2007','26-APR-2007','26-APR-2007','users name as inpujt text

[code]....

But calling save_new_project from C# throws ORA-06502. It identifies line 40 of my stored procedure. This is line 40...

Original - SQL Code

p_statustypedescrip := v_statustypedescrip;

p_statustypedescrip := v_statustypedescrip;

View 4 Replies View Related

PL/SQL - Numeric Or Value Error / Character String Buffer Too Small

May 24, 2011

when I want to create a table.When I run my procedure I received :
PL/SQL: numeric or value error: character string buffer too small

create or replace PROCEDURE p_create_tmp_tables (p_result OUT NUMBER ) IS
string_sql varchar2(1000);
result NUMBER;
BEGIN
string_sql := 'CREATE TABLE TMP_CATEGORIES (CODE_CATEGORY NUMBER(6,0), NAME_CATEGORY VARCHAR2(25 BYTE))';
execute immediate string_sql;
[code]...

View 10 Replies View Related

SQL & PL/SQL :: Very Long Query With Ref Cursor - Buffer Too Small Error

Jun 21, 2011

I want to pass a damn long query(which includes a lot of column names, tables, joins, union, where clauses etc. and whose length is more than 120000) in a Ref cursor (that's length is more than 32767). Query is stored in a LONG type variable V_QRY in stored procedure, and I am opening that ref cursor like below-

OPEN P_RPT_TEST FOR V_QRY;

at run time its giveing string buffer too small error.

View 7 Replies View Related

SQL & PL/SQL :: Numeric Or Value Error - Character String Buffer Too Small

May 6, 2008

I am trying to execute this

begin
-- Initialize owa with an empty array, just so we can use htp.
owa.init_cgi_env( param_val=>owa.cgi_var_name );
-- Add a header to avoid dealing with header-related code in htp.
htp.prn('Content-Type:text/plain');
htp.print('');

[code]....

The error I am getting is

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.HTP", line 1550
ORA-06512: at line 32

what i feel is that oracle Database UTF8 or AL32UTF8 characterset does not support htp package properly. When i run the code on another characterset, it runs errorfree except in UTF8 or AL32UTF8.

View 7 Replies View Related

Reports & Discoverer :: Possible To Convert Small Application To EXE File

Mar 15, 2011

I have a small application with 5 forms and a small database. Is it possible to convert it into an exe file?

View 4 Replies View Related

Performance Tuning :: Split Large Table To Small Pieces?

Mar 28, 2011

I have several large tables in the live system! Those table are store historical information.

current situation:

Now, A table record was 129 million rows.

Every month added 4.5M records to this table.

This table data size 17GB and index size 28GB.

I have only 30 GB available free space on disk!

How to split this table to small pieces (partition table by month)?

What is the best approach?

I would like to do partitioning on this table month by month.

View 12 Replies View Related

SQL & PL/SQL :: Error / Character String Buffer Too Small ORA-06512 / At Line 9

Nov 17, 2011

Actually I am getting the following error while running my script.

Error:(Error): ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 9

Seems to be getting eror in the following line but not sure why its coming."select adary.dilution_strategy_seq.NEXTVAL into :dil_strat_seq_new from dual;"

Code snippet:
---------------------------------------------------------------
declare
dil_strat_seq_new NUMBER :=0;
disc_conc_seq_new NUMBER :=0;
disc_fold_seq_new NUMBER :=0;
begin

[code]...

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved