Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
This script "breaks" the port by replacing the original port # with "8DDD" in TNSNAMES.ORA. Replace "8DDD" with the originally assigned port number. U01.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = stc-sun02.world)(PORT = 8DDD)) . | Workshop Scenarios B Workshop Scenarios Network Scenario List Network Workshop Scenarios Scenario 1: Bad port in TNSNAMES.ORA Scenario 2: Incorrect "CONNECT_DATA" punctuation in TNSNAMES.ORA. Scenario 3: PROTOCOL error in TNSNAMES.ORA Scenario 4: SERVICE_NAME error in TNSNAMES.ORA Scenario 5: Incorrect NAMES.DIRECTORY_PATH value in SQLNET.ORA Scenario 6: PORT error in the listener definition in LISTENER.ORA Scenario 7: LISTENER error in SID_LIST in LISTENER.ORA Scenario 8: Listener name error in LISTENER.ORA Net Scenario 1 Scenario 1: “Broken” Port in TNSNAMES.ORA Solution Outline This script "breaks" the port by replacing the original port # with "8DDD" in TNSNAMES.ORA. Replace "8DDD" with the originally assigned port number. U01.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = stc-sun02.world)(PORT = 8DDD)) . Net Scenario 2 Scenario 2: Incorrect “CONNECT_DATA” Punctuation in TNSNAMES.ORA Solution Outline This scenario “breaks” the punctuation in . | Workshop Scenarios B Workshop Scenarios Network Scenario List Network Workshop Scenarios Scenario 1: Bad port in TNSNAMES.ORA Scenario 2: Incorrect "CONNECT_DATA" punctuation in TNSNAMES.ORA. Scenario 3: PROTOCOL error in TNSNAMES.ORA Scenario 4: SERVICE_NAME error in TNSNAMES.ORA Scenario 5: Incorrect NAMES.DIRECTORY_PATH value in SQLNET.ORA Scenario 6: PORT error in the listener definition in LISTENER.ORA Scenario 7: LISTENER error in SID_LIST in LISTENER.ORA Scenario 8: Listener name error in LISTENER.ORA Net Scenario 1 Scenario 1: “Broken” Port in TNSNAMES.ORA Solution Outline This script "breaks" the port by replacing the original port # with "8DDD" in TNSNAMES.ORA. Replace "8DDD" with the originally assigned port number. U01.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = stc-sun02.world)(PORT = 8DDD)) . Net Scenario 2 Scenario 2: Incorrect “CONNECT_DATA” Punctuation in TNSNAMES.ORA Solution Outline This scenario “breaks” the punctuation in TNSNAMES.ORA. It removes the left parenthesis preceding “CONNECT_DATA.” Replace the missing left parenthesis. ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = stc-sun02)(PORT = 1701)) ) CONNECT_DATA = {Replace the left parenthesis: (CONNECT_DATA } (SERVICE_NAME = U01.world) . Net Scenario 3 Scenario 3: PROTOCOL Error in TNSNAMES.ORA Solution Outline This scenario introduces a PROTOCOL error by removing "TCP" in tnsnames.ora. Replace "TCP" in the PROTOCOL parameter definition. U01.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = )(HOST = stc-sun02)(PORT = 1701)) Should be: (PROTOCOL = TCP) . Net Scenario 4 Scenario 4: SERVICE_NAME Error in TNSNAMES.ORA Solution Outline This scenario comments out the SERVICE_NAME line in TNSNAMES.ORA. Uncomment the line. U01.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = )(HOST = stc-sun02)(PORT = 1701)) ) (CONNECT_DATA = # (SERVVICE_NAME = U01.world) . Net Scenario 5 Scenario 5: Incorrect NAMES.DIRECTORY_PATH Value in SQLNET.ORA