Sybase ASE 15.7 Installation Guide For AIX

最新推荐文章于 2022-07-16 16:48:41 发布

weixin_33958366

最新推荐文章于 2022-07-16 16:48:41 发布

阅读量277

点赞数

文章标签：数据库网络 php

本文链接：https://blog.csdn.net/weixin_33958366/article/details/85070979

版权

This article only show you how to install sybase ASE on AIX.After fewer days i'll write more articles about sybase ASE daily management.If you want to download Sybase ASE software or patch,you must register a account on sybase website.

1.Download Sybase ASE 15.7 from http://downloads.sybase.com/.

2.Create Sybase user and group

#mkgroup sybase
#mkuser pgrp=sybase groups=sybase home=/sybase sybase
#echo sybase:sybase|chpasswd;pwdadm -c sybase
#chown -R sybase.sybase /sybase

3.Running setup.bin to install

#cd /u01/tmp
# gunzip -S .tgz ase157_aix64.tgz|tar xf -
#su – sybase
$cd /u01/tmp
$ ./setup.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
.......................
Preparing CONSOLE Mode Installation...
===============================================================================
Choose Install Folder
---------------------
Where would you like to install?
Default Install Folder: /sybase
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
:
===============================================================================
Choose Install Set
------------------
Please choose the Install Set to be installed by this installer.
->1- Typical
2- Full
3- Customize...
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: 2
===============================================================================
Software License Type Selection
-------------------------------
What would you like to do?
->1- Install licensed copy of Sybase Adaptive Server Enterprise Suite
2- Install Free Developer Edition of Sybase Adaptive Server Enterprise Suite
Enter one of the options above: 1
..........
I agree to the terms of the Sybase license for the install location specified. (Y/N): y
===============================================================================
Sybase Software Asset Management License
----------------------------------------
Enter the Sybase Adaptive Server Enterprise Suite license key(s) or specify the
license server where license key(s) were previously deployed.
->1- Specify license keys
2- Use previously deployed license server
3- Continue installation without a license key
Enter one of the options above: 3
===============================================================================
Product Licenses
----------------
Please select the product edition and license type you would like to configure.
Product Edition
1- Enterprise Edition
2- Small Business Edition
->3- Developer Edition
4- Unknown
Enter one of the options above: 1
License Type
1- CP : CPU License
2- SF : Standby CPU License
->3- SR : Server License
4- SV : Standby Server License
5- DT : Development and Test License
6- EV : Evaluation License
7- OT : Other License
8- SS : Standalone Seat License
9- DV : Developer License
10- NA : Not Applicable or Other License
11- AC : OEM Application Deployment CPU License
12- BC : OEM Application Deployment Standby CPU License
13- AR : OEM Application Deployment Server License
14- BR : OEM Application Deployment Standby Server License
15- AO : OEM Application Deployment Other License
16- LP : Application Specific CPU License
17- LF : Application Specific Standby CPU License
18- LR : Application Specific Server License
19- LV : Application Specific Standby Server License
20- Unknown
Enter one of the options above: 6
===============================================================================
Sybase Software Asset Management Notification
---------------------------------------------
Please configure the Sybase Software Asset Management (SySAM) email alert
mechanism. When configured, specified recipients will receive email
notifications about SySAM events that may need administrator attention.
Do you want to configure email alerts? (Y/N): n
===============================================================================
Pre-Installation Summary
------------------------
Please Review the Following Before Continuing:
Product Name:
Sybase Adaptive Server Enterprise Suite
Install Folder:
/sybase
Product Features:
Adaptive Server Enterprise,
Additional ASE Language Modules,
Open Client,
DB-Library,
Embedded SQL/C,
Embedded SQL/Cobol,
XA Interface Library for ASE Distributed Transaction Manager,
ASE ODBC Driver,
Additional Connectivity Language Modules,
jConnect 7.0 for JDBC,
Interactive SQL,
QPTune,
SySAM License Utilities,
Remote Command and Control Agent for Adaptive Server,
SNMP Support for Adaptive Server,
SySAM License Server,
ASE Extension Module for Python,
ASE Extension Module for PHP,
Sybase Control Center
Disk Space Information (for Installation Target):
Required: 2,442,965,284 bytes
Available: 21,402,374,144 bytes
PRESS <ENTER> TO CONTINUE:
===============================================================================
Ready To Install
----------------
InstallAnywhere is now ready to install Sybase Adaptive Server Enterprise Suite
onto your system at the following location:
/sybase
PRESS <ENTER> TO INSTALL:
===============================================================================
Installing...
-------------
[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]
===============================================================================
Configure New Servers
---------------------
The Sybase Adaptive Server Enterprise Suite includes products that require
configuration. If you choose to configure the products on this screen, you
will be given the option to specify custom values for each product. If you
choose not to configure the products now, you can configure them later.
Please deselect any products that you do not want to configure now :
[X] 1 - Configure new Adaptive Server
[X] 2 - Configure new Backup Server
[X] 3 - Configure new XP Server
[X] 4 - Configure new Job Scheduler
[X] 5 - Enable Self Management
[X] 6 - Configure Sybase Control Center
To select an item enter its number, or 0 when you are finished: (DEFAULT: 0)
:
===============================================================================
Configure New Adaptive Server
-----------------------------
Adaptive Server Name (DEFAULT: H144129):
System Administrator's Password:
Confirm System Administrator's Password:
Port Number (DEFAULT: 5000):
Error Log (DEFAULT: /sybase/ASE-15_0/install/H144129.log):
Application Type
->1- Mixed (OLTP/DSS)
2- Online Transaction Proccessing (OLTP)
3- Decision Support Systems (DSS)
Select an application type:
Page Size
1- 2k
->2- 4k
3- 8k
4- 16k
Select a page size: 2
Warning: You have selected 4k as the logical page size for the
Adaptive Server. If you plan to load dump from another database,
make sure this logical page size matches the size of the source
database. The default logical page size in previous Adaptive Server
versions was 2KB.
PRESS <ENTER> TO CONTINUE:
1- chinese
2- french
3- german
4- japanese
5- korean
6- polish
7- portuguese
8- spanish
9- thai
->10- us_english
Default Language:
1- cp437 : Code Page 437, (United States) character set.
2- cp850 : Code Page 850 (Multilingual) character set.
3- iso15 : ISO_8859-15:1998, Latin9, Western Europe
->4- iso_1 : ISO 8859-1 (Latin-1) - Western European 8-bit character set.
5- mac : Macintosh default character set for Western European locales.
6- roman8 : Hewlett-Packard proprietary character set for European locales.
7- roman9 : Hewlett-Packard proprietary character set for European locales.
8- utf8 : Unicode 3.1 UTF-8 Character Set
Default Character Set:
->1- bin_iso_1 : Binary ordering, for the ISO 8859/1 or Latin-1 character set (iso_1).
2- dictionary_iso_1 : General purpose dictionary ordering.
3- espdict_iso_1 : Spanish dictionary ordering.
4- espnoaccents_iso_1 : Spanish case and accent insensitive dictionary order.
5- espnocase_iso_1 : Spanish case insensitive dictionary order.
6- noaccents_iso_1 : Dictionary order, case insensitive, accent insensitive.
7- nocase_iso_1 : Dictionary order, case insensitive.
8- nocasepref_iso_1 : Dictionary order, case insensitive with preference.
Default Sort Order:
Optimize ASE Configuration
->1- No
2- Yes
Do you want to optimize ASE configuration?:
Create sample databases
->1- No
2- Yes
Do you want to create sample databases?:
Master Device (DEFAULT: /sybase/data/master.dat):
Master Device Size (MB) (DEFAULT: 60):
Master Database Size (MB) (DEFAULT: 26):
System Procedure Device (DEFAULT: /sybase/data/sysprocs.dat):
System Procedure Device Size (MB) (DEFAULT: 172):
System Procedure Database Size (MB) (DEFAULT: 172):
System Device (DEFAULT: /sybase/data/sybsysdb.dat):
System Device Size (MB) (DEFAULT: 6):
System Database Size (MB) (DEFAULT: 6):
Tempdb Device (DEFAULT: /sybase/data/tempdbdev.dat):
Tempdb Device Size (MB) (DEFAULT: 100):
Tempdb Database Size (MB) (DEFAULT: 100):
Enable PCI
->1- No
2- Yes
Do you want to configure PCI/JAVA?:
===============================================================================
Configure New Backup Server
---------------------------
Backup Server Name (DEFAULT: H144129_BS):
Port Number (DEFAULT: 5001):
Error Log (DEFAULT: /sybase/ASE-15_0/install/H144129_BS.log):
===============================================================================
Configure New XP Server
-----------------------
Port Number (DEFAULT: 5002):
Error Log (DEFAULT: /sybase/ASE-15_0/install/H144129_XP.log):
===============================================================================
Configure New Job Scheduler
---------------------------
js_server_name (DEFAULT: H144129_JSAGENT):
Port Number (DEFAULT: 4900):
Management Device (DEFAULT: /sybase/data/sybmgmtdb.dat):
Management Device Size (MB) (DEFAULT: 75):
Management Database Size (MB) (DEFAULT: 75):
===============================================================================
Configure Self Management
-------------------------
Self Management User Name (DEFAULT: sa):
===============================================================================
Sybase Control Center - Configure Self Discovery Service Adaptor
----------------------------------------------------------------
Discovery Services provide client applications the ability to find Sybase
resources within an enterprise environment without the need for local interface
file definitions. Sybase Control Center currently supports two discovery
methods: JINI and UDP.
JINI requires a dedicated JINI server to provide discovery services and can
provide these services throughout the enterprise. UDP does not require a
dedicated server but is limited to discovery within the local subnet.
Do you want to configure UDP Adaptor? (Y/N): Y
Do you want to configure JINI Adaptor? (Y/N): N
===============================================================================
Sybase Control Center - Configure RMI Port
------------------------------------------
The RMI service needs to use a port that is not used by other applications or
services on this system. Accept the default port or specify an unused port.
RMI Port: [integer (1025-65535)] (DEFAULT: 9999):
===============================================================================
Sybase Control Center - Security Login Modules
----------------------------------------------
Enter password for following Sybase Control Center user(s).
SCC administrator password:
Confirm SCC administrator password:
SCC agent administrator password:
Confirm SCC agent administrator password:
===============================================================================
New Server Configuration Summary
--------------------------------
Adaptive Server
Adaptive Server Name H144129
Port Number 5000
Application Type Mixed (OLTP/DSS)
Create sample databases false
Page Size 4k
Error Log /sybase/ASE-15_0/install/H144129.log
Master Device /sybase/data/master.dat
Master Device Size (MB) 60
Master Database Size (MB) 26
System Procedure Device /sybase/data/sysprocs.dat
System Procedure Device Size (MB) 172
System Procedure Database Size (MB) 172
System Device /sybase/data/sybsysdb.dat
System Device Size (MB) 6
System Database Size (MB) 6
Tempdb Device /sybase/data/tempdbdev.dat
Tempdb Device Size (MB) 100
Tempdb Database Size (MB) 100
Default Language <use default>
Default Character Set <use default>
Default Sort Order <use default>
Backup Server
Backup Server Name H144129_BS
Port Number 5001
Error Log /sybase/ASE-15_0/install/H144129_BS.log
XP Server
XP Server Name H144129_XP
Port Number 5002
Error Log /sybase/ASE-15_0/install/H144129_XP.log
Job Scheduler
Job Scheduler Agent Name H144129_JSAGENT
Port Number 4900
Management Device /sybase/data/sybmgmtdb.dat
Management Device Size (MB) 75
Management Database Size (MB) 75
Self Management
Self Management User Name sa
Self Management User Password ******
Sybase Control Center - Configure Self Discovery Service Adaptor
adaptor UDP
Sybase Control Center - Configure RMI Port
RMI Port 9999
Sybase Control Center - Security Login Modules
SCC administrator password ******
SCC agent administrator password ******
Do you want to continue? (DEFAULT: yes):
===============================================================================
Configure New Adaptive Server
-----------------------------
Warning: You have selected '4k' as the logical page size for the Adaptive
Server. If you plan to load dump from another database, make sure this logical
page size matches the size of the source database. The default logical page
size in previous Adaptive Server versions was 2KB.
Port number '5000' is being reserved or currently in use by a running server.
Building Adaptive Server 'H144129':
Writing entry into directory services...
Directory services entry complete.
Building master device...
Master device complete.
Writing RUN_H144129 file...
RUN_H144129 file complete.
Starting server...
Server started.
Set SA password...
SA password is set.
Building sysprocs device and sybsystemprocs database...
sysprocs device and sybsystemprocs database created.
Running installmaster script to install system stored procedures...
installmaster: 10% complete.
installmaster: 20% complete.
installmaster: 30% complete.
installmaster: 40% complete.
installmaster: 50% complete.
installmaster: 60% complete.
installmaster: 70% complete.
installmaster: 80% complete.
installmaster: 90% complete.
installmaster: 100% complete.
installmaster script complete.
Creating two-phase commit database...
Two phase commit database complete.
Extending tempdb database ...
Extending tempdb database complete.
Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,
Macintosh and HP Roman-8)...
Character sets installed.
Setting server name in Adaptive Server...
Server name added.
Setting optimization goal...
Setting optimization goal complete.
Server 'H144129' was successfully created.
===============================================================================
Configure New Backup Server
---------------------------
Port number '5001' is being reserved or currently in use by a running server.
Building Backup Server 'H144129_BS':
Writing entry into directory services...
Directory services entry complete.
Writing RUN_H144129_BS file...
RUN_H144129_BS file complete.
Starting server...
Server started.
Server 'H144129_BS' was successfully created.
===============================================================================
Configure New XP Server
-----------------------
Port number '5002' is being reserved or currently in use by a running server.
Building XP Server 'H144129_XP':
Writing entry into directory services...
Directory services entry complete.
Setting server name in Adaptive Server...
Server name added.
Server 'H144129_XP' was successfully created.
'H144129_XP' will be started when needed by the Adaptive Server.
===============================================================================
Configure New Job Scheduler
---------------------------
Building Job Scheduler 'H144129_JSAGENT':
Writing entry into directory services...
Directory services entry complete.
Installing required script(s) in related Adaptive Server...
installjsdb: 10% complete.
installjsdb: 20% complete.
installjsdb: 30% complete.
.....................
Setting server name in Adaptive Server...
Server name added.
Enabling Adaptive Server optional feature...
Adaptive Server optional feature enabled.
Creating Self Management login/user...
Self Management login/user created.
Creating update statistics job...
jst_default_autoupdtstats: 10% complete.
jst_default_autoupdtstats: 20% complete.
jst_default_autoupdtstats: 100% complete.
Update statistics job created.
Server 'H144129_JSAGENT' was successfully created.
===============================================================================
Installation Completed
----------------------
The installation was successful.
Please check regularly for updates at http://www.sybase.com/downloads.
If you have not done so, please go to https://sybase.subscribenet.com to obtain
the Sybase software licenses.
PRESS <ENTER> TO EXIT THE INSTALLER:

4.Check ASE server status

$cd /sybase/ASE-15_0/install
$ ./showserver
USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND
sybase 6881448 2.3 1.0 52004 90612 pts/0 A 15:05:19 1:43 /sybase/ASE-15_0/bin/dataserver -sH144129 -d/sybase/data/master.dat -e/sybase/ASE-15_0/install/H144129.log -c/sybase/ASE-15_0/H144129.cfg -M/sybase/ASE-15_0
sybase 23986304 0.0 0.0 6200 7728 pts/0 A 15:05:38 0:00 /sybase/ASE-15_0/bin/backupserver -e/sybase/ASE-15_0/install/H144129_BS.log -N25 -C20 -M/sybase/ASE-15_0/bin/sybmultbuf -SH144129_BS

5.Check database information

$ isql -Usa -p -SH144129
Password:
1> sp_helpdb
2> go
name db_size owner dbid created durability lobcomplvl
inrowlen
status
-------------- ------------- ----- ----- ------------ ----------- ----------
--------
-----------------------------------------------------------------------------------------
master 26.0 MB sa 1 Aug 15, 2012 full 0
NULL
mixed log and data
model 6.0 MB sa 3 Aug 15, 2012 full 0
NULL
mixed log and data
sybmgmtdb 75.0 MB sa 31515 Aug 15, 2012 full 0
NULL
select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
sybsystemdb 12.0 MB sa 31513 Aug 15, 2012 full 0
NULL
mixed log and data
sybsystemprocs 172.0 MB sa 31514 Aug 15, 2012 full 0
NULL
trunc log on chkpt, mixed log and data
tempdb 106.0 MB sa 2 Aug 15, 2012 no_recovery 0
NULL
select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data, a
llow wide dol rows
(1 row affected)
(return status = 0)
Execution Time (ms.): 350 Clock Time (ms.): 350
1>

weixin_33958366

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
Sybase ASE 15.7 Installation Guide For AIX

This article only show you how to install sybase ASE on AIX.After fewer days i'll write more articles about sybase ASE daily management.If you want to download Sybase ASE software or patch,you must...
复制链接

扫一扫