Closed. This question is not about programming or software development . It is not currently accepting answers.
This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers . If you believe the question would be on-topic on another Stack Exchange site , you can leave a comment to explain where the question may be able to be answered.
Closed 7 days ago.
Improve this question
i'm following this guide : https://techdocs.broadcom.com/content/dam/broadcom/techdocs/symantec-security-software/information-security/data-loss-prevention/generated-pdfs/Symantec_DLP_15.x_Oracle19c_Implementation_Guide.pdf
when i try to create the Oracle user account for Symantec Data Loss Prevention on Windows i get the error you an find in the capture; i used the command sqlplus /nolog @oracle_create_user.sql and i got the following error
c:\temp\Oracle\tools>sqlplus /nolog @oracle_create_user.sql
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 3 15:39:51 2022 Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Please enter the password for sys user: Please enter Oracle service name:protect Please enter required username to be created : protect Please enter a password for the new username: SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]] where ::= [/][@<connect_identifier>] ::= [][/][@<connect_identifier>] SP2-0640: Not connected SP2-0640: Not connected SP2-0640: Not connected SP2-0640: Not connected
press to see the error
does anyone know how i can solve this issue ?
1条答案
按热度按时间p1iqtdky1#
您正在连接到ORACLE而未登录（/nolog），所以你不能在“未验证”下执行脚本......如果你是在服务器上运行，尝试
sqlplus / as SYSDBA或sqlplus SYS as SYSDBA，然后如果你是在最新的ORACLE下运行你应该选择PDB与alter session set container = PDB_NAME;，然后您可以执行该脚本。您可以使用show pdbs列出PDB。如果您执行该脚本而不选择PDB，则将在CDB级别创建用户，这可能不是预期的结果。