Archive for the ‘TEChNoLoGY’ Category

FRM-92102 : A Network Error Has Occured

September 19th, 2017, posted in Oracle
Share

FRM-92102 is Gerneric Error maybe occur for more than one reasons :

1-Network 
2-Proxy
3-http
4-Session Time 


But today i will discuss the problem On oracle Application server 10g .
Description for the problem like the following when you try to connect on your deploy application On OAS 10g it’s gives the above error from 1-5 minutes.

I will give you more than one solution maybe it will be related to the above problem and you try them separately to see which one will be valid for you : 

1-Netowrk Parameters :

You will find it $ORACLE_HOME/forms/server/default.env
Just increase the value .

2-do the following change in opmn.xml (under $ORACLE_HOME/opmn/conf/):

 

 

3-SET Inbound_connection_timeout In sqlnet.ora to ZERO .

Sqlnet.Inbound_connection_timeout = 0

Note : if your can’t find this parameter in the SQLNET.ORA you cant add it .

5- Change the following $ORACLE_HOME/opmn/conf/opmn.xml

 


Hope this will work 

Share

To find the ROW Counts of tables that belongs to a Particular Schema

September 12th, 2017, posted in Oracle
Share
select table_name,num_rows counter from dba_tables where owner=’Schema_name’ order by table_name;
Share

Network Unauthenticated 2 Icon Showing On Network Card Limited connectivity

August 21st, 2017, posted in Windows
Share

Network disconnected automatically and showing “Network Unauthenticated” on the “Local Area Connection”

Follow below steps to get the issue resolve :
Steps: 1
  • Go To The services.msc > Right Click on “Network Location Awareness” and Open Propertiesin General tab > change Startup Type as “Automatic (Delayed Start)” and Restart the Services
  • Follow same procedures for “Network List Services” ( Dependency on above service)

Steps: 2 

  • Go To the Command Promptand type below commands & hit Enter after each and every command

netsh
winsock
reset
Once the winsock reset you Must be Restart the System

Steps: 3

  •  Try to Enable/Disabled Network Card

Steps: 4

  • Right Click on Network icon and Open Network & sharing centerclick on Change Adapter settingsRight Click on Local Area Connection and open PropertiesClick on configure button > Select Power Management Tab > and Unchecked Allow the computer to turn off this device to save power (Same for all option available in below)
  • Restart the System/Computer

Steps: 5

  • Unjoin/Remove the workstation/machine from the Domain then delete All computer account from the Active Directory and rejoin or re-welcome in Domain

Steps: 6

  • E.g. – If  the Domain name is “CYBTEST.COM” and you find the name on the Network Card is changed as CYBTEST.COM 2” then edit and change as “CYBTEST.COM” in Registry as follows.
  • Open registry editor using regedit command > click on Edit > Findtype CYBTEST.COM  2
  • Find all changed entries and edit as normal CYBTEST.COM

Steps: 7 Change the NIC Dynamic port using batch file or below command line )

  • @echo off
    color 02
    netsh int ipv4 show dynamicport tcp
    pause
    echo “Dynamic port WILL SET as starting from 1025 to num=64510”
    pause
    netsh int ipv4 set dynamicport tcp start=1025 num=64510
    pause
    netsh int ipv4 show dynamicport tcp
    pause
    shutdown -r -t 05
Share

Find A String In Database

July 1st, 2017, posted in Oracle
Share

I’ve tried using this statement below to find an appropriate column based on what I think it should be named but it returned no results :

SELECT * from dba_objects WHERE
object_name like '%DTN%'

A column isn't an object. If you mean that you expect the column name to be like '%DTN%', the query you want is:

SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%DTN%';
Share

Find SIM Registered With Your IDs in Telecom Service Providers

June 14th, 2017, posted in Kingdom, TEChNoLoGY
Share

Find SIM Registered With Your IDs in Telecom Service Providers 



Overview

‘My numbers’ service allows users to know details about all telephone numbers and data SIM registered with their IDs in Telecom Service Providers systems in order for the users to monitor their numbers and ensure no SIM registered with their names without permissions. CITC is looking forward to ensure user protection, maintain privacy, prevent misuse of user’s credentials by others without permissions.


Steps

Type the ID number of the user and the mobile number registered with that ID. In case the user does not have a subscription, the user can check that by typing the ID details.


Objection

In case any user found a number registered with his name without his permission or found a failure to execute an earlier request to cancel the service by the service provider, a complaint should be reported to the service provider immediately using the complaints services on CITC website choosing the appropriate service provider, complaint type, and providing the details of the SIM number being reported. If there is an objection regarding the validity of the information provided by ‘My numbers’ service and the complaint of the user has not been resolved by the service provider within 15 days, the user can escalate the complaint to CITC.

Share