Skip to Content
Last modified by Nefedenkova Viktoria on 2021/04/22 18:40
Show last authors
1 ^^Вернуться назад: [[Milesti Mici>>http://xwiki.una.md/bin/view/UNA/MMICI||rel="__blank" target="_blank" title="Milesti Mici"]]^^
2
3 [ 21 апреля 2021 г. 15:24 ] Urmas Tatiana: Buna ziua, la Cantina nu se face exportul de date?
4
5 [[image:3.jpg||height="70%" width="70%"]]
6 [ 22 апреля 2021 г. 09:02 ] Павел УНА Дир: oracle nu este instalat pe acest calculator.... in caz daca server principal nu va fi disponibil cantina sa vande prin sistem nu va fi pisibil... daca des sa intampla asa probleme sau probleme cu viteza sa recomanda de instalat server pentru cantina in baza de oracle xe pe local
7 [[image:4.jpg||height="70%" width="70%"]]
8 [[image:2.jpg||height="70%" width="70%"]]
9 [ 22 апреля 2021 г. 09:03 ] Павел УНА Дир:
10
11 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
12 **cantina =**
13 **~ (DESCRIPTION =**
14 **~ (ADDRESS = (PROTOCOL = TCP)(HOST = SRV-CANTINA)(PORT = 1521))**
15 **~ (CONNECT_DATA =**
16 **~ (SERVER = DEDICATED)**
17 **~ (SERVICE_NAME = XE)**
18 **~ )**
19 **~ )**
20 \\**MILESHTI =**
21 **~ (DESCRIPTION =**
22 **~ (ADDRESS_LIST =**
23 **~ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.224)(PORT = 1521))**
24 **~ )**
25 **~ (CONNECT_DATA =**
26 **~ (SERVICE_NAME = oradb)**
27 **~ )**
28 **~ )**
29 [ 22 апреля 2021 г. 09:04 ] Павел УНА Дир:
30
31 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
32 **C:\Users\tatiana.urmas>tnsping cantina**
33 \\**TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 22-APR-2021 08:58:51**
34 \\**Copyright (c) 1997, 2006, Oracle. All rights reserved.**
35 \\**Fi¦iere de parametri utilizate:**
36 **D:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora**
37 \\\\**A fost utilizat adaptorul TNSNAMES pentru rezolvarea pseudonimului**
38 **Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SRV-CANTINA)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE~)~)~)**
39 **OK (30 msec)**
40
41 [ 22 апреля 2021 г. 09:04 ] Павел УНА Дир:
42
43 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
44 **D:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora**
45 **A fost utilizat adaptorul TNSNAMES pentru rezolvarea pseudonimului**
46 **Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.224)(PORT = 1521~)~)~) (CONNECT_DATA = (SERVICE_NAME = oradb~)~)~)**
47 **OK (30 msec)**
48 [ 22 апреля 2021 г. 09:07 ] Urmas Tatiana: De cind se lucreaza am intimpinat proble ma doar la transfer de date
49
50 [[image:5.jpg||height="70%" width="70%"]]
51
52 [ 22 апреля 2021 г. 09:11 ] Павел УНА Дир:
53
54 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
55 **ymmici_imp_from_cant.imp_from_cant@mileshti.world(user||'.world',DTC,DTPO);**
56
57 [[image:6.jpg||height="70%" width="70%"]]
58
59 [[image:7.jpg||height="70%" width="70%"]]
60
61 [[image:8.jpg]]
62 [ 22 апреля 2021 г. 09:13 ] Павел УНА Дир:
63
64 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
65 **~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~****
66 **Link : "MILESHTI.WORLD"**
67 **Error : ORA-12154: TNS:could not resolve the connect identifier specified**
68 **~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~****
69
70 [[image:9.jpg||height="70%" width="70%"]]
71
72 [[image:10.jpg]]
73 [ 22 апреля 2021 г. 09:20 ] Павел УНА Дир:
74
75 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
76 **DROP DATABASE LINK "MILESHTI.WORLD";**
77 \\**CREATE DATABASE LINK "MILESHTI.WORLD"**
78 **~ CONNECT TO MMICI**
79 **~ IDENTIFIED BY ""**
80 **~ USING 'MILESHTI';**
81
82 [ 22 апреля 2021 г. 09:28 ] Павел УНА Дир:
83
84 (% style="font-size: 14px; font-family: Consolas; background-color:#fbfdff" %)
85 **DROP DATABASE LINK "MILESHTI.WORLD";**
86 \\**CREATE DATABASE LINK "MILESHTI.WORLD"**
87 **~ CONNECT TO MMICI**
88 **~ IDENTIFIED BY "MMICI"**
89 **~ USING '(DESCRIPTION =**
90 **~ (ADDRESS_LIST =**
91 **~ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.224)(PORT = 1521))**
92 **~ )**
93 **~ (CONNECT_DATA =**
94 **~ (SERVICE_NAME = oradb)**
95 **~ )**
96 **~ )';**
97
98 [[image:11.jpg||height="70%" width="70%"]]
99
100 [ 22 апреля 2021 г. 09:29 ] Павел УНА Дир: sa rezolvat verificati
101 [ 22 апреля 2021 г. 09:29 ] Павел УНА Дир: ultim pas de compilat pacjete\\