Question
What are the steps required to setup the Oracle instance for OS Authentication

Answers

To setup the Oracle instance of the OS Authentication feature. The steps that have to be followed are:1. Open the INIT[sid].ORA file from the config directory of the web logic server.2. Add the line OS_AUTHENT_PREFIX = OPS$ in the file INIT[sid].ORA file and as the statements are case sensitive so the statements should be written as it is. 3. Open the database of Oracle server by using the credentials of the SYSTEM. 4. Create a user using the name of OPS$userid, where userid is the name of operating system loginID. Grant the full privileges to the user for connection and using the resources on the server. 5. After setting up the connection with the made user then the Web logic jDriver for Oracle can be connected by using the “/” as the username property and “” as the password property. The example is given below:$ java utils.dbping ORACLE "/" "" userserverProperties props = new Properties();props.put("user", "/");props.put("password", "");props.put("server", "userserver");Class.forName("weblogic.jdbc.oci.Driver").newInstance();Connection conn = myDriver.connect("jdbc:weblogic:oracle",props);   Your Comment




More Software Questions..
What is the inputsplit in map reduce software?

What is software configuration management?

What Is Java Api For Xml-based Rpc (jax-rpc)?

How can you implement fine-grained auditing?

What is IBM’s simple explanation for Big Data’s four critical features?

What is static synchronized method in JDBC API? Give an example?

What does the NULLIF function do?

What happens if a start method is not invoked and the run method is directly invoked?

Should we override finalize method

what is the difference between mysql_fetch_array and mysql_fetch_object?

How will XML affect my document links?

Why to use Style Sheets?

What are Filters in MVC?

Can you explain Application layer in OSI model?

How to define new testplan attributes?

What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?

Which oracle package is used to manage the oracle lock management services?

What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?

What is marker interface?

What types of partitioning are there for BW?



Search
Can you Answer!!
  • Q After successful recovery of the original database a new .dbf file is created. What is the procedure for transferring data from this temporary file to a database?
  • Q Manu National Park Peru has 1300 different species of what
  • Q Which Maratha revolutionary leader revived the Ganapati and Shivaji festivals ?
  • Q Why do protons and neutrons stay together in the nucleus?
  • Q 4,10,8,14,12,18,?
  • Q What country consumes the most coffee per capita 25 Lb
  • Q The subconscious tendency we all have to complete stories with information drawn from our everyday experiences is known as: (A)Preliminary problem identification (B)Non-empathic response (C)Schema theory (D)Premature diagnosis (E)Filling in phenomenon
  • Q Four new fish species, Puntius nelsoni, Puntius nigronotus, Systomus chryseus and Systomus rufus were discovered in which state?
  • Q Abhishek Verma belongs to which sport?
  • Q Lee de Forest discovered the?
  • Q The second Anglo Maratha war took place in the year: