Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

19c (19.3) stand-alone database installation

2025-01-15 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

3.3. Run the root.sh script [root@adg19c ~] # / DBSoft/oraInventory/orainstRoot.sh Changing permissions of / DBSoft/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world. Changing groupname of / DBSoft/oraInventory to oinstall.The execution of the script is complete. [root@adg19c] # / DBSoft/oracle/product/19.3/dbhome_1/root.shPerforming root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / DBSoft/oracle/product/19.3/dbhome_1 Enter the full pathname of the local bin directory: [/ usr/local/bin]: Copying dbhome to / usr/local/bin... Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Creating / etc/oratab file...Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Oracle Trace File Analyzer (TFA-Standalone Mode) is available at: / DBSoft/oracle/product/19.3/dbhome_1/bin/tfactl Note: 1.tfactl will use TFA Service if that service is running and user has been granted access2. Tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed IV. Create a monitor

Fifth, create a database

Create a PDBs [oracle@adg19c ~] $sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0-Production on Thu Mar 12 06:43:25 2020Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0-ProductionVersion 19.3.0.0.0 SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO SQL > create pluggable database pdbwoo from pdb file_name_convert= ('pdb/' 'pdbwoo/') Pluggable database created. SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO 4 PDBWOO MOUNTED SQL > alter pluggable database all save state Pluggable database altered. SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB READ WRITE NO 4 PDBWOO READ WRITE no. 7. Check the listening registration status [oracle@adg19c ~] $lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0-Production on 12-MAR-2020 06:53:55Copyright (c) 1991 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=adg19c) (PORT=1521)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for Linux: Version 19.0.0.0.0-ProductionStart Date 12-MAR-2020 06:17:19Uptime 0 days 0 hr. 36 min. 36 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / DBSoft/oracle/product/19.3/dbhome_1/network/admin/listener.oraListener Log File / DBSoft/oracle/diag/tnslsnr/adg19c/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=adg19c) (PORT=1521)) (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=adg19c) (PORT=5500)) (Security= (my_wallet_directory=/DBSoft/oracle/admin/woo/xdb_wallet)) (Presentation=HTTP) (Session=RAW) Services Summary...Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...Service "a09cefc7b6a2b892e0536354a8c08331" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...Service "a09cfefe92a3b95de0536354a8c024a2" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...Service "pdb" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...Service "pdbwoo" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...Service "woo" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...Service "wooXDB" has 1 instance (s). Instance "woo", status READY, has 1 handler (s) for this service...The command completed successfully

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report