New answers tagged sqlplus
It looks like your ACCEPT prompt includes quotation marks. But quotation marks are also used to delimit the prompt string, so if you want to include those characters into the prompt, you need to double them: … prompt 'Fecha de inicio (''DD/MM/YYYY-HH24:MI:SS''): ' … prompt 'Fecha de fin (''DD/MM/YYYY-HH24:MI:SS''):' Although I think you could simply ...
If you try to login as a "normal user", run the command ". oraenv" from command line: [oracle@dba-db1 ~]$ . oraenv ORACLE_SID =  ? dbadb The Oracle base remains unchanged with value /x01 It will prompt for the Oracle SID (which you now from the person you tells you the information to connect to it. This script will then automatically set the corrent ...
$ alias sqs='sqlplus / as sysdba' $ sqs SQL*Plus: Release 220.127.116.11.0 Production on Wed Jun 15 20:33:31 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics and Real Application ...
use command prompt to connect to Oracle Db schema using the below syntax: sqlplus user/password@hostname:portnumber/Servicename
Add port listener 1521 in firewall: Inbound Rules and Outbound Rules. Add permissions in ORACLE_HOME in regedit: cmd → regedit → HKEY_LOCAL_MACHINE → SOFTWARE → ORACLE
i assume that you have installed oracle database 12c. if that's correct, you should can manage oracle database in website GUI. maybe you can open the url such as https://:5500/em which 5500 is the default port when you installed this oracle database. you can manage the database such as tablespace, users, and etc in there. i never installed it on windows to ...
You already have a database, so you don't need the 'create database'. Since you are working with a 12.1 database, you need to throw out your 10.2 docs and go to the 12.1 doc set. When you create a user, don't use that "@localhost' construct. Your simple 'create user foo identified by bar' is the correct syntax, but as @a1ex07 pointed out, you need to be ...
Set the ORACLE_SID and ORACLE_HOME variables properly. They must be in upper case letters. Second, share the content of directory. ORACLE_HOME/dbs
This answer based on a1ex07 comment: I gust put it here just in case that anyone will need it... given the folowing detailes: user name: demo password: Pass1234 ip: 22.214.171.124 listener port: 1521 oracle SID: orcl pdb service name: pdborcl connect to core db from db host as sysdba: without need of password: sqlplus / as sysdba password manually: sqlplus ...
Top 50 recent answers are included