I am facing below error so frequently in alert log file Fatal NI connect error 12170.
VERSION INFORMATION: TNS for 64-bit Windows: Version 11.1.0.6.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production Time: 03-JAN-2011 02:00:00
Frequently getting below error in alert log file. to sort out this issue. Database: Active standby database OS: Windows Server Db Version: 11.2.0.2
Error: *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
In my awr reports I have CPU time(in seconds) as one of top 5 timed events.Does that mean oracle is waiting for my cpu to execute the statements.But my cpu usage is 0-10% always
1. I have two remote Windows machines with database on each. One is Win 2003 Server (machine A) and another one is Win XP (machine B)
2. I can ping from A to B.
3. I can ping from B to A.
4. I can tnsping from A to B.
5. I CAN'T tnsping from B to A.
6. Windows Firewall on both machines are off.
What could be possible reason for point# 5?
Scenario 2:Now, the second part:
1. I had an unwanted entry in tnsnames.ora on B which I removed.
2. Then I restarted the listener on B. Actually, I wanted to restart the one on A to check if that resolves issue mentioned in point# 5 above.
3. I tried tnsping from A to B but suprisingly it is also giving "operation timed out" error now. So now tnsping not working from either sides.
I didn't make any changes in listener.ora on B, just stopped it and started again. Only change made was removing unwanted entry in tnsnames.ora on B.
Why does that affected database connectivity from A to B which was working fine previously?
NOTE: The two machines are connected through VPN using LogMeIn Hamachi. Hamachi assigns it's own IP address to each machine. Machine A is Windows Server 2003 and B is Windows XP.
I have a windows XP server with Oracle 9i on it, when i tried to connect this server from another win XP machine after creating a service. I m getting an error
TNS-12535 TNS:operation timed out
But as i know this error is related to CONNECT_TIMEOUT and it is now obsolete in 9i( am i correct ). I tried it doing from 2 machines but got the same error from everywhere so it means that the problem is with the server.my files are :
I am trying to connect to a server from a client on another network. I am able to connect just fine if I am on that server, but when I try to connect from a client in my office to the amazon server, I get a timeout message as follows.
ora-12535: TNS:operation timed out.
here is my entry in my local tnsnames.ora file. I believe that the network is wide open between my two computers. o firewalls on the computers and the settings on my cisco allow this to go through. I see the client connect in log files on the server, but it always gets a timeout after 20 seconds.
I have tried to add these parameters to the sqlnet.ora file.
One of our production database we are getting error "TNS:operation timed out" from unknown port in alert logfile. Need to check why TNS error is occurring to these unknown port as our listener is running on default 1521 port. Also to inform that host=192.191.118.24 itself is the same database hosting server IP.
TNS-12535: TNS:operation timed out TNS-12535: TNS:operation timed out ns secondary err 12606 ns secondary err 12606 nt main err 0
Installation Oracle Database 11g Release 2 RAC On Linux Using VMware Server folowing error occured
Software = Grid Infrastructure 11.2.0.1 RAC installation on VMware two node linux machine. Windows 7 Machine 8 GB Ram LInux node 1 and node 2 with 2.5 GB RAM
Node 1: root.sh script run successfully.
NOde 2: root.sh script given following error.
CRS-2672: Attempting to start 'ora.crsd' on 'rac2' CRS-2676: Start of 'ora.crsd' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac2' CRS-2676: Start of 'ora.evmd' on 'rac2' succeeded
SQL*Plus: Release 11.2.0.3.0Solaris 10 SPARC I get the following error when trying to make an HTTP request. Below is the snippet of code I run. I get the error after exactly 60 seconds(default timeout?). The problem does not exist in the rest of our environments, only our test environment.
DECLARE p_mid_tier VARCHAR2 (500); responsestr VARCHAR2 (500); BEGIN
I have a requirement to reformat some data elements that consist of two numbers separated by a hyphen e.g. 123-456. I have written a function to get the first number but it compiles with a warning.
CREATE OR REPLACE FUNCTION get_lowernumber (housenumber varchar2) RETURN varchar2 IS v_hyphen number; [code].......
and i get ORA-00054 resource busy and acquire with NOWAIT specified or timed expired
This table is of 600 Gb in size and no more used and not involved in any logical and physical backup and do not referenced by application but still i am getting this error.i search for this error and found which is to "Wait and retry" but i waited and then apply but still no progress.
I ran into the message RMAN-08138: WARNING: archived log not deleted - must create more backups during a backup. From what I understand this is caused when logs are removed that are needed for recovery.
rman target / nocatalog <<EOT CONFIGURE CHANNEL DEVICE TYPE DISK clear ; CONFIGURE CHANNEL DEVICE TYPE TAPE clear ; CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear ; CONFIGURE RETENTION POLICY TO recovery window of 14 days; CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO DISK;
i'm keep on getting below error every morning in my Database.this indicate in Grid control every morning.
Metrics "Database Time Spent Waiting (%)" is at 34.336 for event class "Concurrency" Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other" Metrics "Database Time Spent Waiting (%)" is at 44.78 for event class "Other"
i need to know, this is something that i should consider as a critical warning and how can i solve this .
I have 2 blocks, block 1 which is the master and block 2 which is the detail. Both block 1 and block 2 are multi record blocks. For my form I want to display a warning message to the user if they create a master block without also creating a detail.
SQL > conn ashish/pass@conn_string ERROR: ORA-28002: the password will expire within 1 days ---------------------------------------------------------- I want to catch this eror in forms: catch the error code ORA-28002 in ON-ERROR trigger and ON-Message trigger, however its not getting caught in the trigger. how to catch the warning/error ORA-28002 in oracle forms?
I have one primary database server and one physical standby database serve. but i am unable to fix "ORA-16607" while enabling configuration. during log switch redo data is being applied to the phy standby side but some thing wrong happens in BROKER
here are details........about my configuration
Primary database name PRIM Physical Database Name STAN net service PRIM net service STAN
DGMGRL> show configuration
Configuration Name: test Enabled: YES Protection Mode: MaxPerformance Fast-Start Failover: DISABLED Databases: prim - Primary database stan - Physical standby database
Current status for "test": Warning: ORA-16607: one or more databases have failed
====================================================== Alert log file First para show no problem for for redo to be transmitted to stndby ====================================================== LNS1 started with pid=48, OS id=5408 Thu Sep 21 21:32:03 2006 Thread 1 advanced to log sequence 59 Current log# 1 seq# 59 mem# 0: /u01/app/oracle/oradata/PRIM/redo01.log
OS read hat, oracle enterprise edition 11g release 2, dataguard 2 physical standby's
everything works fine but since 1 day we get following warnings from dataguard on the primary server:
SELECT * FROM V$DATAGUARD_STATUS;
FACILITY SEVERITY DEST_ID MESSAGE_NUM ERROR_CODE CAL TIMESTAM ------------------------ ------------- ---------- ----------- ---------- --- -------- MESSAGE ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Log Transport Services Warning 0 309911 0 NO 01.11.12 RTC returned 2, disabling RTC for next 2 I/Os.
in the alert log it looks like this:
RTC returned 2, disabling RTC for next 2 I/Os. Thu Nov 01 12:09:46 2012 RTC returned 2, disabling RTC for next 2 I/Os. Re-enabling RTC following backoff interval 2. Re-enabling RTC following backoff interval 2. RTC returned 2, disabling RTC for next 2 I/Os. RTC returned 2, disabling RTC for next 2 I/Os. Re-enabling RTC following backoff interval 2. Re-enabling RTC following backoff interval 2. Thu Nov 01 12:11:16 2012 RTC returned 2, disabling RTC for next 2 I/Os. Re-enabling RTC following backoff interval 2.
I see following warning message in alert log file.
Quote:WARNING: OMF is enabled on this database. Creating a physical standby controlfile, when OMF is enabled on the primary database, requires manual RMAN intervention to resolve OMF datafile pathnames.
NOTE: Please refer to the RMAN documentation for procedures describing how to manually resolve OMF datafile pathnames.
Is it just an information or something like warning message we need to look into it.
I've inherited a 10.2 instance here in Kuwait and I'm attempting to migrate to a brand new server; I downloaded and attempted to install 11gR2 (11.2.0.1.0) on my brand new HP clean and patched server running Windows 2008 R2 Enterprise.
I've tried clean install, re-install, install software first then database, install all together, a complete default install (other than putting the database on a different drive letter)... every time I get the same error-
Enterprise manager configuration succeeded with the following warning -
Error starting database control. Please execute the following command(s)
1) Set the environment variable ORACLE_UNQNAME to database unique name
2) ...emctl start dbconsole
There is plenty about this on the internet, google, forums. Some suggest dropping and reconfig of EM; tried that. One error leads to another error and I think I'm getting close, then some other error, more obscure than the last. VERY FRUSTRATING!
- Is this distribution broken?
- Should I try the 32-bit or just install and run the 10.2 on my brand new 64-bit server (that kinda hurts my head but I bet it would work!)
I've tried numerous re-boots, several fresh clean installs (after using the Oracle uninstaller and cleaning out the registry and deleting old files), I've set every environmental variable that I can in the system variables section including ORACLE_HOSTNAME, ORACLE_SID and ORACLE_UNQNAME.
I've tried unlocking SYSTEM and SYSMAN user accounts, I've deconfig'd the EM and have recreated the repository, reconfig'd...
Database is installed and working find. SQL plus is working and fine. It's just EM that's broken and I... just... can't... fix... it.Web page for EM starts just fine... log in (oddly, won't let me log in as SYSDBA from the web) then throws this error:
Error Internal Error has occurred. Check the log file for details.
The log files are pages long and I'm not sure what I'm looking at.
- Install different distro (like the 32-bit 11g)
- Install 10.2 and get on with my life- maybe upgrade later
I could see in teh log lot of IMP-00041: Warning: object created with compilation warnings
example: IMP-00041: Warning: object created with compilation warnings "CREATE FORCE VIEW "ARADMIN"."BMC_CORE_BMC_IMPACT" (" ""REQUESTID","SUBMITTER","CREATEDATE","ASSIGNEDTO","LASTMODIFIEDBY","MODIFIE" "DDATE","STATUS","SHORTDESCRIPTION","CMDBROWLEVELSECURITY","INSTANCEID","CMD"
XML report for particular period completing in warning, throwing error:
Beginning post-processing of request 60011540 on node TSGSD4901 at 03-JUL-2012 10:55:56.
Post-processing of request 60011540 failed at 03-JUL-2012 10:55:57 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
Checked OPP logs:
Language: en Territory: US Output type: EXCEL [6/20/12 3:07:01 PM] [UNEXPECTED] [1657868:RT60695905] java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor716.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) [code]........
In our office one of our pc was worn out and d2k source files in the server were not able to open in another system for that we need to install the below D2k6i Version of Report;
Report Builder 6.0.8.24.0
if we try to open the file it shows the below error
"Warning: Opening a report saved with a newer version of Report Builder. Functionality may be lost. Continue? "
Currently we are using "Report Builder 6.0.8.11.3" is it possible to download the 6.0.8.24 version?
Using Apex 4.1 and custom authentication based on Oracle Database users.
I want to be able to show a warning immediately after a user logs in if their password is due to expire in xx days. Oracle raises a warning (ORA-28002) but I don't know how to handle that from the standard Apex login page.