CodePudding user response:
You can see my name is former installation, but the oracle login interface
CodePudding user response:
Installation method is according to the website tutorial Ann, the results are wrong
http://blog.csdn.net/u010004460/article/details/52077367
Ask god to help ah I want to use PLSQL operation
CodePudding user response:
The instance name is the former
CodePudding user response:
See tnsnames. Ora file is how configuration
CodePudding user response:
Try TNSPING
Then look up SQLPLUS can log in
CodePudding user response:
reference 4 floor jdsnhan response: tnsnames. See how ora file configuration Directly from the oracle files inside dbhome_1 tnsnames. Ora copied CodePudding user response:
reference 5 floor sych888 reply: TNSPING try Then see if up SQLPLUS can log in I used the DOS interface input up sqlplus and then enter the user name Scott, password tiger, and then can go CodePudding user response:
reference zhuh1 reply: 3/f instance name is former Boon boon, PLSQL login box "database" option should be displayed on the former CodePudding user response:
refer to 7th floor java_shuaihua response: Quote: refer to fifth floor sych888 response: Try TNSPING Then see if up SQLPLUS can log in I used the DOS interface input up sqlplus and then enter the user name Scott, password tiger, then can enter Using DOS landed, plus service name In addition, your PLDEV is a 32 bit? A 64 - bit? CodePudding user response:
references 9 f sych888 response: Quote: refer to 7th floor java_shuaihua response: Quote: refer to the fifth floor sych888 reply: Try TNSPING Then see if up SQLPLUS can log in I used the DOS interface input up sqlplus and then enter the user name Scott, password tiger, then can enter Using DOS landed, plus service name In addition, your PLDEV is a 32 bit? A 64 - bit? I also tried: Scott, enter the user name password tiger @ former, so also can enter PLDEV? I don't know, but PLSQL the tool only 32 bits CodePudding user response:
Have a great god can give answer it for me? CodePudding user response:
Can only tell you, check the TNS CodePudding user response:
The refer to 12 floor A_A_apan reply: can only tell you, check the TNS Such as my instance name is former Then I tnsnames. Just write this ora? Former= (the DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(TCP) PROTOCOL=(HOST=127.0.0.1) (1521) PORT=) ) (CONNECT_DATA= https://bbs.csdn.net/topics/(SERVICE_NAME=former) ) ) CodePudding user response:
The former case sensitive? CodePudding user response:
Add an environment variable: TNS_ADMIN to a tnsnames file directory Such as C: \ Users \ Lenovo> Echo TNS_ADMIN % % E: \ app \ Lenovo \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN CodePudding user response:
Environment variables, and then give PLSQL specified path, in the preferences CodePudding user response:
reference 15 floor jdsnhan response: add an environment variable: TNS_ADMIN to a tnsnames file directory Such as C: \ Users \ Lenovo> Echo TNS_ADMIN % % E: \ app \ Lenovo \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN Thank you, Environment variable pointing here and PLSQL points to address in the preferences, whether oracle database dbhome_1/NETWORK/ADMIN tnsnames, or oracle client instantclient_11_2/NETWORK/ADMIN? CodePudding user response:
reference 16 floor zhuh1 response: environment variables, and then give PLSQL specified path, in the preferences All of these operations CodePudding user response:
refer to the 18th floor java_shuaihua response: Quote: refer to the 16th floor zhuh1 response: Environment variables, and then give PLSQL specified path, in the preferences All of these operations had You send a screenshot you login screen with an error to look at CodePudding user response:
references the 19th floor zhuh1 response: Quote: refer to the 18th floor java_shuaihua response: Quote: 16 reference building zhuh1 response: Environment variables, and then give PLSQL specified path, in the preferences All of these operations had You send a screenshot you login screen with an error to see You with former or at the wrong CodePudding user response:
references the 19th floor zhuh1 response: Quote: refer to the 18th floor java_shuaihua response: Quote: 16 reference building zhuh1 response: Environment variables, and then give PLSQL specified path, in the preferences nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull