Server Administration :: IFile In Manual DB Creation?

Feb 5, 2011

While creating a Manual DB creation, syntax as below:

%ORACLE_HOME%DATABASEinitprag.ora which will have a seperate file as below:
ifile=c:pragatpfileinitprag.ora

1) Why we need to divert the pfile into another location?

2) Can we keep the pfile inside the location - %ORACLE_HOME%DATABASE?

View 1 Replies


ADVERTISEMENT

Server Administration :: Manual Database Creation

Jan 21, 2011

manual DB creation.I gone through the below steps:

1) created appropriate folders.

2) Copied a PFILE from an existing DB and changed the contents like DB name etc...

3)Then I Created a text file called %ORACLE_HOME%DATABASEinitmuktha.ora with the following contents: ifile=c:pragpfileinitmuktha.ora

4) Then i set Oracle SID (Through Environment variable in MY COMPUTER --> PROPERTIES...)

5) Then I Created a Windows service for the DB.

6) startup nomount pfile= c:pragpfileinitmuktha.ora

7) Then I ran the database creation command.

The DB was created but when i log in again, it is looking for the pfile in the another DB's location rather than from "%ORACLE_HOME%DATABASE". Where i missed out to create new oracle_home folder?

View 6 Replies View Related

Server Administration :: Manual DB Creation In UNIX

Feb 7, 2011

I am trying to create a DB manually.

1) How to create a UNIX services as we use oradim in windows.
2) While trying to use DBCA command it shows the below message.

SET DISPLAY ENVIRONMENT THEN RE-RUN.

My login is already in admin group only.

View 7 Replies View Related

Server Administration :: Database Creation Manual Error

Sep 16, 2011

i am creating database manually in oracle 9i os version ibm-aix5.3 it showing following error

CREATE DATABASE "varathu"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/backup/varathu/control01.ctl'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 13: Permission denied

View 18 Replies View Related

Server Administration :: USERS Tablespace Reached 96 Percent After Manual DB Creation?

Mar 14, 2011

I created manually a database in 10g, after succesfully creating the dB, I created a single user re: LAMS. Now, I noticed that my USERS tablespace is currently at a 99.96% usage:

SQL> @check_space_used.sql
Monday, March 14, 2011 2:46:22 PM SGT

TABLESPACE_NAME TOTALSPACE TOTALBYTES PERCENTUSED
------------------------------ -------------------- -------------------- --------------------
SYSTEM 1073741824 239599616 23
UNDO 268435456 16449536 7

[code]...

View 5 Replies View Related

Server Administration :: Manual Standby Database On Heterogeneous Platform

Apr 24, 2012

We have a 2 node RAC installation on IBM AIX 5.3 with Oracle Standard Edition. We need to create a manual standby database (becoz Standard Edition does not allow Dataguard confign). Can we do this on a different platform (eg: Linux/Windows). This is to make use of existing servers for the standby environment.

View 1 Replies View Related

Server Administration :: Db Creation Ctl Error?

Jun 10, 2010

It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:

SQL> startup nomount
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 2235856 bytes
Variable Size 177840688 bytes

[code]....

View 3 Replies View Related

Server Administration :: Tablespace Creation

Jun 24, 2012

Problem Description: There are five range partitioned tables which are partitioned by date,designed by previous DBA.Four tables are in one tablespace and one more table is in another tablespace.For every three months there are two tablespaces are created autamatically in new names for future dates.There is no scheduled job for this.How they are created?.This is our question.

View 3 Replies View Related

Server Administration :: DBLINK Creation For OS Authenticated Users

Jun 14, 2012

will it be possible to create db_link between two operating system authenticated users belongs to different databases?

View 5 Replies View Related

Server Administration :: Manually Oracle Database Creation?

Feb 21, 2013

how to create database manually(without dbca).

View 2 Replies View Related

Server Administration :: Deferred Segment Creation - Default True?

Jan 20, 2010

What do you think of this 11.2 parameter? It can give some pretty weird results.

SQL> create tablespace ts1 datafile size 10m;
Tablespace created.
SQL> create table t1 (c1 date) tablespace ts1;
Table created.
SQL> drop tablespace ts1;
Tablespace dropped.
SQL> insert into t1 values(sysdate);
insert into t1 values(sysdate)

[code]...

View 5 Replies View Related

Server Administration :: TNS Error - DBCA After Database Creation Script Complete

Aug 15, 2010

I'm getting a "TNS disconnect" after database creation script creation in DBCA. Haven't figured out what's going on. I'm attempting to create a 2nd database on one linux 64 server. I get all the way through DBCA, but it won't go the final mile. Any thoughts? I've tried setting the port to a different port from the existing LISTENER, creating a LISTENER2 and associating it with the 2nd instance.

View 1 Replies View Related

ASM Disk Groups Creation After ASM Instance Creation

Jul 9, 2012

During ASM Disk Groups creation after the ASM instance creation, receive the following error: Disk Group ORAASMGROUP2 already exists. Cannot be created again

The Grid infrastructure was deinstall one time and still the same issue.

View 4 Replies View Related

Server Utilities :: Table Creation - SQL Loader?

Aug 2, 2010

Check table creation script

CREATE TABLE "SCOTT"."TEST_USER"
("TX_SID" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"TX_FIRST_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"TX_LAST_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE,

[code]...

Here i'm loading data into these three tables through sql loader. Here is the control file

OPTIONS (SKIP=1,ROWS=5)
LOAD DATA
INFILE 'C:SQL LOADER DEMO estuser_data_lat.csv'
INTO TABLE TEST_USER

[code]...

Here are the two function which i'm calling from sql loader control file

CREATE OR REPLACE FUNCTION get_role_id(p_role_name VARCHAR2)
RETURN NUMBER IS
lv_role_id NUMBER;
BEGIN

[code]..

i'hv attached the testuser_data_lat.csv file, which is the data file.Command line

C:SQL LOADER DEMO>SQLLDR scott/sc CONTROL=rd_users_control.ctl

Now let me tell u what is happening Whem i'm running the above sqlldr, log is generating saying

Record 1: Rejected - Error on table TEST_ROLE, column ID_ROLE.
ORA-01400: cannot insert NULL into ("SCOTT"."TEST_ROLE"."ID_ROLE")
Record 2: Rejected - Error on table TEST_ROLE, column ID_ROLE.
ORA-01400: cannot insert NULL into ("SCOTT"."TEST_ROLE"."ID_ROLE")

[code]...

But when i remove

INTO TABLE TEST_ROLE(
TX_SID POSITION(1:3) CHAR,
ID_ROLE "get_role_id(:ROLE_NAME)" ,
TX_CREATED_BY CONSTANT "SYSTEM",

[code]...

from Control file, data is getting popupalated in TEST_USER and TEST_TITLE similarly if remove

INTO TABLE TEST_TITLE(
TX_SID POSITION(1:3) CHAR,
ID_TITLE "get_title_id(:TITLE_NAME)" ,

[code]...

from Control file, TEST_USER and TEST_ROLE is getting populated.

Here RD_ROLE_MASTER script

CREATE TABLE RD_ROLE_MASTER (
"ID_ROLE" NUMBER(38,0) NOT NULL ENABLE,
"TX_ROLE_NAME" VARCHAR2(20 BYTE) NOT NULL ENABLE

[code]...

Here is RD_TITLE_MASTER script
CREATE TABLE RD_TITLE_MASTER(
"ID_TITLE" NUMBER(38,0) NOT NULL ENABLE,
"TX_TITLE_NAME" VARCHAR2(25 BYTE) NOT NULL ENABLE);

Insert into RD_TITLE_MASTER (ID_TITLE,TX_TITLE_NAME) values (7,'RED_LOB_ESCALATION_L1'); what is the problem?

View 1 Replies View Related

Server Utilities :: User Creation While Impdp

Jul 9, 2013

I have a question to clarify regarding user creation during export and import.

Will user get created along with roles,privileges by default when using impdp command ?

View 6 Replies View Related

Server Utilities :: User Creation Definition In User Mode Export

Mar 31, 2010

I would like to know if 'user creation definition' is exported in user mode export if export is done with DBA role..If it is Not, does it mean we always need to precreate the user before we import the dump created using 'user mode export'?

View 2 Replies View Related

How To Bypass Manual Query Execution

Apr 13, 2013

when i run a form no information shows up until i click execute query... i need the info to be their automatically to browse with the previous and next button

View 3 Replies View Related

Oracle SGA Components Manual Allocation

May 13, 2013

Phyical memory : 420G My database version : 11.2.0.3 running on linux machine.

Memory_target = 200G . I would like to allocate this value to following SGA components. I don't want to automatic memory management enabled. how to split 200G for following components. Is there any percentage for each components ?

db_cache_size
db_recycle_cache_size
db_keep_cache_size
large_pool_size
java_pool_size
shared_pool_size
pga_aggregate_target
streams_pool_size
log_buffer

View 10 Replies View Related

Data Guard :: Executing A Manual Failover?

Oct 5, 2013

CentOS 6.4 64bits   Oracle......: 11.2.0.4 64bits   

I am running some small tests here in my test env, using dataguard. I have configured the Primary and Standby with Maximum Availability... they're running just fine. Now i want to execute a failover test (i have already ran a Switchover test with the Broker successfully).

My question is very simple, at my point of view: What are the required steps to execute a successful manual failover? For example, i have my env as follows:   

- Primary: prim1  
- Standby: stdb1   

Suppose that the primary database crashes in an unrecoverable way... is this case a manual failover would be necessary.

To do so, i would have to execute the following command, in my Standby database:      

-- stdb1 is the standby database...       DGMGRL> failover to stdb1      

The above command is correct? Are there any required configurations after the failover? I read the Oracle Docs, and it says

View 2 Replies View Related

Application Express :: Manual Update Of Two Reports

Sep 7, 2012

I have two SQL reports on the same page.

Those SQL reports are built with apex_items. Afterwards I'm updating them with a manual process (apex_application.g_fxx for ..loop). I'm using different IDs on both reports for the apex_items.

It's working fine for the first report displayed. But not for the second one. If I swap the two reports, it's always the first that will be updated.

Does it mean that we cannot use the apex_application to update more than one report and that I have to use a page per report?

I'm using APEX 4.0.0.00.46

View 2 Replies View Related

How To Monitor Alert Log File (using Any Tool Or Manual)

May 10, 2013

1)How to monitor alert log file (using any tool or manual)?

2) What are the implications of a database with multiple data block sizes?

View 4 Replies View Related

RAC & Failsafe :: Manual Failover To Standby Database Without RAC And DG?

May 13, 2013

if it is possible to create a failover setup without RAC and DG...For example:

I have 11.2.0.2 database (with EBS 12.1.3) on dbnode1...I would like to create another node to failover my primary datbas in case of any failure.

Steps i will follow:
1: creat dbnode2
2: install same os as dbnode1
3: install same oracle as dbnode1
4: share dbnode2
database between dbnode1
and dbnode2

Now, if hardware fails on dbnode1, can i manually failover and start my database on dbnode2?

I know we can do with RAC and DG,BUT without RAC and DG If not possible..

View 4 Replies View Related

Manual And Automatic Segment Space Management (ASSM)?

Jan 5, 2012

I have some table spaces manual and others automatic, i just want to know what's the recommended one, to change it to the best way.

How to change Segment Space Management of a tablespace from MANUAL to AUTO? in oracle 10g R2 and also want to know the main difference between Manaul and Automatic Segment Space Management.

View 1 Replies View Related

Backup & Recovery :: Manual Cloning Of Oracle 10g Database

Nov 29, 2011

I need the step by step procedure for the cloning of database in linux environment .

View 2 Replies View Related

Reports & Discoverer :: How To Close Window Automatically Without Manual Intervention

Oct 20, 2010

I am running a report which is called for a set of employees picked up in the cursor. For each employee the report is run in a different window. However, the report runs fine and the output gets saved in the local machine but the window doesn't get closed automatically.

How to close the reports window automatically without manual intervention?

View 2 Replies View Related

TimesTen In-Memory :: Manual Refresh Cache Groups From Oracle DB?

May 3, 2013

we want to truncate a oracle Table in the Oracle DB. After the truncate the fact table will be loaded again. After the new load in the fact table we want to tell the times ten db to refresh the cache table. The cache Table is a user owned read-only cache group with no autorefresh. We want to tell times ten in a PL/SQL Block from Oracle DB that starts the refresh from the cache group in times ten. The refresh should not be a autorefresh because the refresh should only start if the fact table will new loaded after the truncate.

View 1 Replies View Related

Application Express :: Master-Detail Manual Tabular Updatable

Jan 8, 2013

I have master and detail table , in detail table i want to build tabular form manual , i want to insert , delete and update in detail manual tabular.

tables i use :
CREATE TABLE  "DISTRB_PLAN"
   (     "PLAN_ID" NUMBER NOT NULL ENABLE,
     "PLAN_NAME" VARCHAR2(200),
     "PLAN_DESC" VARCHAR2(2000),
     "PLAN_NOTES" VARCHAR2(2000), 
      CONSTRAINT "DISTRB_PLAN_PK" PRIMARY KEY ("PLAN_ID") ENABLE
[code]....

View 6 Replies View Related

RMAN :: ORA-00258 / Manual Archiving In NOARCHIVELOG Mode Must Identify Log

Jan 27, 2013

My RMAN backup failed with below error.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 01/26/2013 22:48:56
RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
RMAN>

Recovery Manager complete.

View 2 Replies View Related

Application Express :: How To Get Unique Element IDs In Manual Tabular Form

Oct 24, 2012

I'm trying to get a unique sequential element id for every field in a manual tabular form. Here is the code to generate the form:

SELECT apex_item.hidden(1, lpad(rownum,4,0)) row_num,
apex_item.hidden(2, skillset_demand_id) sdi,    
apex_item.text(3, domain, 20, 20, null, 'f03_#row_num#') Domain,
apex_item.text(4, target, 20, 20) Specialization,
apex_item.text(5, skill, 20, 20) Skill
FROM RI_SKILLSET_DEMAND
WHERE WORK_ID = :P511_WORK_IDAccording to the APEX API manual I should be able to set the attribute id with p_item_id*, which in the example of a text item, is the sixth parameter. In line 3 of the code above, I set the p_item_id to 'f03_#row_num#' after having created row_num in line 1.

The HTML I get is:
<input id="f03_#row_num#" type="text" value="xxxxxxxxx" maxlength="20" size="20" name="f03">
...
<input id="f03_#row_num#" type="text" value="xxxxxxxxx" maxlength="20" size="20" name="f03">What I want is:
<input id="f03_0001" type="text" value="xxxxxxxxx" maxlength="20" size="20" name="f03">
...
<input id="f03_0002" type="text" value="xxxxxxxxx" maxlength="20" size="20" name="f03">
...
etc.

I've tried a lot of things but I can't seem to get parameter substitution inserted into the id attribute so I can get each element uniquely with javascript later.

View 1 Replies View Related

Windows :: Prepare Tablespace Growth Report For 106 DB - Reduce Manual Activity

Jun 29, 2011

I need tablespace name,tablespace total size and used size of every tablespace for my 106 databases. bcz I am planning to prepare tablespace growth report for my 106 dbs. If I have the 2 months data from now in xl sheet, then I can predict the growth rate of every tablespace accurate almost.

it is not a easy task to fill the space detail manually in xl sheet everyday.Hence I need some mechanism to do this activity automatically.

I know we can collect this detail in a csv file every day while running the script. but is there any mechanism to store these detail in a particular xl sheet one by one column automatically?

View 13 Replies View Related







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