sdfly: 2018

複習 DBA Skills/Oracle -- 進深 1

A. 在我整理的Nodepad Plus Plus Projects for JDFD的DBA ITEMS中的第31項：31_allbackups(備份)
1. %ORACLE_HOME%\product\11.2.0\dbhome_1\assistants\dbca\templates (Ref : Oracle -- Database Configuration Assistant (DBCA) templates)中有兩個 file：

(1). Oracle Database's Control File：Seed_Database.ctl

(2). Oracle Database's Data File：Seed_Database.dfb

它們被回復成：

a. SYSTEM01.DBF
b. SYSAUX01.DBF

c. UNDOTBS01.DBF

d. USERS01.DBF (存儲/表空間/USERS/資料檔案Data File*)

(可以查看：cloneDBCreation.log)

1. 執行 %ORACLE_HOME%\product\11.2.0\dbhome_1\assistants\dbca\templates (Ref : Oracle -- Database Configuration Assistant (DBCA) templates) 回復的 SQL Script：

set verify off;

set echo off;

set serveroutput on;

select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;

variable devicename varchar2(255);

declare

omfname varchar2(512) := NULL;

done boolean;

begin

dbms_output.put_line(' ');

dbms_output.put_line(' Allocating device.... ');

dbms_output.put_line(' Specifying datafiles... ');

:devicename := dbms_backup_restore.deviceAllocate;

dbms_output.put_line(' Specifing datafiles... ');

dbms_backup_restore.restoreSetDataFile;

dbms_backup_restore.restoreDataFileTo(1, '%ORACLE_HOME%\oradata\orcl4\SYSTEM01.DBF', 0, 'SYSTEM');

dbms_backup_restore.restoreDataFileTo(2, '%ORACLE_HOME%\oradata\orcl4\SYSAUX01.DBF', 0, 'SYSAUX');

dbms_backup_restore.restoreDataFileTo(3, '%ORACLE_HOME%\oradata\orcl4\UNDOTBS01.DBF', 0, 'UNDOTBS1');

dbms_backup_restore.restoreDataFileTo(4, '%ORACLE_HOME%\oradata\orcl4\USERS01.DBF', 0, 'USERS');

dbms_output.put_line(' Restoring ... ');

dbms_backup_restore.restoreBackupPiece('%ORACLE_HOME%\product\11.2.0\dbhome_1/assistants/dbca/templates\Seed_Database.dfb', done);

if done then

dbms_output.put_line(' Restore done.');

else

dbms_output.put_line(' ORA-XXXX: Restore failed ');

end if;

dbms_backup_restore.deviceDeallocate;

end;

select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;

0 Comments

開發 Angular.io's WebPack Project 情境 10 -- 回歸基礎 2

清晨6:03

0 Comments

開發 Angular.io's WebPack Project 情境 9 -- 回歸基礎 1

晚上7:51

開發 Angular.io's WebPack Project 情境 9 -- 回歸基礎 1

1. Node JS，使用Active LTS()真的很重要 -- About：Node.js(Server Side JS) and NPM CLI version

15-1_Active LTS Version：8.x
15-1-1_Status：Active LTS
15-1-2_Codename：Carbon
15-1-3_Initial Release：2017-05-30
15-1-4_Active LTS Start：2017-10-31
15-1-5_Maintenance LTS Start：April 2019
15-1-6_End-of-life：December 20191
(15-1 的數字是我的NotePad++ Project內Node.js(Server Side JS) and NPM CLI version內Element的數字。之後我都以此為記述、回查標準。)

2. Active LTS Version，版本固定，不會隨便被其他的開發者更新了Node、NPM、CLI的版本，導致於各專案內的Node、NPM、CLI的版本錯亂。程式無法編譯、無法執行。定版的工作對我而言很重要。

(1). 目前，我的電腦的Node/NPM的環境版本為：5.6.0 。而在此期間Node/NPM的版本，已經從：5.6.0→ 變為：6.1.0→ 變為：6.3.0。(你總會看到：Update available 5.6.0 → 6.3.0，Run npm i npm to updatek的訊息。)。我的規劃：我不會更新。雖然，Global的環境，Angular CLI的版本已經被我升級到: 6.1.1、@angular-devkit的版本已經被我升級到: 0.7.1。

(2). 我的其中的一個範例專案的環境，Angular CLI的版本仍是: 6.0.8、@angular-devkit的版本仍是: 0.6.8。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Angular CLI: 6.0.8
Node: 8.11.3
OS: win32 x64
Angular: 6.1.0
... animations, common, compiler, compiler-cli, core, forms
... http, language-service, platform-browser
... platform-browser-dynamic, router

Package Version
-----------------------------------------------------------
@angular-devkit/architect 0.6.8
@angular-devkit/build-angular 0.6.8
@angular-devkit/build-optimizer 0.6.8
@angular-devkit/core 0.6.8
@angular-devkit/schematics 0.6.8
@angular/cdk 6.4.1
@angular/cli 6.0.8
@angular/material 6.4.1
@ngtools/webpack 6.0.8
@schematics/angular 0.6.8
@schematics/update 0.6.8
rxjs 6.2.2
typescript 2.7.2
webpack 4.8.3
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

0 Comments

開發 Angular.io's WebPack Project 情境 8 -- 第一次感受到Node的威力 !!

凌晨12:02

0 Comments

使用 Open Source Project 1 情境 1 -- Open Source Project 1 -- Administrator

晚上8:50

0 Comments

開發 Flex 情境 23 -- Flex Debug-- Part I

清晨6:31

0 Comments

Maven 情境 13 -- About：maven-resources-plugin:2.5 or one of its dependencies could not be resolved

晚上7:47

0 Comments

開發 Flex 情境 22 -- 關於 : Flex 比較 4 -- Upgrade 至新的 Adobe® Flash® Builder™® 4.7 成功 !! (Use：Flex SDK 4.6) -- Part II

晚上10:20

開發 Flex 情境 22 -- 關於 : Flex 比較 3 -- Upgrade 至新的 Adobe® Flash® Builder™® 4.7 成功 !!

Upgrade 至新的 Adobe® Flash® Builder™® 4.7 成功 !! (Use：Flex SDK 4.6) -- Part II

1. Flex Project：

(1). Flex SDK 3.2：

a. 舊版的 html-template，和新版的 html-template 內的 index.template.html、JS File(NEW：swfobject.js) 不一樣，所以Upgrade Project時，要用新版的 html-template。

b. 舊版的 html-template，使用AC_OETags.js，Gen 出 <object><embed>The Content</embed></object>：

".......If you are using the wrapper that is generated by the web-tier compiler or Adobe® Flex® Builder™, or one of the
wrappers that are included in the /templates directory, your wrapper will probably be very different from the
previous example. These wrappers call functions in the AC_OETags.js file to build the <object> and <embed>
tag structure in the HTML page......"

c. 新版的 html-template，使用swfobject.js，Gen 出 <script>。


<html lang="en">



<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />


<link rel="stylesheet" type="text/css" href="history/history.css" />


<title>${title}</title>
<script src="AC_OETags.js" language="javascript"></script>


<script src="history/history.js" language="javascript"></script>


<style>
body { margin: 0px; overflow:hidden }
</style>
<script language="JavaScript" type="text/javascript">

</script>
</head>

<body scroll="no">
<script language="JavaScript" type="text/javascript">

</script>
<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
id="${application}" width="${width}" height="${height}"
codebase="http://fpdownload.macromedia.com/get/flashplayer/current/swflash.cab">
<param name="movie" value="${swf}.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="${bgcolor}" />
<param name="allowScriptAccess" value="sameDomain" />
<embed src="${swf}.swf" quality="high" bgcolor="${bgcolor}"
width="${width}" height="${height}" name="${application}" align="middle"
play="true"
loop="false"
quality="high"
allowScriptAccess="sameDomain"
type="application/x-shockwave-flash"
pluginspage="http://www.adobe.com/go/getflashplayer">
</embed>
</object>
</noscript>
</body>
</html>

(2). Flex SDK 4.6：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
<title>${title}</title>
<meta name="google" value="notranslate" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<style type="text/css" media="screen">
html, body { height:100%; }
body { margin:0; padding:0; overflow:auto; text-align:center;
background-color: ${bgcolor}; }
object:focus { outline:none; }
#flashContent { display:none; }
</style>




<script type="text/javascript" src="swfobject.js"></script>
<script type="text/javascript">
// For version detection, set to min. required Flash Player version, or 0 (or 0.0.0), for no version detection.
var swfVersionStr = "${version_major}.${version_minor}.${version_revision}";
// To use express install, set to playerProductInstall.swf, otherwise the empty string.
var xiSwfUrlStr = "${expressInstallSwf}";
var flashvars = {};
var params = {};
params.quality = "high";
params.bgcolor = "${bgcolor}";
params.allowscriptaccess = "sameDomain";
params.allowfullscreen = "true";
var attributes = {};
attributes.id = "${application}";
attributes.name = "${application}";
attributes.align = "middle";
swfobject.embedSWF(
"${swf}.swf", "flashContent",
"${width}", "${height}",
swfVersionStr, xiSwfUrlStr,
flashvars, params, attributes);
// JavaScript enabled so display the flashContent div in case it is not replaced with a swf object.
swfobject.createCSS("#flashContent", "display:block;text-align:left;");
</script>
</head>
<body>

<div id="flashContent">
<p>
To view this page ensure that Adobe Flash Player version
${version_major}.${version_minor}.${version_revision} or greater is installed.
</p>
<script type="text/javascript">
var pageHost = ((document.location.protocol == "https:") ? "https://" : "http://");
document.write("<a href='http://www.adobe.com/go/getflashplayer'><img src='"
+ pageHost + "www.adobe.com/images/shared/download_buttons/get_flash_player.gif' alt='Get Adobe Flash player' /></a>" );
</script>
</div>

<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="${width}" height="${height}" id="${application}">
<param name="movie" value="${swf}.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="${bgcolor}" />
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="true" />

<object type="application/x-shockwave-flash" data="${swf}.swf" width="${width}" height="${height}">
<param name="quality" value="high" />
<param name="bgcolor" value="${bgcolor}" />
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="true" />


<p>
Either scripts and active content are not permitted to run or Adobe Flash Player version
${version_major}.${version_minor}.${version_revision} or greater is not installed.
</p>

<a href="http://www.adobe.com/go/getflashplayer">
<img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash Player" />
</a>

</object>

</object>
</noscript>
</body>
</html>

(圖1)

(圖2) 刪除舊版SDK在bin-debug內的檔案

(圖3)

(圖4) 設定Locale，for Taiwan

(圖5) 用新版的 SDK，開始Build專案

(圖6) 用新版的 SDK，釋出(Release)專案

(圖7)

(圖8)

(圖9) Copy 至專案內。在專案內執行失敗，因為Framework框架是吃到舊版的SDK。

(圖10) 直接執行，成功。

d. 新版的 Flash Builder，新增了Export the release build of the project的功能，同時，它會跟你說在Upgrade Project的工程中，在各個 Module內，原本用的舊版的SDK的寫法，有哪一些在新版的 SDK中已經不適用(不管是：刪除、不建議、衝突......)，所以，可以開始進行程式Upgrdae層級的修改、Troubleshooting、re-factoring、或是改寫、重寫：

(a). Troubleshooting：

i. About：loadStyleDeclarations：

See details for more information. Encountered errors or warnings while building project Main.mxml. MainScript.as: 'loadStyleDeclarations' has been deprecated since 4.0. Please use 'IStyleManager2.loadStyleDeclarations on a style manager instance'.

0 Comments

開發 Flex 情境 22 -- 關於 : Flex 比較 3 -- Upgrade 至新的 Adobe® Flash® Builder™® 4.7 成功 !!

凌晨12:19

0 Comments

開發 Flex 情境 22 -- 關於 : Flex 比較 2

晚上10:55

開發 Flex 情境 22 -- 關於 : Flex 比較 2

1. Main.html：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
<title></title>
<meta name="google" value="notranslate" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<style type="text/css" media="screen">
html, body { height:100%; }
body { margin:0; padding:0; overflow:auto; text-align:center;
background-color: #ffffff; }
object:focus { outline:none; }
#flashContent { display:none; }
</style>



<link rel="stylesheet" type="text/css" href="history/history.css" />
<script type="text/javascript" src="history/history.js"></script>


<script type="text/javascript" src="swfobject.js"></script>
<script type="text/javascript">
// For version detection, set to min. required Flash Player version, or 0 (or 0.0.0), for no version detection.
var swfVersionStr = "11.1.0";
// To use express install, set to playerProductInstall.swf, otherwise the empty string.
var xiSwfUrlStr = "playerProductInstall.swf";

/**
1.
通過創建一個名為flashvars的對象添加Flash變量變量，在該對像上設置屬性，
然後將該對像傳遞給：swfobject.embedSWF()
2.
  The value of the flashVars properties do not have to be static. If you use JSP to return the
wrapper, for example, you can use any JSP expression for the value of
the flashVars properties that can be evaluated to a String.
3.
Flash Builder 會自動更新Main.html的內容回原本預設的內容，所以，當build project
之後，加在flashvars、params內的新的內容，會被復舊。執行時，Main.mxml會無法取
用到新的parameter，會出現undefine的錯誤，或null的錯誤(當在Flash UI Component元件
內使用{}的時候) -- 註1。
*/
var flashvars = {};

var params = {};

params.quality = "high";
params.bgcolor = "#ffffff";
params.allowscriptaccess = "sameDomain";
params.allowfullscreen = "true";
var attributes = {};
attributes.id = "Main";
attributes.name = "Main";
attributes.align = "middle";
swfobject.embedSWF(
"Main.swf", "flashContent",
"100%", "100%",
swfVersionStr, xiSwfUrlStr,
flashvars, params, attributes);
// JavaScript enabled so display the flashContent div in case it is not replaced with a swf object.
swfobject.createCSS("#flashContent", "display:block;text-align:left;");
</script>
</head>
<body>

<div id="flashContent">
<p>
To view this page ensure that Adobe Flash Player version
11.1.0 or greater is installed. -- XXX
</p>
<script type="text/javascript">
var pageHost = ((document.location.protocol == "https:") ? "https://" : "http://");
document.write("<a href='http://www.adobe.com/go/getflashplayer'><img src='"
+ pageHost + "www.adobe.com/images/shared/download_buttons/get_flash_player.gif' alt='Get Adobe Flash player' /></a>" );
</script>
</div>

<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="100%" height="100%" id="Main">
<param name="movie" value="Main.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="#ffffff" />
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="true" />

<object type="application/x-shockwave-flash" data="Main.swf" width="100%" height="100%">
<param name="quality" value="high" />
<param name="bgcolor" value="#ffffff" />
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="true" />


<p>
Either scripts and active content are not permitted to run or Adobe Flash Player version
11.1.0 or greater is not installed. -- YYY
</p>

<a href="http://www.adobe.com/go/getflashplayer">
<img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash Player" />
</a>

</object>

</object>
</noscript>
</body>
</html>

2. index.html：

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8"/>
<title>flex4-project-1</title>
<meta name="description" content="" />

<script src="js/swfobject.js"></script>
<script>
var flashvars = {
};
var params = {
menu: "false",
scale: "noScale",
allowFullscreen: "true",
allowScriptAccess: "always",
bgcolor: "",
wmode: "direct" // can cause issues with FP settings & webcam
};
var attributes = {
id:"flex4-project-1"
};
swfobject.embedSWF(
"flex4-project-1.swf",
"altContent", "100%", "100%", "10.0.0",
"expressInstall.swf",
flashvars, params, attributes);
</script>
<style>
html, body { height:100%; overflow:hidden; }
body { margin:0; }
</style>
</head>
<body>
<div id="altContent">
<h1>flex4-project-1</h1>
<p><a href="http://www.adobe.com/go/getflashplayer">Get Adobe Flash player</a></p>
</div>
</body>
</html>

註1：因此，Main.mxml的內容，以及Call Main.swf的方式如下

(1).

http://localhost:61221/flex-project-2/Main.swf?myName=yuehchung

(2).

<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600"
applicationComplete="init()">

<fx:Style>
/*Button {
color:red;
}*/
</fx:Style>
<fx:Script>
<![CDATA[
// import mx.messaging.messages.AsyncMessage;
// import mx.messaging.messages.IMessage;
import mx.core.FlexGlobals;

/* Declare bindable properties in Application scope. */
[Bindable]
public var myName:String;
[Bindable]
public var myHometown:String;

private function init():void
{
myName = FlexGlobals.topLevelApplication.parameters.myName;
}

protected function button2_clickHandler(event:MouseEvent):void
{
log.text += "firstName:"+FlexGlobals.topLevelApplication.parameters.myName +"\n";
}
protected function button3_clickHandler(event:MouseEvent):void
{
for (var i:String in FlexGlobals.topLevelApplication.parameters) {
log.text += i + ":" + FlexGlobals.topLevelApplication.parameters[i] + "\n";
}
}
]]>
</fx:Script>

<fx:Declarations>

<fx:Model id="MyEmployee">
<root>
<name>
<first>Will</first>
<last>Tuckerman</last>
</name>
<department>Accounting</department>
<email>wtuckerman@wilsoncompany.com</email>
</root>
</fx:Model>

</fx:Declarations>
<s:Panel title="Chat" top="12" bottom="12" left="12" right="12">
<s:TextArea id="log" width="100%" height="100%" borderVisible="false"/>
<s:controlBarContent>
<mx:Form width="100%" paddingTop="4" paddingBottom="4" paddingLeft="4" paddingRight="4">
<mx:FormItem label="User Id:{myName}">
<s:TextInput id="userId" width="100" enter=""/>
</mx:FormItem>
<mx:FormItem label="Message:" width="100%" direction="horizontal">
<s:TextInput id="msg" width="100%" enter=""/>
<s:Button label="Send 1" click="button2_clickHandler(event)"/>
<s:Button label="Send 2" click="button3_clickHandler(event)"/>
</mx:FormItem>
</mx:Form>
</s:controlBarContent>
</s:Panel>
</s:Application>

0 Comments

sdfly

複習 DBA Skills/Oracle -- 進深 4

複習 DBA Skills/Oracle -- 進深 3

複習 DBA Skills/Oracle -- 進深 2

複習 DBA Skills/Oracle -- 進深 1

開發 Angular.io's WebPack Project 情境 10 -- 回歸基礎 2

開發 Angular.io's WebPack Project 情境 9 -- 回歸基礎 1

開發 Angular.io's WebPack Project 情境 8 -- 第一次感受到Node的威力 !!

使用 Open Source Project 1 情境 1 -- Open Source Project 1 -- Administrator

開發 Flex 情境 23 -- Flex Debug-- Part I

Maven 情境 13 -- About：maven-resources-plugin:2.5 or one of its dependencies could not be resolved

開發 Flex 情境 22 -- 關於 : Flex 比較 4 -- Upgrade 至新的 Adobe® Flash® Builder™® 4.7 成功 !! (Use：Flex SDK 4.6) -- Part II

開發 Flex 情境 22 -- 關於 : Flex 比較 3 -- Upgrade 至新的 Adobe® Flash® Builder™® 4.7 成功 !!

開發 Flex 情境 22 -- 關於 : Flex 比較 2

總網頁瀏覽量

Translate

背景音樂

About me

Press

recent posts

Blog Archive

sdfly

Press

Follow on instagram

訂閱

總網頁瀏覽量

Translate

背景音樂

訂閱

About me

Press

recent posts

Blog Archive

訂閱

Press

Follow on instagram