Oracle

https://docs.oracle.com/en
Admin
Oracle provides integrated cloud infrastructure, database management systems, and enterprise...
Tokens:20,176,786
Snippets:164,714
Trust Score:9.1
Update:1 week ago
Show doc for...
Tokens:
Raw
### Installer output example

Source: https://docs.oracle.com/en-us/iaas/management-agents/doc/install-management-agent-chapter.html

Example output from running installer.sh, showing the installation and configuration steps and the final success message.

```bash
Checking pre-requisites
Checking if any previous agent service exists
Checking if OS has systemd or initd
Checking available disk space for agent install
Checking if /opt/oracle/mgmt_agent directory exists
Checking if 'mgmt_agent' user exists
'mgmt_agent' user already exists, the agent will proceed installation without creating a new one.
Checking Java version
Trying /opt/jre21
Java version: found at /opt/jre21/bin/java
Checking agent version
Executing install
Unpacking oracle.mgmt_agent-260722.4208.aix.zip using custom utility
Java environment validated: /opt/jre21
Copying files to destination dir (/opt/oracle/mgmt_agent)
Initializing software from template
Checking if JavaScript engine is available to use
Creating mgmt_agent daemon
Agent Install Logs: /opt/oracle/mgmt_agent/installer-logs/installer.log.0
Agent install successful
Executing configure
Parsing input response file
Validating install key
Generating communication wallet
Generating security artifacts
Registering Management Agent
Starting agent...
Agent started successfully
Agent setup completed and the agent is running.
In the future agent can be started by directly running: sudo startsrc -s mgmt_agent
Please use OCI CLI or OCI Management Agent console to validate the successful activation of your agent.
Please make sure that you delete /full/path/to/input.rsp or store it in secure location.
```

--------------------------------

### List install steps with install.sh

Source: https://docs.oracle.com/en/engineered-systems/zero-data-loss-recovery-appliance/19.2/amogd/software.html

List the steps that need to be run using the install utility. This example uses an XML file named ExadataConfigurations/Example_Inc-ra01.xml.

```bash
$ ./install.sh -cf ExadataConfigurations/Example_Inc-ra01.xml -l
```

--------------------------------

### Start full-tier installation with psft-dpk-setup.sh

Source: https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.32/odavm/index.html

Starts the full-tier installation in silent mode using the configured response file. The installer automatically installs all required components and extracts additional ZIP files as needed.

```bash
cd /root/soft/setup

./psft-dpk-setup.sh --silent --response_file=/root/soft/setup/fulltier.rsp
```

--------------------------------

### Kickstart File Example

Source: https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.32/odavm/index.html

Example kickstart file from an earlier manual installation with updated network information and a different root password.

```text
# Network information
network --bootproto=static --device=eth0 --gateway=ww.xx.yy.1 --ip=ww.xx.yy.zz --nameserver=aa.bb.cc.dd

```

--------------------------------

### Run a specific install step with install.sh

Source: https://docs.oracle.com/en/engineered-systems/zero-data-loss-recovery-appliance/19.2/amogd/software.html

Run a specific step (step 1) using the install utility. This example uses an XML file named ExadataConfigurations/Example_Inc-ra01.xml.

```bash
$ ./install.sh -cf ExadataConfigurations/Example_Inc-ra01.xml -s 1
```

--------------------------------

### Example kickstart file with network and root password

Source: https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.25/odavm/index.html

A sample kickstart file based on an existing Oracle Linux installation, with updated network information and a different root password. Store it as /var/www/html/ks.txt on the HTTP server.

```kickstart
# Network information
network --bootproto=static --device=eth0 --gateway=ww.xx.yy.1 --ip=ww.xx.yy.zz --nameserver=aa.bb.cc.dd --netmask=iii.iii.iii.iii --noipv6 --activate network --hostname=mykvmhost

# Root password
rootpw welcome1
```

--------------------------------

### Start and Enable libvirt Daemons

Source: https://docs.oracle.com/en/operating-systems/oracle-linux/9/kvm-user/kvm-ManageLibvirtdDaemons.html

Commands to start and enable the libvirt daemons on an Oracle Linux 9 KVM host. Requires virtualization packages installed and administrator privileges.

```bash
systemctl start libvirtd
systemctl enable libvirtd
```

--------------------------------

### Example Get Data Guide in Hierarchical Pretty Format

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_JSON.html

Example call to GET_INDEX_DATAGUIDE that returns the data guide in hierarchical format with pretty-printing. It uses table T1 and JSON column PO.

```sql
SELECT DBMS_JSON.GET_INDEX_DATAGUIDE(‘T1’, ‘PO’, DBMS_JSON.FORMAT_HIERARCHICAL, DBMS_JSON.PRETTY) 
FROM DUAL;
```

--------------------------------

### Install PostgreSQL server

Source: https://docs.oracle.com/en/cloud/paas/goldengate-service/ocigg/quickstarts/replicate-data-from-postgresql-to-atp.html

Command to install the PostgreSQL server as part of the environment setup for this quickstart. Run this before configuring the source database.

```bash
sudo yum install -y postgresql-server
```

--------------------------------

### setup-root-ssh example

Source: https://docs.oracle.com/en/bigdata/big-data-appliance/5.1/bigog/utilities.html

Example of running setup-root-ssh without parameters, prompting for the root password and showing the output of adding SSH keys to servers.

```bash
# setup-root-ssh
Enter root password: password
spawn /opt/oracle/bda/bin/dcli -c 192.168.42.37,192.168.42.38... -k
root@192.168.42.37's password:
root@192.168.42.38's password:
     .
     .
     .
192.168.42.37: ssh key added
192.168.42.38: ssh key added
     .
     .
     .
setup-root-ssh succeeded
```

--------------------------------

### get kv with prefix key path

Source: https://docs.oracle.com/en/database/other-databases/nosql-database/24.4/admin/get.html

Example of get kv with a prefix part of the major key path (/group) and -all -keyonly, returning all keys that start with that prefix.

```text
kv -> get kv -key /group -all -keyonly
/group/TC/-/user/bob
/group/TC/-/user/john
/group/TC/-/dep/IT
/group/SZ/-/user/steve
/group/SZ/-/user/diana
```

--------------------------------

### Example installer.sh command

Source: https://docs.oracle.com/en-us/iaas/management-agents/doc/install-management-agent-chapter.html

Example of running installer.sh with a response file and a specific service identifier.

```bash
sudo ./installer.sh /tmp/input.rsp mgmt_agent-oc1_phx-abc123
```

--------------------------------

### Install and start PostgreSQL server

Source: https://docs.oracle.com/en/cloud/paas/goldengate-service/ocigg/quickstarts/replicate-data-from-postgresql-to-mysql.html

Commands to install PostgreSQL server and required modules, create a database cluster, and enable/start the PostgreSQL service. Run these in order during environment setup.

```bash
sudo yum install postgresql-server
```

```bash
sudo yum install postgresql-contrib
```

```bash
sudo postgresql-setup --initdb
```

```bash
sudo systemctl enable postgresql.service
```

```bash
sudo systemctl start postgresql.service
```

--------------------------------

### Connect from Windows Start menu with SYS or / AS SYSDBA

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admqs/getting-started-with-database-administration.html

Example prompts shown when starting SQL*Plus from the Windows Start menu. Enter SYS or / as the user name followed by AS SYSDBA, then provide the password set up during installation.

```sqlplus
Enter user-name: SYS AS SYSDBA
Enter password: password

or

Enter user-name: / AS SYSDBA
```

--------------------------------

### List install steps

Source: https://docs.oracle.com/en/engineered-systems/zero-data-loss-recovery-appliance/19.2/amogd/software.html

Command and output listing all steps for the install utility.

```bash
$ ./install.sh -cf ExadataConfigurations/Example_Inc-ra01.xml -l
 
1. Validate Configuration File
2. Setup Required Files
3. Create Users
4. Setup Cell Connectivity
5. Verify Infiniband
6. Calibrate Cells
7. Create Cell Disks
8. Create Grid Disks
9. Configure Alerting
10. Install Cluster Software
11. Initialize Cluster Software
12. Install Database Software
13. Relink Database with RDS
14. Create ASM Diskgroups
15. Create Databases
16. Apply Security Fixes
17. Install Exachk
18. Setup ASR Alerting
19. Create Installation Summary
20. Resecure Machine
```

--------------------------------

### Get public link information with GET /documents/wcc/api/v1.1/publiclinks/{dLinkID}

Source: https://docs.oracle.com/en/cloud/paas/webcenter-content/webcenter-content-api/index.html

Request the public link information for a specific dLinkID using the GET /documents/wcc/api/v1.1/publiclinks/{dLinkID} endpoint. The response includes the link details such as dLinkID, dLinkType, dLinkName, and access code. The example uses the GUID LDC52C7174798C6814B965C92EE76E200DEE6410B78B.

```HTTP
GET …/documents/wcc/api/v1.1/publiclinks/LDC52C7174798C6814B965C92EE76E200DEE6410B78B
```

```JSON
Status = 200
Body
{
  “dLinkID”: “LDC52C7174798C6814B965C92EE76E200DEE6410B78B”,
  “dLinkType”: “fFileGUID”,
  “dLinkName”: “external_review”,
  “dLinkDesc”: “a link for external review”,
  “fItemGUID”: “29504F74B07E6AC3F5B01002007ACE90”,
  “fOwner”: “adminUser”,
  “dLinkPrivilege”: “R”,
  “dAssignedUsers”: “@everybody”,
  “dAccessCode”: “myaccesscode”,
  “dCreatedDate”: “2024-07-11 21:40:27Z”,
  “dLastModifiedDate”: “2024-07-11 23:09:30Z”,
  “dExpirationDate”: “2024-10-01 07:00:00Z”,
  “dCreator”: “adminUser”
}
```

--------------------------------

### Example: start the SQL shell

Source: https://docs.oracle.com/en/database/other-databases/nosql-database/26.1/sqlfornosql/running-sql-shell.html

Starts the SQL shell connecting to a store named kvstore at host node01 port 5000. After startup, the shell prompt sql-> appears.

```bash
java -jar KVHOME/lib/sql.jar
-helper-hosts node01:5000 -store kvstore
sql->
```

--------------------------------

### Example 12-24 Starting a Destination

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/adque/jms-basic-operation.html

Example 12-24: Starting a destination. Shows how to start both a topic and a queue using the AQjmsDestination start method.

```java
TopicSession t_sess;
QueueSession q_sess;
Topic        topic;
Queue        queue;

(AQjmsDestination)topic.start(t_sess, true, true);
(AQjmsDestination)queue.start(q_sess, true, true);

```

--------------------------------

### Setup Environment for Running JMS Types Examples

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/adque/jms-service-types-examples.html

SQL script to create the JMS user, queue tables, queues, and start them. Includes a utility procedure to display RAW data.

```sql
connect sys;
enter password: password

Rem 
Rem Create the JMS user: jmsuser
Rem

DROP USER jmsuser CASCADE;
CREATE USER jmsuser IDENTIFIED BY jmsuser;
GRANT EXECUTE ON DBMS_AQADM TO jmsuser;
GRANT EXECUTE ON DBMS_AQ TO jmsuser;
GRANT EXECUTE ON DBMS_LOB TO jmsuser;
GRANT EXECUTE ON DBMS_JMS_PLSQL TO jmsuser;


set echo offset verify offconnect sysDROP USER jmsuser CASCADE;ACCEPT password CHAR PROMPT 'Enter the password for JMSUSER: ' HIDECREATE USER jmsuser IDENTIFIED BY &password;GRANT DBA, AQ_ADMINISTRATOR_ROLE, AQ_USER_ROLE to jmsuser;GRANT EXECUTE ON DBMS_AQADM TO jmsuser;GRANT EXECUTE ON DBMS_AQ TO jmsuser;GRANT EXECUTE ON DBMS_LOB TO jmsuser;GRANT EXECUTE ON DBMS_JMS_PLSQL TO jmsuser;connect jmsuser/&password

Rem
Rem Creating five AQ queue tables and five queues for five payloads: 
Rem SYS.AQ$_JMS_TEXT_MESSAGE
Rem SYS.AQ$_JMS_BYTES_MESSAGE
Rem SYS.AQ$_JMS_STREAM_MESSAG
Rem SYS.AQ$_JMS_MAP_MESSAGE
Rem SYS.AQ$_JMS_MESSAGE
Rem

EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (Queue_table => 'jmsuser.jms_qtt_text', 
    Queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE', compatible => '8.1.0');
EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (Queue_table => 'jmsuser.jms_qtt_bytes', 
    Queue_payload_type => 'SYS.AQ$_JMS_BYTES_MESSAGE', compatible => '8.1.0');
EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (Queue_table => 'jmsuser.jms_qtt_stream', 
    Queue_payload_type => 'SYS.AQ$_JMS_STREAM_MESSAGE', compatible => '8.1.0');
EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (Queue_table => 'jmsuser.jms_qtt_map', 
    Queue_payload_type => 'SYS.AQ$_JMS_MAP_MESSAGE', compatible => '8.1.0');
EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (Queue_table => 'jmsuser.jms_qtt_general', 
    Queue_payload_type => 'SYS.AQ$_JMS_MESSAGE', compatible => '8.1.0');
EXECUTE DBMS_AQADM.CREATE_QUEUE (Queue_name => 'jmsuser.jms_text_que', 
    Queue_table => 'jmsuser.jms_qtt_text');
EXECUTE DBMS_AQADM.CREATE_QUEUE (Queue_name => 'jmsuser.jms_bytes_que', 
    Queue_table => 'jmsuser.jms_qtt_bytes');
EXECUTE DBMS_AQADM.CREATE_QUEUE (Queue_name => 'jmsuser.jms_stream_que', 
    Queue_table => 'jmsuser.jms_qtt_stream');
EXECUTE DBMS_AQADM.CREATE_QUEUE (Queue_name => 'jmsuser.jms_map_que', 
    Queue_table => 'jmsuser.jms_qtt_map');
EXECUTE DBMS_AQADM.CREATE_QUEUE (Queue_name => 'jmsuser.jms_general_que', 
    Queue_table => 'jmsuser.jms_qtt_general');

Rem
Rem Starting the queues and enable both enqueue and dequeue 
Rem
EXECUTE DBMS_AQADM.START_QUEUE (Queue_name => 'jmsuser.jms_text_que');
EXECUTE DBMS_AQADM.START_QUEUE (Queue_name => 'jmsuser.jms_bytes_que');
EXECUTE DBMS_AQADM.START_QUEUE (Queue_name => 'jmsuser.jms_stream_que');
EXECUTE DBMS_AQADM.START_QUEUE (Queue_name => 'jmsuser.jms_map_que');
EXECUTE DBMS_AQADM.START_QUEUE (Queue_name => 'jmsuser.jms_general_que');

Rem The supporting utility used in the example to help display results in SQLPLUS enviroment

Rem
Rem Display a RAW data in SQLPLUS
Rem
create or replace procedure display_raw(rdata raw)
IS
    pos                 pls_integer;
    length              pls_integer;
BEGIN
    pos := 1;
    length := UTL_RAW.LENGTH(rdata);
```

--------------------------------

### Example output of installed kernels

Source: https://docs.oracle.com/en/database/oracle/key-vault/21.15/okvig/upgrading-oracle-key-vault-earlier-21-x-release-multi-master-cluster-environment1.html

Example output showing two installed kernels.

```text
kernel-uek-4.14.35-2047.504.2.el7uek.x86_64 
kernel-uek-5.4.17-2136.329.3.1.el8uek.x86_64

```

--------------------------------

### START_SERVICE Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_SERVICE.html

Example call to START_SERVICE that starts the service named 'ernie.example.com' on the local instance.

```sql
DBMS_SERVICE.START_SERVICE('ernie.example.com');
```

--------------------------------

### Installer output for successful agent setup

Source: https://docs.oracle.com/en-us/iaas/management-agents/doc/install-management-agent-chapter.html

Sample output from a successful installation and configuration. Shows pre-requisite checks, installation steps, and final confirmation. Also notes that the response file should be deleted or stored securely.

```text
sudo ./installer.sh <user_home_directory>/input.rsp mgmt_agent-oc1_phx-abc123
Checking pre-requisites
	Checking if any previous agent service exists
	Checking if OS has systemd or initd
	Checking available disk space for agent install
	Checking if /opt/oracle/mgmt_agent-oc1_phx-abc123 directory exists
	Checking if 'mgmt_agent' user exists
	Checking Java version
		JAVA_HOME is not set or not readable to root
		Trying default path /usr/bin/java
		Java version: 1.8.0_282 found at /usr/bin/java
	Checking agent version

Executing install
	Unpacking software zip
	Copying files to destination dir (/opt/oracle/mgmt_agent-oc1_phx-abc123)
	Initializing software from template
	Checking if JavaScript engine is available to use
	Creating mgmt_agent-oc1_phx-abc123 daemon
	Agent Install Logs: /opt/oracle/mgmt_agent-oc1_phx-abc123/installer-logs/installer.log.0

Agent install successful

Executing configure

	Parsing input response file
	Validating install key
	Generating communication wallet
	Generating security artifacts
	Registering Management Agent

Starting agent...
Agent started successfully


Agent setup completed and the agent is running.
In the future agent can be started by directly running: sudo systemctl start mgmt_agent-oc1_phx-abc123

Please make sure that you delete <user_home_directory>/input.rsp or store it in secure location.
```

--------------------------------

### COUNT example with START and END

Source: https://docs.oracle.com/en/database/goldengate/core/26/logdump-ref/logdump-commands.html

Example of COUNT with START and END time options.

```logdump
COUNT START 2011-01-11 12:00:00 , END 2011-01-12 12:00:00
```
Tokens:
Raw