Oracle 和 Sybase ASE 數據庫關閉后的啟動

1. Oracle

1.1 啟動

使用 SQLPlus 啟動

sqlplus / as sysdba

# 進入之后執行
SQL> STARTUP;

# 確認數據庫狀態
SQL> SELECT instance_name, status FROM v$instance;
-- 或
SQL> SELECT name, open_mode FROM v$database;

日志如下：

[oracle@datacheck-2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Tue Jul 8 11:00:48 2025
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


STARTUP;
Connected to an idle instance.

SQL> SQL> 

ORACLE instance started.

Total System Global Area 2466248496 bytes
Fixed Size                  9688880 bytes
Variable Size             637534208 bytes
Database Buffers         1811939328 bytes
Redo Buffers                7086080 bytes
Database mounted.
Database opened.
SQL> SQL> SQL> 
SQL> Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

使用 Oracle Restart 或服務啟動（適用于 XE、RAC、或 Restart）

# systemctl 啟動服務
sudo systemctl start oracle-xe-21c

# Oracle Restart / Grid Infrastructure
srvctl start database -db <yourDB>

1.2 啟動監聽器

查看監聽器有沒有被啟動：

ps -ef | grep tnslsnr
lsnrctl status

如果顯示未運行或沒有進程：

lsnrctl start

日志如下：

[oracle@datacheck-2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 08-JUL-2025 11:05:03

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=datacheck-2)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@datacheck-2 ~]$ lsnrctl start

LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 08-JUL-2025 11:05:09

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Starting /opt/oracle/product/21c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 21.0.0.0.0 - Production
System parameter file is /opt/oracle/homes/OraDBHome21cEE/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/datacheck-2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=datacheck-2.novalocal)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=datacheck-2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 21.0.0.0.0 - ProductionStart Date                08-JUL-2025 11:05:15
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/homes/OraDBHome21cEE/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/datacheck-2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=datacheck-2.novalocal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@datacheck-2 ~]$ ps -ef | grep tnslsnr
oracle   18973     1  0 11:05 ?        00:00:00 /opt/oracle/product/21c/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle   18986 18274  0 11:05 pts/0    00:00:00 grep --color=auto tnslsnr
[oracle@datacheck-2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 08-JUL-2025 11:05:28

Copyright (c) 1991, 2021, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=datacheck-2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 21.0.0.0.0 - ProductionStart Date                08-JUL-2025 11:05:15
Uptime                    0 days 0 hr. 0 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/homes/OraDBHome21cEE/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/datacheck-2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=datacheck-2.novalocal)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

2. Sybase

2.1 啟動

進去 sybase 安裝之后的路徑，然后進入 ASE 安裝目錄的 install 子目錄：

[root@datacheck-3 ~]$ su sybase
[sybase@datacheck-3 ~]$ echo $SYBASE
/opt/sybase
[sybase@datacheck-3 ~]$ cd /opt/sybase/ASE-15_0/install

[sybase@datacheck-3 install]$ ll
total 13472
-rwxr-xr-x 1 sybase sybase  2377917 Jul 30  2019 auditinit
-rwxr-xr-x 1 sybase sybase 11174776 Jul 30  2019 auditinit.sym
-rwxr-xr-x 1 sybase sybase      541 Jul  3 10:00 RUN_sybase
-rwxr-xr-x 1 sybase sybase     4192 Mar 20  2019 setperm_all
-rwxr-xr-x 1 sybase sybase      825 Aug 14  2019 showserver
-rw-r--r-- 1 sybase sybase     1773 Jul  3 09:57 sqlsrv.res
-rwxr-xr-x 1 sybase sybase    15722 Aug 14  2019 startserver
-rw-r----- 1 sybase sybase   139669 Jul  8 11:44 sybase.log
-rwxr-xr-x 1 sybase sybase     1715 Aug 14  2019 sybhauser
drwxrwxr-x 3 sybase sybase       19 Jul  2 17:19 veritas

啟動數據庫。

./startserver -f RUN_<SID>        # 啟主服務
./startserver -f RUN_<SID>_BS     # 啟備份服務（可選）

./startserver -f RUN_sybase

驗證服務狀態

showserver

如果文件權限不對，請先修改文件權限。

chmod 755 RUN_sybase
chown sybase:sybase RUN_sybase

啟動前確認環境已經加載。

source $SYBASE/SYBASE.sh

操作日志：

[sybase@datacheck-3 install]$ ll
total 13392
-rwxr-xr-x 1 sybase sybase  2377917 Jul 30  2019 auditinit
-rwxr-xr-x 1 sybase sybase 11174776 Jul 30  2019 auditinit.sym
-rwx------ 1 root   root        541 Jul  3 10:00 RUN_sybase
-rwxr-xr-x 1 sybase sybase     4192 Mar 20  2019 setperm_all
-rwxr-xr-x 1 sybase sybase      825 Aug 14  2019 showserver
-rw-r--r-- 1 root   root       1773 Jul  3 09:57 sqlsrv.res
-rwxr-xr-x 1 sybase sybase    15722 Aug 14  2019 startserver
-rw-r----- 1 root   root     113083 Jul  5 00:24 sybase.log
-rwxr-xr-x 1 sybase sybase     1715 Aug 14  2019 sybhauser
drwxrwxr-x 3 sybase sybase       19 Jul  2 17:19 veritas
[sybase@datacheck-3 install]$ ./startserver -f RUN_sybase 
Cannot execute file RUN_sybase
[sybase@datacheck-3 install]$ ls RUN_*
RUN_sybase
[sybase@datacheck-3 install]$ chmod 755 RUN_sybase
chmod: changing permissions of ‘RUN_sybase’: Operation not permitted
[sybase@datacheck-3 install]$ exit
[root@datacheck-3 ~]# cd /tmp/sybase/ebf28476/
archives/            setup.bin            sysam_utilities/
sample_response.txt  sysam_setup/         ThirdPartyLegal/
[root@datacheck-3 ~]# cd /tmp/sybase/ebf28476/
archives/            setup.bin            sysam_utilities/
sample_response.txt  sysam_setup/         ThirdPartyLegal/
[root@datacheck-3 ~]# echo $S
$SAP_JRE7         $SCC_JAVA_HOME    $SSH_CLIENT       $SYBASE_JRE_RTDS
$SAP_JRE7_32      $SECONDS          $SSH_CONNECTION   $SYBASE_OCS
$SAP_JRE7_64      $SHELL            $SSH_TTY          $SYBASE_WS
$SAP_JRE8         $SHELLOPTS        $SYBASE           $SYBROOT
$SAP_JRE8_64      $SHLVL            $SYBASE_ASE       
[root@datacheck-3 ~]# echo $SYBASE
/opt/sybase
[root@datacheck-3 ~]# cd /opt/sybase/
[root@datacheck-3 sybase]# cd ASE-15_0/install/
[root@datacheck-3 install]# chmod 755 RUN_sybase
[root@datacheck-3 install]# chown sybase:sybase RUN_sybase
[root@datacheck-3 install]# su sybase
[sybase@datacheck-3 install]$ ll
total 13392
-rwxr-xr-x 1 sybase sybase  2377917 Jul 30  2019 auditinit
-rwxr-xr-x 1 sybase sybase 11174776 Jul 30  2019 auditinit.sym
-rwxr-xr-x 1 sybase sybase      541 Jul  3 10:00 RUN_sybase
-rwxr-xr-x 1 sybase sybase     4192 Mar 20  2019 setperm_all
-rwxr-xr-x 1 sybase sybase      825 Aug 14  2019 showserver
-rw-r--r-- 1 root   root       1773 Jul  3 09:57 sqlsrv.res
-rwxr-xr-x 1 sybase sybase    15722 Aug 14  2019 startserver
-rw-r----- 1 root   root     113083 Jul  5 00:24 sybase.log
-rwxr-xr-x 1 sybase sybase     1715 Aug 14  2019 sybhauser
drwxrwxr-x 3 sybase sybase       19 Jul  2 17:19 veritas
[sybase@datacheck-3 install]$ ./startserver -f RUN_sybase 
[sybase@datacheck-3 install]$ 00:0000:00000:00000:2025/07/08 11:43:16.49 kernel  kcinit: couldn't open error log file 1'/opt/sybase/ASE-15_0/install/sybase.log'.

[sybase@datacheck-3 install]$ exit
[root@datacheck-3 install]# chown -R sybase:sybase ../install/
[root@datacheck-3 install]# ll
total 13392
-rwxr-xr-x 1 sybase sybase  2377917 Jul 30  2019 auditinit
-rwxr-xr-x 1 sybase sybase 11174776 Jul 30  2019 auditinit.sym
-rwxr-xr-x 1 sybase sybase      541 Jul  3 10:00 RUN_sybase
-rwxr-xr-x 1 sybase sybase     4192 Mar 20  2019 setperm_all
-rwxr-xr-x 1 sybase sybase      825 Aug 14  2019 showserver
-rw-r--r-- 1 sybase sybase     1773 Jul  3 09:57 sqlsrv.res
-rwxr-xr-x 1 sybase sybase    15722 Aug 14  2019 startserver
-rw-r----- 1 sybase sybase   113083 Jul  5 00:24 sybase.log
-rwxr-xr-x 1 sybase sybase     1715 Aug 14  2019 sybhauser
drwxrwxr-x 3 sybase sybase       19 Jul  2 17:19 veritas
[root@datacheck-3 install]# su sybase
[sybase@datacheck-3 install]$ ./startserver -f RUN_sybase 
[sybase@datacheck-3 install]$ 00:0000:00000:00000:2025/07/08 11:44:03.75 kernel  dopen: open '/opt/sybase/data/master.dat', Permission denied
^C
[sybase@datacheck-3 install]$ ^C
[sybase@datacheck-3 install]$ ./startserver -f RUN_sybase ^C
[sybase@datacheck-3 install]$ exit
[root@datacheck-3 install]# chown -R sybase:sybase /opt/sybase
[root@datacheck-3 install]# su sybase
[sybase@datacheck-3 install]$ ./startserver -f RUN_sybase 

[sybase@datacheck-3 install]$ 
[sybase@datacheck-3 install]$ 
[sybase@datacheck-3 install]$ showserver
F S UID        PID  PPID  C PRI  NI ADDR SZ WCHAN  STIME TTY          TIME CMD
0 S sybase   10417 10416 82  80   0 - 161813 futex_ 11:44 ?       00:00:10 /opt/sybase/ASE-15_0/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-15_0/install/sybase.log -c/opt/sybase/ASE-15_0/sybase.cfg -M/opt/sybase/ASE-15_0 -i/opt/sybase -ssybase
[sybase@datacheck-3 install]$ isql -U sa -P 123456 -S sybase -J utf8
1> [sybase@datacheck-3 install]$

posted @ 2025-08-29 14:42 零の守墓人閱讀(11) 評論(0) 收藏舉報

刷新頁面返回頂部

zreo2home

Oracle 和 Sybase ASE 數據庫關閉后的啟動

Oracle 和 Sybase ASE 數據庫關閉后的啟動

1. Oracle

1.1 啟動

1.2 啟動監聽器

2. Sybase

2.1 啟動

公告