When creating a new data archive, why does the system show the following error message ora-12518

tnt_luxing

When creating a new data archive, why does the system end up with the following error message:
D:\oracle\ora90\BIN\launch.exe D:\oracle\ora90\assistants\dbca dbca.cl -progress_only -createDatabase -templateName Transaction_Processing.dbc -gdbName OEMREP -sid OEMREP
Connecting to SYS ...
Connecting to SYS @ MY-TOMATO: 1521: OEMREP ...

>;>;>; Connection failed
>;>;>; Reason: ORA-12518: TNS: listener cannot distribute client connection
Processing failed.

Reason for system prompt: ORA-12518: TNS: listener cannot distribute client connection
What is the reason?
Thank you everyone

panda_ren

Is the sid set?
Is there any other oracle version on the machine?

tnt_luxing

No ... SID was automatically generated by her, right?

whbilly

The sid needs to be set by yourself, as well as the connection string in the tnsnames.ora file, the listener.ora, and the sid must be consistent. There are many online examples.

tnt_luxing

I created a new database by creating a new profile ...........

panda_ren

Is there a problem with oracle installation?
Try again

tnt_luxing

......... didn't you all show up?