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


ADVERTISEMENT

Server Administration :: Start Using Data And Index Compression In 11g Database

Jun 27, 2012

We have a requirement from the customer to start using data and index compression in our 11g database.. Is this something available in Oracle 10g,11g without any additional costs? We are not sure if this will work with our application so we will have to test it in-house, is it possible to compress the existing table data/index to test it out?

View 3 Replies View Related

Enterprise Manager :: Error Start Database Control

Sep 4, 2013

I have a problem when I install oracle 11g: I did an installation on a win2008 r2 server and everything works fine, I did another installation on another server in the same network as a test, but at the end of the installation I get an alert that says:

start database error control .....
Executing set oracle_unqname and then emctl start dbcontrol.
of course nothing happens.

dbcontrol_nome the service instance will not start. checking the file in your home directory I always acts everything is in place. I reinstalled windows to eliminate all the checks made​​, repeated installation and here appeared the same problem.

question: can exist 2 oracle installations on the same network with the same name db? I currently have two installations of the same name with oracle db 10

View 3 Replies View Related

Installation :: Fail To Start OCR And OS / Error When Start OracleCSService

Jun 5, 2012

I'm trying to install Oracle 10g Enterprise Ed. (on Windows 2003 Std. Ed) and I get some errors:

First “Fail to start OCR” I press "continue" and the installation continue. Next “Operative System Error when start OracleCSService” and when I press "continue" the installation finish.

At the end of installation, It seems like Oracle DB is Ok, but not really...I can't connect to database from Enterprise Manager and the OracleCSService is in "Starting mode".

View 3 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 :: Unable To Start Second Node In RAC

Mar 16, 2011

I have setup a RAC machine of two nodes on Oracle 10GR2(with 10.2.0.4 Patchset). All setup went well. I am able to connect one node from sqlplus but the other node is connected to idle instance. I tried to startup the database with mount and nomount option but it fails. Following is the error :

SQL> startup nomount;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/LCLCLKS/spfileLCLCLKS.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/LCLCLKS/spfileLCLCLKS.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>

I am using ASM and it is running on both nodes even I am able to connect the SQL prompt from it. I am able to view the diskgroups I created from the second node but through "asmcmd" option I can't go inside the disk group. It gives :

ASMCMD> ls
DATA/
INDEX/
ASMCMD> cd DATA
asmcmd: diskgroup 'data' does not exist or is not mounted

On first node, everything is fine and I am able to import the database on it, as well.

View 9 Replies View Related

Server Administration :: Oracle 8i Service Did Not Start

Apr 27, 2013

I have oracle8i database on windows 2008 but not a domin server now i have domin server and i want to join this server on domin network i try to join domin it fine but my oracle8i service did not start what to do ?

old hostname=bagmati
afterchange hostname=bagmati.alkatel.org.np

View 3 Replies View Related

Server Administration :: Cannot Start Listener (/tmp Related)

May 9, 2012

OS: AIX 6.1 64bit
DB: Oracle 10gR2 (10.2.0.5.0)

What we did is..

1. Install patch 6613550 (./rootpre.sh)
2. Install 10.2.0.1 for AIX 64-bit
3. Install 10.2.0.5 Patch Set
4. Create Database
5. Created/Setup LISTENER and TNSNAMES (test connection successful)

After installation of database, everything went well until we tried to restart the server, what happened is that we cannot start the listener, the error was:

TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
IBM/AIX RISC System/6000 Error: 1: Not owner

What i did to resolve this problem is to change the owner of /tmp to oracle, after that i was able to start the listener. ($lsnrctl start) The problem is that our sys admin said that the /tmp directory is being used by the OS and it's owner must be root. But if i return it to root, the listener will not start again. (After server restart)

BTW, our /tmp has enough space so we did not perform the following steps from the installation guidelines:

$TEMP=/directory
$TMPDIR=/directory
$export TEMP TMPDIR

I was thinking if that we must make a temp directory for oracle and set it in the profile, or change the owner to root again and perform this:

$chown -R oracle:oinstall /tmp
$chmod -R 777 /tmp

View 2 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 :: ORA-12514 Error On Database Link

Jan 27, 2011

One of colleague (who has left) created a database link using the statement:

CREATE PUBLIC DATABASE LINK CIVCLMANLINK USING ''CIVCLMAN''

When I try to use this link like:

SELECT * FROM CLIENTMANAGEMENT.ADDRESS@CIVCLMANLINK;

I get the following error:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I can connect to the CIVCLMAN using the Oracle Enterprise Manager / SQL Plus, I can tnsping as well

View 25 Replies View Related

Server Administration :: Oracle Error When Logging Into Database

Jun 26, 2012

When I try to log into my db with a specific user I get this message. Below is from the alert log. I can login as system just fine.

----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 2
Oracle 10g OEL 5.5

View 9 Replies View Related

Server Administration :: Oracle Database Connection Error

Mar 5, 2013

While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument

Attaching output session.

View 16 Replies View Related

Server Administration :: Oracle Database Login Error?

May 15, 2012

I have installed oracle 10g server (10.2.0) standard. My OS is win xp sp-2.

when I run sqlplus or toad, Error Message comes ORA-01033: ORACLE initialization or shutdown in progress.

I have done below steps

in command prompt: C:sqlplus/nolog

sql:> connect system/admin (this is my database username/pass)
Error
ORA-01033: ORACLE initialization or shutdown in progress

sql:> shutdown immediate
not connected
database closed
notconnected
database dismounted
ORA-01012 not logged on

sql:> Startup
01031: insufficient privilegs

not success. till error message comes

View 5 Replies View Related

Server Administration :: Create New Database - Error Ora-12560?

Dec 20, 2011

i want to create new database in oracle 10g, i follow following steps.

C:ORACLE_SID=ALI

THEN create passwordfile

orapwd file=orapwdALI.ora password=ali entries=6

then create oracle instance

C:Oradim -new -sid ALI -STARTMODE AUTO

after that i use

SQLPLUS /NOLOG

THEN i write the command to connect to user ali but

CONNECT SYS/ali as sysdba

it display following message.
Error
ORA-1256: TNS: protocol adapter.

i also check the oracle services from "services.msc", where oracle instance is "start".

View 9 Replies View Related

Server Administration :: Oracle Tracing At Stop And Start

Jan 20, 2012

I need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start.

View 9 Replies View Related

Server Administration :: ORA-01116 / Error In Opening Database File 26

Jul 9, 2010

I was surprised when I shutdown our production dB. I got this error:

$ . oraenv
ORACLE_SID = [abcd] ?
SQL> shutdown
ORA-01116: error in opening database file 26
ORA-01110: data file 26: '/VOL03/oradata/qxyz/data/qxyz_data01.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort
ORACLE instance shut down.

2 days ago i rename this file QXYZ_DATA01.dbf from it's original name of QXYZ01.dbf without knowing that I was in the 'abcd' instance. When I backup a controlfile I noticed that it was part of the 'abcd' data files, so I just delete it (from OS level).

Is there any risk involved in the 'abcd' instance? How do I get rid of that file 'qxyz_data01.dbf' in the 'abcd' instance.

View 13 Replies View Related

Server Administration :: ORA-03114 Error While Creating Database Using DBCA

May 16, 2013

I am getting a ORA-03114 (not connected to Oracle) error when I am creating a DB using DBCA. Here are the steps that I do:

1) Log onto the server remotely, using Exceed Query
2) Connect as the oracle user (Oracle)
3) set ORACLE_HOME, PATH
4) Run DBCA, give parameters

At around 12% and again at 19%, I get the error (see screenshot). I also tried to generate the scripts and run them remotely, and the steps run successfully upto & including the step " startup nomount pfile="/oracle/admin/<dbname>/scripts/init.ora"; ". After that, when I try to run the script specified in rmanRestoreDatafiles.sql from SQL> prompt, the error appears, and connection to ORACLE is lost.

Googling the error shows that it is a connectivilty issue, and Oracle says that it is usually caused by user scripts. But I am not running any user-created scripts as part of the DBCA process. Somehow, the instance is timing out immediately after doing the "startup nomount".

View 4 Replies View Related

Server Administration :: Error Creating Database Using DBCA Oracle 11g R2?

Nov 18, 2010

This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6

I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.

during the database creation I got an error as the system was adding the JVM that read:-

ORA-01927:cannot REVOKE privileges you did not grant.

I was given the options to ignore or abort

I chose to ignore the error and continue.

After the database creation completed I looked in the jserver log copied below and found two errors

I did not get the same error before installing patch set 6

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv

[Code].....

View 2 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 :: Unable To Connect To Database / ORA-12560 / TNS / Protocol Adapter Error

Feb 7, 2013

In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.

In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.

Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :

ERROR:ORA-12560: TNS:protocol adapter error

In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?

View 6 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 :: Alias Used In Start By Connect With Program Gives Error

May 3, 2011

We have a query which uses start by and connect with method. this query works fine in our earlier version 10. But when we migrated to 11g, we are facing problem with the query.

Scenario 1:
------------
There is a table in Schema 1 and created a view for the same.

Table : create table alias_test1 ( A varchar2(10),B varchar(10),C varchar2(20),D varchar2(40), E varchar2(10),F number(1));
View: create or replace view alias_vw1
as select A, B,C,D, E,F from alias_test1

Values :
Insert into A.ALIAS_TEST1 (A, B, C, D, E, F)
Values ('Block1', '136', 'TOTBANK', 'Total Bank', ' ', 1);
Insert into A.ALIAS_TEST1 (A, B, C, D, E, F)
Values ('Block2', '136', 'PPRSEGHKB', 'HKB', 'TOTBANK', 2);

Now in the schema B, created a synonym for the view to access. create synonym alias_vw1 for alias_vw1@link.world

Query :
select srl_no,cde,pdesc,lvl,is_leaf,hcy
from( select srl_no,
cde, pdesc, level lvl,
connect_by_isleaf is_leaf,
Ltrim(replace(sys_connect_by_path (rpad(Trim(cde),19,' '),'~'),'~',' ')) hcy
[code]...

View 3 Replies View Related

Networking And Gateways :: Listener Error - Failed To Start

Sep 23, 2011

after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521)))
TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
NL-00305: the specified path name does not exist

Listener failed to start. See the error message(s) above...

View 16 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 :: Database Configuration Assistant Not Working / When Create New Database

Mar 26, 2011

i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.

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







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