Скачал с офф сайта готовый образ со всеми пакетами для администрирования БД, но не могу зайти в sqlplus. Прошу не кидаться камнями. при вводе sqlplus почта указанная при заходе в терминал и на раб. столе в файле readme выводит следущее
* All passwords are oracle or noted if otherwise.
* All the Hands on Labs can be accessed by opening the ODDHandsOnLabs.html file on the Desktop.
* Oracle SQL Developer, Data Modeler, SQLcl and Rest Client can be found in the desktop menu Applications/Other.
The SQL Developer and Data Modeler scripts are in the directory:
/home/oracle/Desktop/Database_Track/sqldevdm
and
/home/oracle/Desktop/Database_Track/sqldev
The Application Express scripts are in the directory:
/home/oracle/Desktop/APEX_Track/files
To Reset the labs:
SQL Developer: /home/oracle/reset_sqldev (includes ORDS, Data Modeler, Unit Test)
Application Express: /home/oracle/reset_apex
REST Data Services : /home/oracle/reset_rest (APEX related)
SODA4REST : /home/oracle/reset_soda4rest
Soup to Nuts : /home/oracle/reset_soup
— APEX Labs Only /home/oracle/reset_soup_apex_only
Database Information:
Oracle SID : orclcdb
Pluggable DB : orcl
Pluggable DB : ords create if required by running:
'newpdbords' in the terminal - for ORDS pdb creation.
(if 'sqlplus system/
oracle@ORDS' connects ORDS pdb has already been installed)
'loadstorm' in the terminal for spatial demo data - takes a few minutes.
ALL PASSWORDS ARE : oracle
*** Please note that this appliance is for testing purposes only,
as such it is unsupported and should not be used as a production environment.
///////////////////////////////
при вводе sqlplus выдаёт следущее и выкидывает обратно в терминал(т.е служба sql не запускается)
oracle@localhost ~]$ sql * plus /nolog
Oracle SQL Developer Command-Line (SQLcl) help
Usage 1: sql -H | -V
-H Displays the SQLcl version and the
usage help.
-V Displays the SQLcl version.
Usage 2: sql [<option>] [{ <logon> | /nolog}] [<start>]
<option> is: [-R <level>] [-S] [-verbose] [-oci] [-L[OGON] ]
-R <level> Sets restricted mode to disable SQLcl commands
that interact with the file system. The level can
be 1, 2, 3 or 4. The most restrictive is -R 4 which
disables all user commands interacting with the
file system.
-S Sets silent mode which suppresses the display of
the SQLcl banner, prompts, and echoing of
commands.
-verbose Set this to show logging messages inline.
By default these messages are suppressed.
-nohistory Switch off history logging.
-noupdates Do not check update site for newer versions available.
-oci Set this to use an Oracle Instant Client installation.
If this option is set, then SQLcl will use the drivers
from the first Installation on the path.
-L[OGON] Specifies not to reprompt for username or password
if the initial connection does not succeed.
<logon> is: {<username>[/<password>][@<connect_identifier>] | / }
[AS {SYSDBA | SYSOPER | SYSASM}]
Specifies the database account username, password and connect
identifier for the database connection. Without a connect
identifier, SQLcl connects to the default database.
The AS SYSDBA, AS SYSOPER and AS SYSASM options are database
administration privileges.
<connect_identifier> can be in the form of Net Service Name
or Easy Connect.
@[<net_service_name> | [//]Host[:Port]/<service_name>]
<net_service_name> is a simple name for a service that resolves
to a connect descriptor.
Example: Connect to database using Net Service Name and the
database net service name is ORCL.
sql myusername/
mypassword@ORCL
Host specifies the host name or IP address of the database
server computer.
Port specifies the listening port on the database server.
<service_name> specifies the service name of the database you
want to access.
Example: Connect to database using Easy Connect and the
Service name is ORCL.
sql myusername/
mypassword@Host/ORCL
The /NOLOG option starts SQLcl without connecting to a
database.
<start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
Runs the specified SQLcl script from a web server (URL) or the
local file system (filename.ext) with specified parameters that
will be assigned to substitution variables in the script.
When SQLcl starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run. The files may
contain SQLcl commands.
Refer to the SQLDeveloper User's Guide and Reference for more information.
[
oracle@localhost ~]$
///////////////////////////
при вводе [
oracle@localhost ~]$ sqlplus system/
oracle@ORDS
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 6 10:20:58 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved. и нет строки sql или ещё чего-то просто весит пока не введшь команду ctrl+z/c
/////
В итоге из вариантов обратится на форум, мониторить интернет, или работать в sql developer, в последнем случае по идее позволяет работать с теми же инструментами sql / PL/SQL, первое наиболее быстро разобраться с проблемой и получить нужный експириенс
