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, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 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