To create your new template, Database Configuration Assistant (DBCA) connects to the database whose structure or data you are using as a basis for the template.
The fields available on this page vary depending on whether you are using an existing database (structure only) or an existing database (structure as well as data).
If you are creating a template based on the structure, but not the data, of a source database, then use the Username and Password fields to enter the credentials for a user with the DBA role. For example, you can use the SYSTEM user to connect to the database.
Use the Service field to specify the connection string for the database. Use the following format when specifying the service name:
<host>:<port>:<SID>
For example:
mgmt2.example.com:1521:salesdb3
If you are creating a template based on the structure as well as the data of an existing database, then select the database from the drop-down menu. Only local databases that are installed on the local host computer are available in the menu.
If you are running DBCA from an account that is not part of the dba group (UNIX or Linux) or that is not a member of the ORA_DBA or ORA_SID_DBA user group (Windows), then DBCA also prompts you for a database username and password.
If the Username and Password fields appear in addition to the drop-down menu of available databases, you must enter the credentials for a database account with SYSDBA privileges before you can proceed.
For more information about the operating system accounts that you can use to manage your database, see the Oracle Database Administrator's Guide.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.