Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Info:
EXPLAIN PLAN statement
Oracle...
Script:
Opzione DEFAULT per il valore di una colonna
Unix...
Tip:
Eseguire pił comandi in una sola linea
PLSQL...
Script:
Errori
Oracle...
Tip:
LICENCE_MAX_USERS
Oracle...
Faq:
Come individuare a quale tablespace appartiene una tabella?
Shell scripting...
Script:
if e else
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
Php Funzione mail()
XPath is a language for addressing parts of an XML document.
It is designed to be used by XSLT and XPointer.
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
|
Oracle
Home >Oracle > sqlplus how conennect without tnsnames descriptor entry
If you need to connect a user to a remote or local database with sqlplus but for some reasons tnsnames.ora is not configured or the user does not have access to it. 1) Indicating host name and service name (make sure you are using the righ service name)
nagios@Sun1:~$
$ORACLE_HOME/bin/sqlplus nagios/mypassword@sun2.fishscript.com:1521/DB012.sun2.fishscript.com
2) Defining the sqlnet descriptor on the sqlplus command
nagios@Sun1:~$ sqlplus "nagios/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=sun2.fishscript.com)(Port=1521))(CONNECT_DATA=(SID=DB012)))"
Example:
nagios@Sun1:~$ sqlplus "nagios/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=sun2.fishscript.com)(Port=1521))(CONNECT_DATA=(SID=DB012)))"
SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 23 16:51:47 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: Wed Sep 23 2015 09:41:31 +01:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Codici errore ![]() ![]() ![]() ![]() ![]() |
Cerca
Oracle...
Info:
Spazio su disco per motore Oracle 10g
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
Oracle...
Info:
SHARED_SERVER
Oracle...
Citazioni:
Designing an efficient Schema ...
Oracle...
Definizioni:
Variabile bind
Oracle...
Definizioni:
Transazione
Shell scripting...
Script:
Array
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |