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.
I have a problem with my Oracle istance and so far I couldn't fix it, I have and Oracle 11g XE istance running on windows server 2003.A couple of days ago I received the error message "ORA-00257: archiver error".I found tips in this forum and wanted to apply but sqlplus doesn't recognize my SYS user/password. I type the correct password but no chance to log in.
If I try to connect using a client like Toad, I receive the message ORA-12170: TNS:Connect timeout occurred. I checked the firewall rules, but it's ok, moreover I was logging in in the past and any change has been performed on it. I learned it's possible to change SYS password.
If I connect as "/ as sysdba" on sqlplus I read "Connected to an idle istance".In order to connect as "/" I had to update sqlnet.ora and restart the service. The parameter SQLNET.AUTHENTICATION_SERVICES
was set as NONE ad I set as NTS. I should probably have to set it as ALL? I found out the orapwd utility to change SYS password throught password file for remote login as sysdba.
I tried to create that file, and when I ran the command it asked me the SYS password, I typed it and it created the file, so I guess the password I type is correct (I had the question to type it wrong). I didn't go to the next step as I wasn't sure to make the right thing and I don't want to make this issue bigger.
As long as I can't log in as sysdba I can't perform the actions mentioned in tips to fix the error 257, but I'm also wondering if the archive error can have a side effect and deny the action of update the SYS password.
we have two primary databases (Oracle release 9.2.0.8, HP-UX 11.31) installed on the same server. The corresponding standby-databases (Oracle release 9.2.0.8, HP-UX 11.31)are configured on one server, too.It happens once in a while that the server of the standby-databases struggles and performs a shutdown. The primary- and standby-databases are configured with Data Guard. If the server of the standy-databases is not reachable anymore that should not really cause any problems,meaning that both primary databases can be used as usual. One of our primary database behaves like this: the applications can connect to the database and work like as expected. The other primary database behaves different: the applications can't connect anymore. But the database is still up and running. When looking at the alert.log file the following messages can be found:
Fri Oct 4 03:19:51 2013ARC1: Evaluating archive log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372 Log actively being archived by another processFri Oct 4 03:20:51 2013ARC1: Evaluating archive log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372 Log actively being archived by another processFri Oct 4 03:21:51 2013ARC1: Evaluating archive log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372 Log actively being archived by another process Fri Oct 4 03:22:51 2013ARC1: Evaluating archive log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372 Log actively being archived by another processFri Oct 4 03:23:51 2013ARC1: Evaluating archive log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372 Log actively being archived by another processFri Oct 4 03:24:51 2013ARC1: Evaluating archive log 3 thread 1 sequence 335372ARC1: Unable to archive log 3 thread 1 sequence 335372
Log actively being archived by another process Trying to connect to the database is not possible - the database seems to be busy with something... We have two archiver processes for each primary database. One process of the primary database which can't be reached anymore seems to hang. Executing the command SQL> alter system archive log all;seems to run forever. Instead of shutting down ands starting the instance killing one of the archiver-processes solves the issue. Maybe some of you have made the same experiences? I do not understand why the one database doesn't have any issues (which is expected behaviour) but the other database is not reachable anymore due to some issue with the archiving process.
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
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.
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
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.
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?
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.
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
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
We installed Oracle 11g on solaris machine but some of the configuration failed.
When verified in tracelog we are finding below error message:
PRCT-1003 : Failed to run "getcrshome" on node "localnode" at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:423) at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:546) at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:606) at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:347) at oracle.sysman.assistants.dbca.ui.DBCAWizard.<init>(DBCAWizard.java:452) [code]....
We then tried to create instance but came up with below error:
ORA-12560: TNS Protocol Adapter Error..We have another database version 10.2.0.3 running on the same server and needs to be continued.
When Oracle was installed, there was an error in the server's domain name (missing a "."). Is there an easy way to fix this domain name in the Oracle installation after the fact? I know about tnsnames.ora, pfile, system parameters, and I'm pretty sure I can do emagent -config. My concern is that the "Installed Products" would not like the fact that the domain name is now "abc.proj.org" when installation was done on "abcproj.org". The /etc/hosts file had "abcproj.org", and we want to fix it to "abc.proj.org".
I need to reinstall Oracle -- is there a better way?
I want to shutdown the database using shutdown immediate and startup the database using startup mount.
1.)My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after
Shutdown immediate (database is shutdown)
Startup mount (database is mounted no problem it's working fine)
2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).
C:>set oracle_sid=dbadb C:>sqlplus / as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009 Copyright (c) 1982, 2004, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error
[code].....
3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).
SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options
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
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
i am receiving ora-00600: internal error code, arguments :[729], [163624], [space leak], [],[], [], about this error and what can damage it can cause .we have one issue that is our application is slow for some time and then get normalk
When connecting to Oracle Db as sysdba the following error message occurs.
-bash-3.00$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 00:34:55 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn sys/sys as sysdba ERROR: ORA-12560: TNS:protocol adapter error
I need to increase the size of shared pool for that i need to change the size of parameter sga_target and sga_max_size these are static parameter so that I need to change in spfile first then start instance then these parameter will get change. But when I create pfile from spfile it gives error:
ERROR at line 1: ORA-01565: error in identifying file '?/dbs/spfile@.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3
We are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.
Following files are active :
E:oracleproduct10.2.0inoraclient10.dll E:oracleproduct10.2.0inorapls10.dll E:oracleproduct10.2.0inoracommon10.dll E:oracleproduct10.2.0inorageneric10.dll E:oracleproduct10.2.0inoraplp10.dll [code]........ -------------------------------------------------------------------------------- The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ] in the Oracle Home -------------------------------------------------------------------------------- Its not an rac. We stopped all the services running on this server.
