Saturday, February 29, 2020
odbc configure in oracle database
ODBC configure & run time data sink in oracle database
--------------------------|||||------------------------
# install fingerTech
#finally create new database.. video mistec
# connect to punch machine ip
# Create system dns face
C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\hs\admin
HS_FDS_CONNECT_INFO = face
HS_FDS_TRACE_LEVEL = off
C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\network\admin
listener.ora
(SID_DESC =
(SID_NAME = face)
(ORACLE_HOME = C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1)
(PROGRAM = dg4odbc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle12c\app\OracleHomeUser1\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
tnsnames.ora
FACEDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SID = face))
(HS=OK)
)
conn sys as sysdba
create user root identified by root;
grant connect,resource,dba to root;
conn root/root@orcl
DROP PUBLIC DATABASE LINK FACELINK;
CREATE PUBLIC DATABASE LINK "FACELINK"
CONNECT TO "root"
IDENTIFIED BY "root"
USING 'FACEDB';
restart pc and check --
select * from auditdata@facelink;
select "serialno",to_char("checktime",'DD-MON-RR HH24:MI:SS') from auditdata@facelink;
Sunday, February 23, 2020
Top Rank
WITH cte_products AS (
select pack_size,b_code,p_name,nvl(totww-ttee,0) ssss,
RANK() OVER(ORDER BY nvl(totww-ttee,0) DESC) price_rank
from
(
select c.pack_size,b.b_code,c.p_name,nvl(sum(qty),0) totww, nvl(sum(rqty),0) ttee
from jpldba.INVOICE_MAST@fremote10g a, jpldba.INVOICE_CHILD@fremote10g b, jpldba.price@fremote10g c
where a.inv_no=b.inv_no
and b.b_code=c.b_code
and a.empcode='CTG169'
--and b.b_code='HSTS2'
and inv_date between '01-FEB-20' and '28-FEB-20'
group by c.pack_size,b.b_code,c.p_name
))
SELECT
pack_size,
b_code,
p_name,
ssss,
price_rank
FROM
cte_products
WHERE
price_rank <= 5
order by price_rank
/
select pack_size,b_code,p_name,nvl(totww-ttee,0) ssss,
RANK() OVER(ORDER BY nvl(totww-ttee,0) DESC) price_rank
from
(
select c.pack_size,b.b_code,c.p_name,nvl(sum(qty),0) totww, nvl(sum(rqty),0) ttee
from jpldba.INVOICE_MAST@fremote10g a, jpldba.INVOICE_CHILD@fremote10g b, jpldba.price@fremote10g c
where a.inv_no=b.inv_no
and b.b_code=c.b_code
and a.empcode='CTG169'
--and b.b_code='HSTS2'
and inv_date between '01-FEB-20' and '28-FEB-20'
group by c.pack_size,b.b_code,c.p_name
))
SELECT
pack_size,
b_code,
p_name,
ssss,
price_rank
FROM
cte_products
WHERE
price_rank <= 5
order by price_rank
/
Wednesday, February 12, 2020
How to configure ords on weblogic 12c
ords on weblogic 12c
1-----------------CMD
cd D:\apex_19.2\apex
sqlplus
sys as sysdba
@apexins.sql sysaux sysaux temp /i/
@apxchpwd.sql
@apxldimg.sql D:\apex_19.2
@apex_rest_config.sql
@apex_epg_config.sql D:\apex_19.2
2-----------------Download
Download Ords
Paste in D:\ORDS
Paste images filder from apex to ords
3-----------------CMD
Microsoft Windows [Version 10.0.18363.418]
(c) 2019 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>cd D:\ords
C:\Users\Administrator>D:
D:\ords>java -jar D:\ORDS\ords.war static D:\ORDS\images
WAR Generation complete
WAR location : D:\ords\i.war
Context path : /i
Static resources : D:\ORDS\images
Ensure the static resources are available at path: D:\ORDS\images
on the server where the WAR is deployed
D:\ords>java -jar D:\ORDS\ords.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data: D:\ORDS\config
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:orcl
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Mar 04, 2020 4:02:12 PM
INFO: reloaded pools: []
Installing Oracle REST Data Services version 19.2.0.r1991647
... Log file written to C:\Users\Administrator\ords_install_core_2020-03-04_160212_00785.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to C:\Users\Administrator\ords_install_datamodel_2020-03-04_160222_00521.log
... Log file written to C:\Users\Administrator\ords_install_apex_2020-03-04_160223_00989.log
Completed installation for Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:12.678
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
D:\ords>
4---------------------configure
in weblogic development section
5---------------------sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 4 16:09:46 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SELECT resource_name, limit
FROM dba_profiles
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> alter user ords_public_user identified by Munshi#1 account unlock
2 /
User altered.
SQL> alter user APEX_PUBLIC_USER identified by Munsi#1 account unlock
2 /
User altered.
SQL> alter user ORDS_PUBLIC_USER identified by Munsi#1 account unlock
2 /
User altered.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
User altered.
if not ok then
Finally Copy and apex images forlder to ords
download ords
1-----------------CMD
cd D:\apex_19.2\apex
sqlplus
sys as sysdba
@apexins.sql sysaux sysaux temp /i/
@apxchpwd.sql
@apxldimg.sql D:\apex_19.2
@apex_rest_config.sql
@apex_epg_config.sql D:\apex_19.2
2-----------------Download
Download Ords
Paste in D:\ORDS
Paste images filder from apex to ords
3-----------------CMD
Microsoft Windows [Version 10.0.18363.418]
(c) 2019 Microsoft Corporation. All rights reserved.
C:\Users\Administrator>cd D:\ords
C:\Users\Administrator>D:
D:\ords>java -jar D:\ORDS\ords.war static D:\ORDS\images
WAR Generation complete
WAR location : D:\ords\i.war
Context path : /i
Static resources : D:\ORDS\images
Ensure the static resources are available at path: D:\ORDS\images
on the server where the WAR is deployed
D:\ords>java -jar D:\ORDS\ords.war
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data: D:\ORDS\config
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:orcl
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Retrieving information.
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Mar 04, 2020 4:02:12 PM
INFO: reloaded pools: []
Installing Oracle REST Data Services version 19.2.0.r1991647
... Log file written to C:\Users\Administrator\ords_install_core_2020-03-04_160212_00785.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to C:\Users\Administrator\ords_install_datamodel_2020-03-04_160222_00521.log
... Log file written to C:\Users\Administrator\ords_install_apex_2020-03-04_160223_00989.log
Completed installation for Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:12.678
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
D:\ords>
4---------------------configure
in weblogic development section
5---------------------sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 4 16:09:46 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SELECT resource_name, limit
FROM dba_profiles
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> alter user ords_public_user identified by Munshi#1 account unlock
2 /
User altered.
SQL> alter user APEX_PUBLIC_USER identified by Munsi#1 account unlock
2 /
User altered.
SQL> alter user ORDS_PUBLIC_USER identified by Munsi#1 account unlock
2 /
User altered.
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
User altered.
if not ok then
Finally Copy and apex images forlder to ords
download ords
https://www.oracle.com/database/technologies/appdev/rest-data-services-v192-downloads.html
configure guide
http://info.aimstar.com/blog/deploying-ords-on-weblogic-for-apex
http://info.aimstar.com/blog/deploying-ords-on-weblogic-for-apex
sms apex
sms
var iuser = "jayson";
var ipass = "98n<9I84";
var isid = "JaysonNonEng";
var sms_txt = "Send Test SMS";
var Mob_No = "+8801744642682";
//
var xhttp = new XMLHttpRequest();
var parameters="user="+iuser+"&pass="+ipass+"&sid="+isid+"&sms[0][0]="+Mob_No+"&sms[0][1]="+sms_txt+"&[0][2]=1234567891";
//
xhttp.open("POST","http://sms.sslwireless.com/pushapi/dynamic/server.php", true);
xhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
xhttp.send(parameters);
var iuser = "jayson";
var ipass = "98n<9I84";
var isid = "JaysonNonEng";
var sms_txt = "Send Test SMS";
var Mob_No = "+8801744642682";
//
var xhttp = new XMLHttpRequest();
var parameters="user="+iuser+"&pass="+ipass+"&sid="+isid+"&sms[0][0]="+Mob_No+"&sms[0][1]="+sms_txt+"&[0][2]=1234567891";
//
xhttp.open("POST","http://sms.sslwireless.com/pushapi/dynamic/server.php", true);
xhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
xhttp.send(parameters);
Subscribe to:
Posts (Atom)
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ... -
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...