-
Title
Running ora_cleansp results in “Invalid Database name. Please check connection.yaml file” -
Description
The following errors are observed when running ora_cleansp:
$ ora_cleansp <username>/<password>
Invalid Database name. Please check connection.yaml file
Usage: ora_cleansp database_name/username[/password]
Not cleaning: exiting
[1] + Done
-
Cause
Either an incorrect database name is specified or no database name is specified as a parameter to the command. -
Resolution
As a preface, I will first collect the info on database name and SharePlex user name as follows.
While in vardir/data subdirectory, I can view the file connections.yaml which has the details of the SharePlex schema and the database name (here $ refers to OS prompt and vardir refers to SharePlex's variable directory):
$cat connections.yaml
o.ORA11GR2:
database: ORA11GR2
dstype: oracle
oracle_home: /oradata/products/11204
password: nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
plugin_direction: both
plugin_version: 1
service_name: ORA11GR2
tns_alias: ORA11GR2
user: PAUL92137[ORA11GR2@alvsupl14]/home/paul>
If you look at the above, my database name is ORA11GR2 and the SharePlex user (schema) in the database is PAUL92137. With this info as reference, we will illustrate two of the common reasons for seeing the above error:
Cause 1:
Incorrect database name specified as the parameter to the command.
Resolution 1:
To correct the problem, run it with correct database name. For example, the following error occurs when incorrect database name ORA is specified:
[ORA11GR2@alvsupl14]/home/paul> ora_cleansp ORA/paul92137/paul
Invalid Database name. Please check connection.yaml file
Usage: ora_cleansp database_name/username[/password]
Not cleaning: exiting
[ORA11GR2@alvsupl14]/home/paul>
I then issue the command with correct database name ORA11GR2 and it succeeds as below:
[ORA11GR2@alvsupl14]/home/paul> ora_cleansp ORA11GR2/paul92137/paul
Are you sure you want to perform the clean for '/home/paul/p92137-11g/var' and port 9237? [N] : y
Cleaning SharePlex's Internal tables
Cleaning /home/paul/p92137-11g/var subdirectories
To clean a replication stream, run ora_cleansp on the source and on all targets
Cause 2:
No database name is specified
Resolution 2:
To correct the problem, run it with a database name. For example, the following error occurs when no database name is specified:
[ORA11GR2@alvsupl14]/home/paul> ora_cleansp paul92137/paul
Invalid Database name. Please check connection.yaml file
Usage: ora_cleansp database_name/username[/password]
Not cleaning: exiting
[1] + Done
I then issue the command with a database name ORA11GR2 (instead of omitting the database name as a parameter to the command) and it succeeds as below:
[ORA11GR2@alvsupl14]/home/paul> ora_cleansp ORA11GR2/paul92137/paul
Are you sure you want to perform the clean for '/home/paul/p92137-11g/var' and port 9237? [N] : y
Cleaning SharePlex's Internal tables
Cleaning /home/paul/p92137-11g/var subdirectories
To clean a replication stream, run ora_cleansp on the source and on all targets
-
Additional Information
Try to stick to the proper case (upper or lower) for the SID and SharePlex user as listed in the connections.yaml as much as possible when running ora_cleansp to avoid the chances for any error. Starting with SharePlex 9.2.1, a database name needs to be provided as a parameter to the command. This was not the case in prior versions. This could be a common pitfall as users may forget to include the database name in the command.