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:
Se non viene definite tablespace permanente e temporanea
Oracle...
Script:
Dato il nome di una vista ricava informazioni su tipo e attributi della colonna di riferimenti
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
for i in 1.. strutture di controllo
Oracle...
Tip:
Lunghezza massima nome di uno schema nel database Oracle
Oracle...
Faq:
Come individuare a quale tablespace appartiene una tabella?
Shell scripting...
Script:
Script for archiving and compressing folder and file
A User Agent, like a web browser, uses HTTP to request a HTML document
Php Funzione mail()
In programming the danger of exploring the small details of coding is that you get obsessed with every line of code you write, thereby greatly reducing productivity.
In general, is not worth obsessing over code. On the other hand you should code with deliberation and intent. Steven Feurstein Oracle Magazine July /August 2004 A User Agent, like a web browser, uses HTTP to request a HTML document
|
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:
dbms_output.put_line
Anger is creative, depression is useless.
Dyson, Freeman J. Anger is creative, depression is useless.
Dyson, Freeman J.
Oracle...
Info:
Oracel shared server: session memory
Oracle...
Citazioni:
Designing an efficient Schema ...
Oracle...
Definizioni:
Area PGA
Oracle...
Definizioni:
Area PGA
Shell scripting...
Script:
Debug shell program
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 |