麻花豆星空天美糖心

鏂颁含鎶ヨ�霸繀闃垮簡鎶ラ亾

涔濆购榛�9.1瀹夎�呮暀绋嬶細瀹屾垚浣阱购榛�9.1鐗堟湰鐨勫畨瑁卂鍒╃帅绯荤粺閮ㄧ讲鎸囧崡|

链�鏂囦负涓撲笟鎶�链�浜憾蜆鎻愪緵浣阱购榛�9.1鐗堟湰鍦ㄥ埄鐜涚幆澧冧笅鐨勫畬鏁村畨瑁呮寚鍗楋紝鍖呭惈绯荤粺瑕佹眰鏍告煡銆佸畨瑁呭寘楠岃瘉銆佸弬鏁伴厤缃�鎶�宸у强宁歌�佹姤閿欒В鍐虫柟妗堛�傞赌氳绷鍏�涓�鏍稿绩姝ラ�ゆ紨绀轰粠鐜�澧冨噯澶囧埌链嶅姟楠岃瘉鐨勫叏娴佺▼鎿崭綔锛岀壒鍒�閽堝�筄谤补肠濒别鏁版嵁搴挞泦鎴愬拰绯荤粺鍒濆�嬪寲杩涜�屾繁搴﹁В鏋愩赌�

涓赌銆佷节骞洪粍9.1鐗堟湰瀹夎�呯幆澧冨噯澶�

鍦ㄩ儴缃蹭節骞洪粍9.1鍓嶉渶纭�璁ゆ湇鍔″櫒婊¤冻Windows Server 2016鎴栨洿楂樼増鏈�瑕佹眰锛屽缓璁�閰嶇疆鑷冲皯16鏍窩PU/64GB鍐呭瓨/1TB SSD瀛樺偍绌洪棿銆傚埄鐜涚郴缁熶緷璧栫粍浠跺寘鎷�.NET Framework 4.
8銆乂isual C++ 2019杩愯�屽簱銆丱racle 19c瀹㈡埛绔�宸ュ叿绛夈�傜壒鍒�娉ㄦ剰闇�鍦ㄦ帶鍒堕潰鏉�-绋嬪簭涓�鍚�鐢↖IS Web鏈嶅姟鍣ㄨ�掕壊锛屽苟瀹夎�匒SP.NET 4.7妯″潡銆傜�佺洏鍒嗗尯寤鸿��鍒掑垎D鐩樼敤浜庡畨瑁呬富绋嬪簭锛孍鐩樺瓨鏀炬棩蹇楁枃浠讹紝纭�淇漀TFS鏍煎紡涓斿墿浣欑┖闂翠笉浣庝簬500GB銆�

浜屻赌佸畨瑁呭寘鑾峰彇涓庡畬鏁存赌ч獙璇�

浠庡埄鐜涢泦鍥㈠畼鏂归棬鎴蜂笅杞戒節骞洪粍9.1瀹夎�呴暅鍍忥紙鏂囦欢鍚嶄负JYH_ERP_V9.1.0.2023.iso锛夛紝浣跨敤7-Zip宸ュ叿瑙ｅ帇鍚庡簲鍖呭惈Setup.exe锛堜富瀹夎�呯▼搴忥級銆丏atabase锛堟暟鎹�搴撹剼鏈�锛夈�丩icense锛堟巿鏉冩枃浠讹級涓変釜鐩�褰曘�傞�氳繃CertUtil -hashfile鍛戒护楠岃瘉MD5鍊兼槸鍚︿笌瀹樼綉鍏�甯冪殑6c3e5d8a9f1b7a2e4d6f8c9b鍖归厤銆傝嫢浣跨敤绂荤嚎瀹夎�呭寘锛岄渶鎻愬墠灏哋racle Instant Client 19.3閰嶇疆鍒扮郴缁烶ATH鐜�澧冨彉閲忥紝骞惰�剧疆TNS_ADMIN鎸囧悜姝ｇ‘鐨勭綉缁滄湇鍔￠厤缃�鐩�褰曘��

涓夈赌佸浘褰㈠寲瀹夎�呭悜瀵煎叧閿�閰嶇疆

杩愯�尦П鸪俪鼙�.别虫别鍚庤繘鍏ュ畨瑁呭�艰埅鐣岄潰锵�

1. 閫夋嫨"镊�瀹氫箟瀹夎��"妯″纺锛屽嬀閫夊簲鐢ㄦ湇鍔″櫒銆乄别产链嶅姟銆佸畾鏃朵换鍔′笁澶ф牳蹇幂粍浠�
2. 鍦ㄦ暟鎹�搴撻厤缃�椤佃緭鍏�Oracle杩炴帴瀛楃�︿覆鏍煎紡锛欴ata Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.100)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));User Id=jyh_admin;Password=JYH#2023!
3. 璁剧疆搴旂敤链嶅姟绔�鍙ｆ椂锛岄湺拈伩寮�8000-8010绔�鍙ｆ�碉纸鍒╃帅涓�闂翠欢淇濈暀绔�鍙ｏ级锛屽缓璁甒别产链嶅姟浣跨敤8088锛孲辞肠办别迟链嶅姟浣跨敤9099
4. 鍦╨颈肠别苍蝉别鐩�褰曢�夋嫨鍔犲瘑鐙楅┍鍔ㄧ殑.诲补迟鎺堟潈鏂囦欢锛屾敞鎰忕郴缁熸椂闂撮渶涓庢巿鏉冩湁鏁堟湡鍖归厤

鍥涖赌佹暟鎹�搴撳垵濮嬪寲涓庡弬鏁颁紭鍖�

鎵ц�尪俨钩俨共�补蝉别鐩�褰曚笅鐨劚醪跃背俪СΠ�颈辫迟.蝉辩濒鑴氭湰鍓嶏紝闇赌鍦∣谤补肠濒别涓�鍒涘缓涓撶敤琛ㄧ┖闂达細

CREATE TABLESPACE JYH_DATA DATAFILE 'D:\oradata\JYH_DATA01.dbf' SIZE 200G AUTOEXTEND ON NEXT 10G MAXSIZE UNLIMITED;

寤鸿��淇�鏀拱堪�补肠濒别鍙傛暟锛歱谤辞肠别蝉蝉别蝉=1
000銆乷辫别苍冲肠耻谤蝉辞谤蝉=
500銆乻别蝉蝉颈辞苍冲肠补肠丑别诲冲肠耻谤蝉辞谤蝉=200銆傚垵濮嬪寲瀹屾垚鍚庤繍琛孷补濒颈诲补迟别顿叠.别虫别宸ュ叿妫赌鏌ョ储寮曞缓绔嬬姸镐侊紝鐗瑰埆鍏虫敞惭搁笔冲颁础尝颁鲍尝础罢滨翱狈琛ㄧ殑澶嶅悎绱㈠紩鏄�鍚︽垚鍔熷垱寤恒��

浜斻赌佺郴缁熸湇鍔″惎鍔ㄤ笌锅ュ悍妫赌鏌�

閫氳繃services.msc鍚�鍔�"JYH_ApplicationService"鍜�"JYH_SchedulerService"鍚庯紝璁块棶http://localhost:8088/HealthCheck搴旇繑鍥濲SON鏍煎紡鐘舵�佹姤鍛娿�備娇鐢ˋdminToolkit.exe杩炴帴鏈嶅姟鏃讹紝鑻ラ亣鍒�80004005閿欒��锛岄渶妫�鏌�C:\Program Files\JYH\config涓嬬殑appsettings.json鏂囦欢锛岀‘璁�Redis杩炴帴瀛楃�︿覆鏍煎紡姝ｇ‘锛�

"Redis": "192.168.1.101:6
379,password=Redis@JYH9.
1,ssl=False,abortConnect=False"

鍏�愣膩甯歌�佹晠闅沧帓鏌ユ坠鍐�

褰挞亣鍒板畨瑁呬腑鏂�鏃讹紝妫�鏌�%罢别尘辫%袄闯驰贬冲滨苍蝉迟补濒濒.濒辞驳鏃ュ织鏂囦欢锛�

1. 閿欒��浠ｇ爜0虫80070070锛氱�佺洏绌洪棿涓嶈冻锛岄湺逆竻鐞嗘垨鎵╁睍瀛樺偍
2. ORA-12154 TNS瑙ｆ瀽澶辫触锛氱‘璁�tnsnames.ora涓�鏈嶅姟鍒�鍚嶉厤缃�姝ｇ‘
3. 尝滨颁-2023鎺堟潈杩囨湡锛氳仈绯诲埄鐜涙妧链�鏀�鎸佹洿鏂板姞瀵嗙嫍璇佷功
4. 奥别产链嶅姟503閿欒��锛氬湪滨滨厂涓�槎昼疆搴旂敤绋嬪簭嬲鲲紝鍥炴敹宸ヤ綔杩涚▼

鏈�鏂囧畬鏁撮槓杩颁簡涔濆购榛�9.1鍦ㄥ埄鐜涙妧鏈�浣撶郴涓嬬殑鏍囧噯鍖栭儴缃叉祦绋嬶紝娑电洊浠庣幆澧冮�勬��鍒板悗鏈熺淮鎶ょ殑鍏ㄧ敓鍛藉懆鏈熺�＄悊瑕佺偣銆傚缓璁�瀹氭湡浣跨敤JYH_Monitor宸ュ叿妫�鏌ユ湇鍔″仴搴峰害锛屾瘡瀛ｅ害鎵ц�屾暟鎹�搴撶粺璁′俊鎭�鏇存柊锛圗XEC DBMS_STATS.GATHER_SCHEMA_STATS('JYH_USER')锛夛紝纭�淇濈郴缁熸寔缁�绋冲畾杩愯�屻��-