TRENDZ: Identifying Online Job Seekers' Behavior with Respect to Global Slump

       
       
            Abdulaziz S. Almazyad, Zafar Iqbal Khan, Mohammad Khubeb Siddiqui
       
       
            "TRENDZ: Identifying Online Job Seekers' Behavior with Respect to Global Slump" in
       
        International Conference on Advanced Computer Theory and Engineering (ICACTE 2009),
         ASME Press, New York, NY (2009).

        DOI: 10.1115/1.802977.paper148

        http://link.aip.org/link/doi/10.1115/1.802977.paper148http://link.aip.org/link/doi/10.1115/1.802977.paper148">http://link.aip.org/link/doi/10.1115/1.802977.paper148>       
 

 

Solution to: ORA-01033: ORACLE initialization or shutdown in progress

ORA-01033  error occurs when client is not connected to the Oracle Databas,it is in the process of initializing or shutting down and when the database service is in the process of starting or stopping.
This error message indicates that the database has crashed.

cmd>sqlplus mining/mining@mining


ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

cmd--> sqlplus /nolog

connected

C:\>set ORACLE_SID=mining

SQL>conn sys/sys as sysdba
connected
SQL> shut abort
SQL>startup mount
SQL>recover database
SQL>alter database open;

If, you directly give the :
SQL>startup

possibly,it will show the following error.

ORA-01172: recovery of thread 1 stuck at block 9 of file 2

ORA-01151: use media recovery to recover block, restore backup if needed.

Listener: Amazing Issue

A part of the Oracle DBMS that "listens" for users connecting to the database. It directs the queries to a function that either creates a dedicated server process for each user or to a shared multithreaded function that handles many users.
File located at ORACLE_HOME\network\admin

If there is 'N' of database at server, but the listener would be common for all the database.At a time there is only listener would be active.

The issue that i face, after creation of database listener.ora file exist with required parameter.
- I am able to connect SQLPLUS,but when I try to connect my client application its unable to connect, how rediculous is it.

start-->cmd-->lsnrctl
lsnrctl> services
LSNRCTL> services


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MohammadKhub)(PORT=1521)
))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error


it shows the parameter of listener including port, machine,etc and shows error.

and the important this is that i am able to connect with my database:
cmd-->sqlplus sys/sys as sysdba
SQL>


hey......... its an amazing.....

Problem is that i m not able to Oracle Client application that is ODMr.

C:\Users\Mohammad Khubeb>ping MohammadKhub

Pinging MohammadKhub [fe80::cad:1010:a3cf:f945%10] from fe80::cad:1010:a3cf:f945
%10 with 32 bytes of data:
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Reply from fe80::cad:1010:a3cf:f945%10: time<1ms
Ping statistics for fe80::cad:1010:a3cf:f945%10:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Mohammad Khubeb>tnsping HD_MohammadKhub
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 24-FEB-2
010 18:38:00
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
C:\oracle_DB\product\10.2.0\db_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name

that an issue to my listener.

then i prepare fresh listener with NCA utility and disabled previous one.

and I check through lsnrctl utility.

start-->cmd-->lsnrctl
LSNRCTL> services

now my Client application is connected to Database server.

Publications

1. Abdulaziz S. Al- Mazyad, Mohammad Khubeb Siddiqui, Yasir Ahmad Zafar Iqbal Khan “An Incremental View Maintenance Approach Using Version Store in Warehousing Environment”, WCSE,Qingdao, CHINA, IEEE Proc. Second International Workshop on Computer Science and Engineering, Volume 1, pp 69-73,s 28-30, October 2009. ( http://www.computer.org/portal/web/csdl/doi/10.1109/WCSE.2009.624 )

2.  Abdulaziz S. Al- Mazyad,Zafar Iqbal Khan, Mohammad Khubeb Siddiqui “Trendz: Identifying Online job seekers’ behavior with respect to Global Slump” The 2nd INTERNATIONAL CONFERENCE ON Advanced COMPUTER Theory and Engineering (ICACTE 2009), Cairo Egypt. The ICACTE 2009 proceeding is published by the American Society of Mechanical Engineers Press (ASME), indexed by the Ei Compendex and Thomson ISI Proceeding (ISTP)

Restricting SYSDBA in Remote System.

How we Restrict SYSDBA login in Remote Computer?
This We can do by---
SQL> conn sys/sys@ as sysdba
Alter system set remote_login_passwordfile=NONE;
SQL> Shut immediate
Take the startup

Procedure to insert millions of record

SQL>create table T(a number,b varchar2(12),c varchar2(9));

SQL>begin
for i in 1..1000000
insert into values
(i,dbms_random.string('U',4),dbms_random.value(1,1000));
if mod(i,10000)=0 then
commit;
end if;
end loop;
end;
/

This procedure is to help you to insert n number of record with random values.

DBMS_RANDOM

DBMS.RANDOM: allows to generate the random number of values.

dbms_random.value(lowerlimit,highlimit): Is used to generate the random numeric values in a given limit.
eg:dbms_random.value(1,1000)

dbms_random.string(opt,length): is used to generate the random string, in a specified length.
eg:dbms_random.string('U',10)
'u' or 'U':
Upper case alpha characters
'l' or 'L':
Lower case alpha characters
'a' or 'A':
Upper and lower case alpha characters
'x' or 'X':
Upper alpha and numeric characters
'p' or 'P':
Any printable character