Simple Installation of DC / ECDA [enterprise connect direct access for oracle]
Author Amol P Ingle
1. Take the IP / port number or install on the same machine who having the ASE
server or make the new machine ready for the DC installation
2. Make the user / permission on machine for DC
3. Install the software
$ ./setupHP11 -console
InstallShield Wizard
Initializing InstallShield Wizard...
Preparing Java(tm) Virtual Machine...
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
.............................
Welcome to the InstallShield Wizard for Sybase Enterprise Connect Data Access
Suite version 12.6.1 GA
The InstallShield Wizard will install Sybase Enterprise Connect Data Access
Suite on your computer.
To continue, choose Next.
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 1
1) Argentina 2) Australia
3) Belgium(English) 4) Belgium(French)
5) Brazil 6) Canada
7) Denmark 8) Europe,Middle East, and Africa - General
9) France(English) 10) France(French)
11) Germany(English) 12) Germany(German)
13) Hong Kong 14) India
15) Italy(English) 16) Italy(Italy)
17) Japan 18) Korea
19) Malaysia 20) Mexico
21) Netherlands 22) New Zealand
23) Norway 24) People's Republic of China(PRC)
25) Philippines 26) Singapore
27) Spain(English) 28) Spain(Spanish)
29) Sweden 30) Switzerland(English)
31) Switzerland(German) 32) Taiwan
33) Thailand 34) United Kingdom
35) United States of America 36) Any Other Locations
Please enter the number of the location you are installing. (1-37) [1] 14
?
LICENSE AGREEMENT
I agree to the terms of the Sybase license for the install location
specified.(Y/N) [N]y
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Please wait...
Please enter the directory where you would like to install the products or
click Next to accept the default. To select a specific directory, click the
"..." (ellipse) button.
Destination Directory [/filesystem name] /filesystem name
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
1. Yes
2. No
You have chosen to install into an existing directory. Any older versions of
the products you choose to install that are detected in this directory will
be
replaced. Do you want to continue with installation into this directory? [2]1
Choose the setup type that best suits your needs.
[X] 1 - Full
The full setup type will be installed with all the products and features
checked.
[ ] 2 - Custom
The program will be installed with the features you choose.
Recommended for advanced users.
To select an item enter its number, or 0 when you are finished: [0] 1
Enter 0 to continue or 1 to make another selection: [0] 0
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Performing install checks. Please wait...
Please wait...
Sybase Enterprise Connect Data Access Suite will be installed in the following
location:
/Filesystem Name
with the following features:
Sybase Enterprise Connect Data Access
ECDA Option for DB2 UDB
ECDA Option for Informix
ECDA Option for Microsoft SQL Server
ECDA Option for ODBC
ECDA Option for Oracle
Connectivity
Open Client
Common ctlib files
Common dblib files
Language Modules
Chinese Language Module
German Language Module
Press ENTER to read the text [Type q to quit]
French Language Module
Japanese Language Module
Spanish Language Module
Polish Language Module
Portuguese Language Module
Korean Language Module
Thai Language Module
Shared
Sybase Software Asset Management
for a total size:
1222.9 MB
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Installing Sybase Enterprise Connect Data Access Suite. Please wait...
0 % complete
10 % complete
20 % complete
30 % complete
40 % complete
50 % complete
60 % complete
70 % complete
80 % complete
90 % complete
100 % complete
Creating uninstaller...
The InstallShield Wizard has successfully installed Sybase Enterprise Connect
Data Access Suite. Choose Next to continue the wizard.
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 1
At this point in the installation you can choose to configure the Enterprise
Connect Data Access Options listed. If you do not choose to configure the
servers at this time, you can configure them using the method outlined in
Enterprise Connect Data Access Installation Guide at a later time.
Configure New Servers
Please deselect any servers that you do not want to configure now :
[X] 1 - Configure new DirectConnect for Oracle Server
To select an item enter its number, or 0 when you are finished [0]: 0
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Please enter custom configuration values for the new DirectConnect for Oracle
Server
DirectConnect for Oracle Name [SYBASE _DCO] 3
Port Number [12600]
DCO Admin Account Name [system]
Oracle Password for DCO Admin Acct:
Confirm Oracle Password for DCO Admin Acct:
Oracle connect string []
Enter path(including filename) to valid tnsnames.ora file []
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 4
Please enter custom configuration values for the new DirectConnect for Oracle
Server
DirectConnect for Oracle Name [3] 2
Port Number [12600]
DCO Admin Account Name [system]
Oracle Password for DCO Admin Acct:
Confirm Oracle Password for DCO Admin Acct:
Oracle connect string []
Enter path(including filename) to valid tnsnames.ora file []
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 3
1. Yes
2. No
Do you want to exit? [2] 1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4. check the ip address port number of DC, ASE,REPSERVER.
DC_Name
master tcp ether 192.168.253.54 9005
query tcp ether 192.168.253.54 9005
Repserver
master tcp ether 192.168.253.54 9000
query tcp ether 192.168.253.54 9000
ASE server
master tcp ether 192.168.253.54 9002
query tcp ether 192.168.253.54 9002
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5. When the installation going that time Sybase ask you to put the config values that
time also you can provide or after completion there is cfg file under /DCO-
12_6/install dir.Make the changes in that.
;;
DirectConnect for Oracle configuration file
;
[DC_BIAPPS]
administrator=system
language =us_english
charset =utf8
errorLog = /opt/sybase_dc/DCO-12_6/install/DC_BIAPPS.log
interfaces =
certificate_file =
certificate_password = password
trusted_roots_file =
max_packetsize = 2048
max_users = 25
maxpagesize = 4096
network_tracing = 0
max_textsize = 32768
text_chunksize = 32768
max_threads = 100
max_stacksize = 100352
srv_traceflags =
traceflags =
connect_string =bi
two_phase_commit = 0
session_time_limit = 60
autocommit = 1
default_precision = 38
default_scale = 0
number_mode = 2
array_size = 50
insert_array_size = 50
date_format = MON DD YYYY HH:MI:SSAM
timestamp_format = MON DD YYYY HH:MI:SSAM
timestamp_tz_format = MON DD YYYY HH:MI:SS.FFAM TZH:TZM
triggers = 0
csp_uppercase = 1
timestamp_ms_support = 0
[languages]
;;
Maps a Sybase language to an Oracle Language, Territory, and Charset
;
us_english american america us7ascii
german german germany we8dec
french french france we8dec
japanese japanese japan ja16euc
[charsets]
;;
Maps a Sybase charset to an Oracle charset.
; The character width and a description must be included on each line.
;
ascii_7 us7ascii 1 US ASCII, for 7-bit data
ascii_8 us7ascii 1 US ASCII, with 8-bit data
big5 zht16big5 2 Chinese PC code
cp1250 ee8mswin1250 1 Microsoft Windows Code Page 1250, Eastern Europe
cp437 us8pc437 1 IBM Code Page 437, U.S.
cp850 we8pc850 1 IBM Code Page 850, West Europe
cp852 ee8pc852 1 IBM Code Page 852, Eastern Europe
cp855 ru8pc855 1 IBM Code Page 855, Bulgaria/Cyrillic
cp857 tr8pc857 1 IBM Code Page 857, Turkish
cp860 we8pc860 1 IBM Code Page 860, Portuguese
cp863 cdn8pc863 1 IBM Code Page 863, Canadian-French
cp865 n8pc865 1 IBM Code Page 865, Nordic
cp866 ru8pc866 1 Microsoft Code Page 866, Cyrillic
deckanji ja16vms 2 DEC-Kanji, DEC/VMS rendition of EUC
euccns ja16euc 2 EUC CNS-11643-86 Chinese Traditional
eucgb ja16euc 2 EUC GB 2312-80 PRC Standard
eucjis ja16euc 2 EUC-JIS (ASCII, JIS-x0201, JIS-x0208) Extended Unix Code
for Japanese
eucksc ja16euc 2 EUC KS C 5601-1987 Korean
iso88592 ee8iso8859p2 1 ISO_8859-2:1987, Eastern Europe
iso88593 se8iso8859p3 1 ISO_8859-3:1988, South Europe
iso88594 nee8iso8859p4 1 ISO_8859-4:1988, North/Northeast Europe
iso88595 cl8iso8859p5 1 ISO_8859-5:1988, Cyrillic
iso88596 ar8iso8859p6 1 ISO_8859-6:1987, Arabic, ASMO-708
iso88597 el8iso8859p7 1 ISO_8859-7:1987, Greek, ELOT_928
iso88598 iw8iso8859p8 1 ISO_8859-8:1988, Hebrew
iso88599 we8iso8859p9 1 ISO_8859-9:1989, Latin5, Turkish
iso_1 we8iso8859p1 1 ISO_8859-1:1987, Latin1
kscpack ko16ksc5601 2 KS C 5601 packed code
mac we8macroman8 1 MacIntosh default set
mac_cyr cl8maccyrillic 1 Macintosh Cyrillic
roman8 we8roman8 1 HP Western European
sjis ja16sjis 2 IBM Code Page 932, Shift-JIS
tis620 th8tisascii 1 Thailand Industrial Standard - ASCII
utf8 utf8 2 ISO 10646-1, UTF-8 multibyte encoding
Note : Please the connect string name in cfg file. [ Connect string name is the service
which you are using from the oracle service ]
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
6. Set the environment variable.
7. Then put the tnsnames.ora (ora file of oracle) in /DCO-12_6/network/
tnsnames.ora
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
8. Then go to /DCO-12_6/install and run the below run server file.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9. startserver -f RUN_DCORA126
*** If you have done your setup and Run server file is not be seen in Install dir
then create the run server file.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
10. Then go to ASE server
1> sp_addserver DC_BIAPPS,direct_connect,DC_BIAPPS
2> go
Adding server 'DC_BIAPPS', physical name 'DC_BIAPPS'
Server added.
(return status = 0)
1> select * from sysserver
2> go
Msg 208, Level 16, State 1:
Server 'ASE_BIAPPS', Line 1:
sysserver not found. Specify owner.objectname or use sp_help to check whether
the object exists (sp_help may produce lots of output).
1> select * from sysservers
2> go
srvid srvstatus srvname
srvnetname srvclass
srvsecmech srvcost
------ --------- ------------------------------
-------------------------------- --------
------------------------------ -------
0 9 ASE_BIAPPS
ASE_BIAPPS 0
NULL 0
1 8 SYB_BACKUP
ASE_BIAPPS_BS NULL
NULL NULL
2 9 DC_BIAPPS
DC_BIAPPS 3
NULL 1000
(3 rows affected)
1> $ isql -Usystem -Psystem123 -SDC_BIAPPS
1>
* All copy rights are @ Amol Inc.
Author Amol P Ingle
1. Take the IP / port number or install on the same machine who having the ASE
server or make the new machine ready for the DC installation
2. Make the user / permission on machine for DC
3. Install the software
$ ./setupHP11 -console
InstallShield Wizard
Initializing InstallShield Wizard...
Preparing Java(tm) Virtual Machine...
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
...................................
.............................
Welcome to the InstallShield Wizard for Sybase Enterprise Connect Data Access
Suite version 12.6.1 GA
The InstallShield Wizard will install Sybase Enterprise Connect Data Access
Suite on your computer.
To continue, choose Next.
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 1
1) Argentina 2) Australia
3) Belgium(English) 4) Belgium(French)
5) Brazil 6) Canada
7) Denmark 8) Europe,Middle East, and Africa - General
9) France(English) 10) France(French)
11) Germany(English) 12) Germany(German)
13) Hong Kong 14) India
15) Italy(English) 16) Italy(Italy)
17) Japan 18) Korea
19) Malaysia 20) Mexico
21) Netherlands 22) New Zealand
23) Norway 24) People's Republic of China(PRC)
25) Philippines 26) Singapore
27) Spain(English) 28) Spain(Spanish)
29) Sweden 30) Switzerland(English)
31) Switzerland(German) 32) Taiwan
33) Thailand 34) United Kingdom
35) United States of America 36) Any Other Locations
Please enter the number of the location you are installing. (1-37) [1] 14
?
LICENSE AGREEMENT
I agree to the terms of the Sybase license for the install location
specified.(Y/N) [N]y
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Please wait...
Please enter the directory where you would like to install the products or
click Next to accept the default. To select a specific directory, click the
"..." (ellipse) button.
Destination Directory [/filesystem name] /filesystem name
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
1. Yes
2. No
You have chosen to install into an existing directory. Any older versions of
the products you choose to install that are detected in this directory will
be
replaced. Do you want to continue with installation into this directory? [2]1
Choose the setup type that best suits your needs.
[X] 1 - Full
The full setup type will be installed with all the products and features
checked.
[ ] 2 - Custom
The program will be installed with the features you choose.
Recommended for advanced users.
To select an item enter its number, or 0 when you are finished: [0] 1
Enter 0 to continue or 1 to make another selection: [0] 0
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Performing install checks. Please wait...
Please wait...
Sybase Enterprise Connect Data Access Suite will be installed in the following
location:
/Filesystem Name
with the following features:
Sybase Enterprise Connect Data Access
ECDA Option for DB2 UDB
ECDA Option for Informix
ECDA Option for Microsoft SQL Server
ECDA Option for ODBC
ECDA Option for Oracle
Connectivity
Open Client
Common ctlib files
Common dblib files
Language Modules
Chinese Language Module
German Language Module
Press ENTER to read the text [Type q to quit]
French Language Module
Japanese Language Module
Spanish Language Module
Polish Language Module
Portuguese Language Module
Korean Language Module
Thai Language Module
Shared
Sybase Software Asset Management
for a total size:
1222.9 MB
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Installing Sybase Enterprise Connect Data Access Suite. Please wait...
0 % complete
10 % complete
20 % complete
30 % complete
40 % complete
50 % complete
60 % complete
70 % complete
80 % complete
90 % complete
100 % complete
Creating uninstaller...
The InstallShield Wizard has successfully installed Sybase Enterprise Connect
Data Access Suite. Choose Next to continue the wizard.
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1] 1
At this point in the installation you can choose to configure the Enterprise
Connect Data Access Options listed. If you do not choose to configure the
servers at this time, you can configure them using the method outlined in
Enterprise Connect Data Access Installation Guide at a later time.
Configure New Servers
Please deselect any servers that you do not want to configure now :
[X] 1 - Configure new DirectConnect for Oracle Server
To select an item enter its number, or 0 when you are finished [0]: 0
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 1
Please enter custom configuration values for the new DirectConnect for Oracle
Server
DirectConnect for Oracle Name [SYBASE _DCO] 3
Port Number [12600]
DCO Admin Account Name [system]
Oracle Password for DCO Admin Acct:
Confirm Oracle Password for DCO Admin Acct:
Oracle connect string []
Enter path(including filename) to valid tnsnames.ora file []
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 4
Please enter custom configuration values for the new DirectConnect for Oracle
Server
DirectConnect for Oracle Name [3] 2
Port Number [12600]
DCO Admin Account Name [system]
Oracle Password for DCO Admin Acct:
Confirm Oracle Password for DCO Admin Acct:
Oracle connect string []
Enter path(including filename) to valid tnsnames.ora file []
Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1] 3
1. Yes
2. No
Do you want to exit? [2] 1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4. check the ip address port number of DC, ASE,REPSERVER.
DC_Name
master tcp ether 192.168.253.54 9005
query tcp ether 192.168.253.54 9005
Repserver
master tcp ether 192.168.253.54 9000
query tcp ether 192.168.253.54 9000
ASE server
master tcp ether 192.168.253.54 9002
query tcp ether 192.168.253.54 9002
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5. When the installation going that time Sybase ask you to put the config values that
time also you can provide or after completion there is cfg file under /DCO-
12_6/install dir.Make the changes in that.
;;
DirectConnect for Oracle configuration file
;
[DC_BIAPPS]
administrator=system
language =us_english
charset =utf8
errorLog = /opt/sybase_dc/DCO-12_6/install/DC_BIAPPS.log
interfaces =
certificate_file =
certificate_password = password
trusted_roots_file =
max_packetsize = 2048
max_users = 25
maxpagesize = 4096
network_tracing = 0
max_textsize = 32768
text_chunksize = 32768
max_threads = 100
max_stacksize = 100352
srv_traceflags =
traceflags =
connect_string =bi
two_phase_commit = 0
session_time_limit = 60
autocommit = 1
default_precision = 38
default_scale = 0
number_mode = 2
array_size = 50
insert_array_size = 50
date_format = MON DD YYYY HH:MI:SSAM
timestamp_format = MON DD YYYY HH:MI:SSAM
timestamp_tz_format = MON DD YYYY HH:MI:SS.FFAM TZH:TZM
triggers = 0
csp_uppercase = 1
timestamp_ms_support = 0
[languages]
;;
Maps a Sybase language to an Oracle Language, Territory, and Charset
;
us_english american america us7ascii
german german germany we8dec
french french france we8dec
japanese japanese japan ja16euc
[charsets]
;;
Maps a Sybase charset to an Oracle charset.
; The character width and a description must be included on each line.
;
ascii_7 us7ascii 1 US ASCII, for 7-bit data
ascii_8 us7ascii 1 US ASCII, with 8-bit data
big5 zht16big5 2 Chinese PC code
cp1250 ee8mswin1250 1 Microsoft Windows Code Page 1250, Eastern Europe
cp437 us8pc437 1 IBM Code Page 437, U.S.
cp850 we8pc850 1 IBM Code Page 850, West Europe
cp852 ee8pc852 1 IBM Code Page 852, Eastern Europe
cp855 ru8pc855 1 IBM Code Page 855, Bulgaria/Cyrillic
cp857 tr8pc857 1 IBM Code Page 857, Turkish
cp860 we8pc860 1 IBM Code Page 860, Portuguese
cp863 cdn8pc863 1 IBM Code Page 863, Canadian-French
cp865 n8pc865 1 IBM Code Page 865, Nordic
cp866 ru8pc866 1 Microsoft Code Page 866, Cyrillic
deckanji ja16vms 2 DEC-Kanji, DEC/VMS rendition of EUC
euccns ja16euc 2 EUC CNS-11643-86 Chinese Traditional
eucgb ja16euc 2 EUC GB 2312-80 PRC Standard
eucjis ja16euc 2 EUC-JIS (ASCII, JIS-x0201, JIS-x0208) Extended Unix Code
for Japanese
eucksc ja16euc 2 EUC KS C 5601-1987 Korean
iso88592 ee8iso8859p2 1 ISO_8859-2:1987, Eastern Europe
iso88593 se8iso8859p3 1 ISO_8859-3:1988, South Europe
iso88594 nee8iso8859p4 1 ISO_8859-4:1988, North/Northeast Europe
iso88595 cl8iso8859p5 1 ISO_8859-5:1988, Cyrillic
iso88596 ar8iso8859p6 1 ISO_8859-6:1987, Arabic, ASMO-708
iso88597 el8iso8859p7 1 ISO_8859-7:1987, Greek, ELOT_928
iso88598 iw8iso8859p8 1 ISO_8859-8:1988, Hebrew
iso88599 we8iso8859p9 1 ISO_8859-9:1989, Latin5, Turkish
iso_1 we8iso8859p1 1 ISO_8859-1:1987, Latin1
kscpack ko16ksc5601 2 KS C 5601 packed code
mac we8macroman8 1 MacIntosh default set
mac_cyr cl8maccyrillic 1 Macintosh Cyrillic
roman8 we8roman8 1 HP Western European
sjis ja16sjis 2 IBM Code Page 932, Shift-JIS
tis620 th8tisascii 1 Thailand Industrial Standard - ASCII
utf8 utf8 2 ISO 10646-1, UTF-8 multibyte encoding
Note : Please the connect string name in cfg file. [ Connect string name is the service
which you are using from the oracle service ]
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
6. Set the environment variable.
7. Then put the tnsnames.ora (ora file of oracle) in /DCO-12_6/network/
tnsnames.ora
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
8. Then go to /DCO-12_6/install and run the below run server file.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
9. startserver -f RUN_DCORA126
*** If you have done your setup and Run server file is not be seen in Install dir
then create the run server file.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
10. Then go to ASE server
1> sp_addserver DC_BIAPPS,direct_connect,DC_BIAPPS
2> go
Adding server 'DC_BIAPPS', physical name 'DC_BIAPPS'
Server added.
(return status = 0)
1> select * from sysserver
2> go
Msg 208, Level 16, State 1:
Server 'ASE_BIAPPS', Line 1:
sysserver not found. Specify owner.objectname or use sp_help to check whether
the object exists (sp_help may produce lots of output).
1> select * from sysservers
2> go
srvid srvstatus srvname
srvnetname srvclass
srvsecmech srvcost
------ --------- ------------------------------
-------------------------------- --------
------------------------------ -------
0 9 ASE_BIAPPS
ASE_BIAPPS 0
NULL 0
1 8 SYB_BACKUP
ASE_BIAPPS_BS NULL
NULL NULL
2 9 DC_BIAPPS
DC_BIAPPS 3
NULL 1000
(3 rows affected)
1> $ isql -Usystem -Psystem123 -SDC_BIAPPS
1>
* All copy rights are @ Amol Inc.
Comments
Post a Comment