TNS easy connection
=====================
1. sqlplus islbas/islbas@10.11.201.142/stlbas (if port is default 1521)
2. sqlplus islbas/islbas@10.11.201.142:1522/stlbas
3. connect to a URL using the Easy Connect Syntax
sqlplus islbas/islbas@//10.11.201.142:1521/stlbas
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Index Usage – 21 week ago
-
-
-
-
-
-
-
-
Oracle Cloud & Third party tools3 years ago
-
-
-
Moving Sideways7 years ago
-
Upcoming Events...10 years ago
-
2 comments:
Good Afternoon Mr. H. Abdul,
How will you withdraw previliges from user scott in oracle 10g so user can login as scott with password tiger but it should not be able to change the pasword at sql prompt (SQL>) usin password command.
Please tell me...
my email id is as given below
rlsrathore@yahoo.com, rlsrathore@gmail.com
Thanks Mr. rlsrathore
I think the following topic can solve this.
if user have connect privilige the he can access to database. but for "Password" command,
You need see following topic.
http://halimdba.blogspot.com/2009/10/disable-sql-and-sqlplus-commands-in.html
Post a Comment