Skip to main content
SnapManager for SAP

Create repositories

Contributors

SnapManager requires a repository on a host to hold data about the operations you perform.

What you'll need

Ensure that the following tasks are completed:

Steps
  1. Create an Oracle user and password in the repository database.

  2. Authorize user access to the repository.

For a repository, SnapManager for SAP requires a minimum 4K block size for the tablespace into which it is installed. You can check the block size using the following SQL command:

select a.username, a.default_tablespace, b.block_size
from dba_users a, dba_tablespaces b
a.username = repo_user

where

  • a.default_tablespace = b.tablespace_name

  • a.username = the user name on the repository

About this task

If you are upgrading repositories, you must reboot the SnapManager server to restart any associated schedules.

Step
  1. To create the repository, enter the repository create command, using the following general format:

    smsap repository create -repository -dbname repo_service_name -host repo_host -login -username repo_username -port repo_port [-force] [-noprompt] [-quiet | -verbose]

    Where:

    • -repository -dbname is the name of the repository database.

    • -host is the name of the host for the repository.

    • -username is the name of the database user who has access to the repository.

    • -port is the port for the host. Other options for this command are as follows:

      [-force] [-noprompt]

      [quiet | -verbose]

Note If you have an existing repository with the same name and you use the -force option, all data within an existing repository schema will be overwritten.

Creating a repository

The following command line creates a repository.

smsap repository create -repository -dbname HR1
-host server1 -login -username admin -port 1521