I am getting error in alert log file something like this:
WARNING: inbound connection timed out(ora-3136)
while on checking SQLNET.LOG file it is showing :
Tns error struct:
ns main err 12541
TNS:12541: TNS:no listener
ns secondary error 12560
nt main error 511
TNS:00511 : No listener
nt secondary error 146
nt OS err 0
WARNING: inbound connection timed out (ORA-3136)
Database :: 10g(64 bit) R2
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
[code]....
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
[code]...
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
View 4 Replies View RelatedOne fo my Db having reliable message as top first timed events.
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
reliable message 685,139 24,625 36 29.58 Other
I have two related questions:
Scenario 1:
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 :
Listener.ora
# LISTENER.ORA Network Configuration File: D:oracleora92NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Tarun)(PORT = 1521))
)
[code]....
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.
SQLNET.SEND_TIMEOUT= 120
SQLNET.RECV_TIMEOUT= 120
SQLNET.EXPIRE_TIME = 120
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
RDCTEST2.rdcamazon.com =
[code].....
How would I go about debugging this? I replaced the ip with x's since this is a public post.
client = windows xp
server = windows 2003 server
I am able to connect to a local database server from my client without a problem.
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
[code]......
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
Timed out waiting for the CRS stack to start.
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
[code]...
I'm trying to run the following procedure and I'm getting he following message:
Warning: execution completed with warning
PROCEDURE etl_bago Compiled.
The procedure is created, the problem is that when I tried to run it with parameters I'm getting this error:
exec etl_bago ('july19.csv');
Error report:
ORA-06550: line 1, column 7:
PLS-00905: object SYSTEM.ETL_BAGO is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:
%s"
[code]......
Btw, I'm using SQL Developer 1.5.3. And the procedure script is here:
[URL].....
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].......
i want to drop a table by applying fol
SQL> drop table table1 purge;
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;
[code].....
If my tablespace goes beyond 80% I should get a email from Unix crontab.
1)Warning for tablespace 80% full.
2)critical for tablespace 90%full..
I need the script for Oracle tablespace with 87% and shell script.
Do I need 2 scripts? Is there anything ready available (Oracle 10g).
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.
View 2 Replies View RelatedSQL > 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
[code]......
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
- Wait for a patch?
Is there any way to make a form timeout.
After login into form if there is no transaction/event happens I want it to throw one warning message after say 5 minutes.
For the export and import I am doing teh following steps:
1.Export the tablse space from the test machine where the whole stack is created
exp system/password@orcl file="data/OracleDump/arsystem.dmp" OWNER="ARADMIN";
2.Following steps to import: These steps followed by installer before it imports the tablespace on the destination machine
•CREATE TEMPORARY TABLESPACE ARTMPSPC TEMPFILE '/data/ORACLE/DATABASES/ORCL/artmp' SIZE 250M REUSE AUTOEXTEND ON
•CREATE TABLESPACE ARSYSTEM DATAFILE '/data/ORACLE/DATABASES/ORCL/ARSys' SIZE 7000M REUSE AUTOEXTEND ON
[code]...
3. Import the tablespace on a different box
imp system/password@orcl1 file="/dump/arsystem.dmp" buffer=1024000 fromuser=aradmin touser=aradmin feedback=1000000 log="dump/arsystem.log"
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"
[code]...
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]........
But i am unable to trace .
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.
I have installed ORACLE 11g on RHEL-4, where the RHEL is installed on VM.ORACLE is working fine on RHEL but i am not able to connect oracle on my XP.
View 1 Replies View Related