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


ADVERTISEMENT

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 :: 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

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 :: 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 :: 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 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 :: 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

PL/SQL :: How To Find Error In Pkg Creation

Apr 26, 2013

I have 30 packages to be created for a new user, i call in the execute_pkg.sql which creates all the 30 packages.

i use like this

sql> set echo on
sql> set spool execute_pkg_spool.txt
sql>@execute_pkg.sql
sql> spool off

My questions:

I find it difficult to figure out the which pkg was not created, at present the spool file is too big with the pkg code in it

create or replace package test1....
...
..
..

Warning: Package Body created with compilation errors.

i wanted the output like this

test1
Warning: Package Body created with compilation errors.

View 5 Replies View Related

Trigger Creation Error

Nov 28, 2012

I am getting error while creating a trigger. I am not yet find any wrong statement. See the following code and comments.

SQL> CREATE OR REPLACE TRIGGER shclog_in before update on shclog for each row
WHEN (to_number(new.MSGTYPE) = 210)
2 3 declare
4 PRAGMA AUTONOMOUS_TRANSACTION;
5 begin
6 insert into starcas.transaction_log values(:new.PAN,
[code].......

Warning: Trigger created with compilation errors.

SQL> show error
Errors for TRIGGER SHCLOG_IN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1 PL/SQL: SQL Statement ignored
4/21 PL/SQL: ORA-00942: table or view does not exist
SQL>

View 4 Replies View Related

Server Administration :: While Creating Index ORA-00603 / ORACLE Server Session Terminated By Fatal Error

Jul 26, 2010

While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".

We have the space in tablespaces and also in the file systesm.

View 13 Replies View Related

SQL & PL/SQL :: Nested Table Creation Error

Apr 12, 2010

I am getting compilation error when create nested table type depend on table structure

SQL> CREATE OR REPLACE TYPE typ$nttb$1 IS TABLE OF emp%rowtype
2 ;
3 /

Warning: Type created with compilation errors.

SQL> show error
Errors for TYPE TYP$NTTB$1:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/29 PLS-00329: schema-level type has illegal reference to SCOTT.EMP
SQL>

View 5 Replies View Related

SQL & PL/SQL :: Trigger Creation Error On Secured Environment

Jun 21, 2011

I have created a trigger in a different server and is working fine. But then when I implemented the same trigger in a different server (secured) then I'm encountering this error:

PLS-00049: bad bind variable

Below is the code for the trigger for reference:

create or replace
TRIGGER TRG_ROLE_RIGHT_HISTORY
BEFORE INSERT OR UPDATE OR DELETE ON MAS_BPI.LOS_SEC_ROLE_RIGHT_MAPPING
FOR EACH ROW
DECLARE

[code]....

View 17 Replies View Related

SQL & PL/SQL :: Table Creation - Facing Error ORA-02438?

Oct 18, 2012

i want to create a table to perform a task when i insert client account details in this table then check the account type is in(S,C,R) and balance should be also check when account type S then balance >=5000, account type C then balance >=10000 and account type R then balance >=5000 but when i run this query then facing error "ORA-02438: Column check constraint cannot reference other columns"

SQL> ed
Wrote file afiedt.buf

1 create table kcb_acc_tab
2 (
3 accno varchar2(20) constraint accno_pk primary key,
4 name varchar2(20) constraint name_nn not null
5 constraint name_chk check((substr(name,1,1) between 'A' and 'Z') and name=upper(name)),

[code]....

View 4 Replies View Related

Application Express :: 4.2 - EA Error During Workspace Creation?

Jun 25, 2012

I tried to create my EA workspace for APEX 4.2 and got the following Error.

ORA-20987: APEX - GET_BLOCK Error. - ORA-20001: Execution of the statement was unsuccessful. ORA-01653: unable to extend table APEX_040200.WWV_FLOW_PAGE_PLUGS by 1024 in tablespace APEX_REL42 <pre>declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 6594522669003504543 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 0, p_plug_name=> 'Menu', p_region_name=&g

View 14 Replies View Related

Database Creation With DBCA Fails With Error?

Apr 8, 2013

While Creating database on AIX Machine using DBCA utility I am getting following error

Error Details:
-------------------------------------------------------------------------------------------------------------------
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...

[code]....

View 2 Replies View Related

Server Administration :: TNS Protocol Adapter Error

Mar 14, 2012

I am installing oracle10 10.0.4 in windows server 2008 r2 sp1. while installing it is getting installed and when i start creating the database after accepting the default steps finally . while crating the error i get TNS:protocal adaptor error.

View 3 Replies View Related

Server Administration :: Error While Dropping User?

Mar 30, 2012

Got following error while droping user

DB:9.2.0.8.0 OS:Windows 2003

SQL> drop user custom cascade;
drop user custom cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-21700: object does not exist or is marked for delete

View 1 Replies View Related

Server Administration :: Alter SGA But It Give Error?

Dec 9, 2010

I try to alter the SGA it give me error The Steps which I do show sga

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes

[code]...

View 5 Replies View Related

Server Administration :: ORA-00257 Archiver Error

Sep 21, 2011

While connecting to one of the dev database I am getting following error:-

ORA-00257: archiver error. Connect internal only, until freed.

But when i am checking as sys user there is no archive desination defined in the db.I mean log_archive_dest locations have not been given any value.Where can I check Archive destination in this scenario.Is there any default place where oracle stores archive logs incase log_archive_dest is not given any value.

View 7 Replies View Related

Server Administration :: Error In Creating Database

Feb 17, 2010

I have created a database in Oracle10g which is working fine. Now when I try to create another the system gives the following error.

ORA-12560: TNS protocol adapter error.

View 8 Replies View Related

Server Administration :: Oracle 11g Installation Error

Apr 22, 2010

I am trying to install oracle 11g on windows 2003 ent with sp2 , where I am getting an error, The java runtime environment was not found at bin/javaw.exe. hence the oracle universal installer cannot be run.

View 4 Replies View Related

Server Administration :: Getting Error During Upgrade To Oracle 10.2.0.5?

Jun 24, 2010

I have upgraded my database from 10.2.0.4 to 10.2.0.5. however while upgrading database using DBUA I am getting this error.table or view does not exist ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579 ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596 ORA-06512: at line 1The WMSYS.OWM_MIG_PKG is warped package and I can't understand what it means. How can I understand what view or table is absent in my database?

View 6 Replies View Related

Server Administration :: Getting Error When Start Database 10g

May 4, 2010

I start my database and suddenly got this error:

ORA-00371: not enough shared pool memory, at least 72102521958 bytes

How to fix? I use startup command only and shutdown when shutdown the database.

View 2 Replies View Related

Server Administration :: Error While Exchanging Partition?

Mar 15, 2012

I am not able to exchange partition by following below steps:

drop table manu_tst_hashed_tbl_org;
drop table manu_tst_hashed_tbl_bkp;
drop table manu_tst_smpl_tbl;
CREATE TABLE manu_tst_hashed_tbl_org

[code]...

and getting the below erro:

ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
14097. 00000 - "column type or size mismatch in ALTER TABLE EXCHANGE PARTITION"
*Cause: The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE PARTITION are of different type or size
*Action: Ensure that the two tables have the same number of columns with the same type and size.

View 1 Replies View Related

Server Administration :: Difference Between LRM And Oracle Error

Jun 26, 2011

WHAT IS THE DIFFERENCE BETWEEN ORA ERROR AND LRM ERROR?

View 9 Replies View Related

Server Administration :: Error Message In Oracle Scheduler

Apr 10, 2012

I want to create a schedule as below. But it shows error message which i cant understand.

begin
DBMS_SCHEDULER.CREATE_jOB(
job_name => 'Alert_monitor',

[Code]....

Here is the error message.

Error at line 1
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

View 3 Replies View Related







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